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)
A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation
2018-02-19 (first published: 2015-09-22)
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)
Sales Report based on a single view
2013-09-17 (first published: 2013-09-06)
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
2013-12-25 (first published: 2010-10-11)