One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.
2010-12-10 (first published: 2009-01-28)
32,989 reads
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
2009-01-27
12,101 reads
2009-01-26
4,827 reads
2009-01-22
4,639 reads
I had a request from a client who prints a lot of cheques each month and there control over the cheques went a bit haywire. The requested me to create some controls in their system to make sure that the cheques are use in cheque number sequence.
2009-01-20
1,125 reads
Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.
2013-07-26 (first published: 2009-01-16)
2,287 reads
Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.
2009-01-13
3,724 reads
SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.
2009-01-08
2,732 reads
Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.
2008-12-31
1,332 reads
2008-12-29
4,033 reads
By Steve Jones
I have often made an effort to attend conferences in the past to grow...
Another discussion in Gothenburg (such a great group of people) around Extended Events lead...
Let's be honest – SQL can be a bit of a beast. At first...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers