This script features as we can through the CTE Top10FilesWithLargerDiskConsumption the top ten data files that are showing greater consumption of hard drive related data-reading activities.
2019-01-15 (first published: 2019-01-08)
624 reads
2018-07-12
1,115 reads
A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation
2018-02-19 (first published: 2015-09-22)
5,787 reads
2015-04-28
1,733 reads
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.
2015-12-18 (first published: 2014-05-27)
22,118 reads
2013-09-25
2,949 reads
2013-09-17 (first published: 2013-09-06)
1,421 reads
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
16,601 reads
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
2013-12-25 (first published: 2010-10-11)
7,150 reads
2010-03-03
4,181 reads
By damianwidera
I have delivered a preconf on the biggest conference in Asia. The preconf was...
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...
Ask SSC