How many pending IO requests are there for each MDF and LDF file? My handy script joins sys.dm_io_pending_io_requests with virtual file stats.
LocalDB: SQL Server on a Developer’s Laptop
LocalDB runs SQL Server Express engine features in a developer-friendly local process; learn how to start, connect, and recognize its limits.
SQL SERVER – Finding Latch Statistics
Which latches are waiting and for how long? The DMV sys.dm_os_latch_stats lets you find latch statistics with one simple query ordered by wait time.
geometry STNumPoints: Closing Coordinates Count Again
geometry STNumPoints counts coordinates in the spatial description. A square ring contains its closing coordinate as well as its four distinct corners.
SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)
What is the difference between COUNT(DISTINCT) and COUNT(ALL)? A student asked me at a college session, and one quick script made the answer clear.
geometry STGeometryType: Type Names Say More Than Dimension
geometry STGeometryType identifies the represented shape type, which carries more information than its dimension. I compare single and multiple shapes in one small query. Equal dimensions do not mean that their structures are interchangeable.
SQL SERVER – Running Multiple Batch Files Together in Parallel
I needed SQL code running in parallel for a demo, so I used sqlcmd and start cmd.exe to run multiple batch files together. Can PowerShell do it better?