Explore >> Select a destination
|
You are here 
|
ctoomey.com | ||
| | | | |
curatedsql.com
|
|
| | | | | ||
| | | | |
saeedesmaili.com
|
|
| | | | | I came across this Linkedin post from a Google engineer, on a new (in preview) and very interesting BigQuery syntax: GROUP BY ALL. This will save time when writing and specially modifying complex SQL queries on BigQuery. The GROUP BY ALL clause groups rows by inferring grouping keys from the SELECT items. It will exclude expressions with aggregate and window functions, constants, and query parameters for a smart GROUP BY. So instead of GROUP BY name, city, device, browser, date or GROUP BY 1, 2, 3, 4, 5 you would use GROUP BY ALL. | |
| | | | |
minhajuddin.com
|
|
| | | | | So, you have a ton of records to update in a really large table. Say, you need to update 3 million records in a table with 100 million rows. And, let's also assume that you have a way of finding these | |
| | | | |
blog.crossjoin.co.uk
|
|
| | | Within a matter of days, "Expert Cube Development with SSAS 2012 Multidimensional Models" will be published. It's the second edition of the very successful (19 5* reviews on Amazon US as of now) book on SSAS cube development that Marco, Alberto and I wrote a few years ago, updated for SSAS 2012. You can pre-order... | ||
