Stairway to U-SQL Level 13: SQL.MAP
We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.
2017-03-01
1,580 reads
Data Lakes
Stairway to U-SQL Level 7: More Partition Schemes
Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.
2016-08-24
1,639 reads
RE: Reporting Services Programming Guideline
I like these books: Microsoft Reporting Services in Action by Teo Lachev Hitchhiker's Guide to SQL Server 2000 Reporting Services by Blackburn/Vaughn
2005-01-25
DB Design question
Hi everybody I would appreciate some help with the following design problem: The application is about documents with paragraphs. The documents are in a table, and each document consists of various paragraphs, which are also kept in a table. If a document is created using paragraphs 1, 13, 27 & 54, it is easy to […]
2005-01-25
RE: Get Previous Date
If you read closer, you'll notice that the conversion is on the parameter side, not the column itself - so indices will likely get used. It's the other way around that's the 'bad' way. And, any function may have the effect to invalidate index usage - it's not limited to convert only in any way.For […]
2005-01-05
RE: Split CSV file - this is different
Here's an expanded example showing how you could insert rows into a new table while parsing, or update existing rows with the parsed data.DROP TABLE SlowThinker GO DROP TABLE TheData GOCREATE TABLE SlowThinker ( id int PRIMARY KEY, ExData varchar(100) )CREATE TABLE TheData ( id int PRIMARY KEY, Col1 varchar(100), […]
2005-01-03
2004-11-24
Dropping and re-creating indexes
HiIf anyone can perhaps give some tips on dropping and re-creating indexes I woul appreciate it a lot. Is there a specific sequence in which one should drop and re-create the different types indexes?Thanks
2004-11-01
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers