Dynamic Columns with PIVOT Operator
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
1,973 reads
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
1,973 reads
Here is a stored procedure that start a job, and then waits until the jobs is finished
2009-06-02 (first published: 2009-05-14)
1,025 reads
2009-06-01 (first published: 2009-03-13)
1,911 reads
2009-06-01 (first published: 2009-04-28)
2,834 reads
Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!
2009-05-29 (first published: 2009-05-05)
906 reads
2009-05-27 (first published: 2009-04-30)
2,592 reads
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-26 (first published: 2009-04-23)
2,741 reads
2009-05-26 (first published: 2008-07-09)
820 reads
The function is used to find non-printable ASCII characters in an input string.
2009-05-21 (first published: 2009-04-24)
1,437 reads
2009-05-14 (first published: 2009-04-08)
1,960 reads
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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