Files with larger disk consumption
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.
CTE
Implementing John Conway’s Game of Life in Microsoft SQL Server
A fun exercise, using CTEs to implement John Conway’s Game of Life cellular automata simulation
Cursor-Killing: Accessing Data in the Next Row
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.
Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
How to Compare Rows within Partitioned Sets to Find Overlapping Dates
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
Blogs
Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
Lengthen a Primary Key–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Setup SQL Server Alert to get automatically notified of database blockings
By SQLPals
Suppose you want to or need to know anytime your SQL Server is experiencing...
Forums
Protecting Data Between Services
Comments posted to this topic are about the item Protecting Data Between Services
SQL browser and port number
We have several new servers running SQL 2014. Some servers are single instance servers...
ssms crashes when editing .sql script
I’ve recently been having an issue with ssms freezing and crashing while editing a...
Ask SSC