An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.
2014-09-08 (first published: 2013-06-28)
2,193 reads
Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.
2008-11-03 (first published: 2008-08-05)
2,192 reads
Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
2008-10-22 (first published: 2008-08-05)
1,152 reads
Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
2008-10-14 (first published: 2008-08-05)
1,033 reads
Feed it large strings of delimited horizontal data and it returns it back as a vertical table.
2008-08-05
1,399 reads
Feed it delimited horizontal data and it returns it back as a vertical table.
2008-10-20 (first published: 2008-08-05)
2,669 reads
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.
2008-08-05
1,047 reads
Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.
2008-08-05
477 reads
There is an even simpler and more elegant use the Coalsce() function to "Flatten" a column to a delimited string. I first saw the technique in an article in T-SQL Solutions. At first Glance, I could not believe that it would work, but it does and it performs better than using a cursor or while […]
2004-08-26
Hi John,Newbie or no, you are correct: you need those check constraints. But if you looke further back in this thread you'll see that we've discussed that a bit already. Friendly user mssql_rules has indicated that their view meets all those requirements for partitioned views, and that he can in fact update through them. If […]
2004-02-15
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers