To count rows and indexes for every table, one query on the catalog views answers four questions at once: how many tables, which are heaps, how many nonclustered indexes each has, and how many rows each holds. The post tests it on a demo database and explains where the row count comes from.
SQL SERVER – Importance of User Without Login – T-SQL Demo Script
A T-SQL demo script for a user without login: create the user, impersonate it, check its access, revert and then grant permissions, one step at a time.
Find the Most Resource Intensive Queries in SQL Server
To find resource intensive queries, read sys.dm_exec_query_stats and rank the cached statements by reads, CPU or time. This post builds a small demo, ranks it two ways, and fixes the worst offender with one index. It also explains what the numbers can and cannot tell you.
Draw Pictures with T-SQL: The SSMS Spatial Results Tab
The SSMS Spatial results tab draws every geometry value a query returns. This post draws a house and a tree with STGeomFromText and STBuffer, explains labels and the 5,000 object limit, and checks store service areas for overlaps and gaps.
Order of Operations in SQL Server: How PEMDAS Works in T-SQL
The order of operations in SQL Server follows PEMDAS, so 6/2*(1+2) returns 9. This post walks through the precedence rules with tested queries. It also covers integer division, the negative number trap and AND before OR.
SQL SERVER – Validating Unique Column Name Across Whole Database
A Unique Column Name check lists existing matches across visible database metadata. I use it as an inspection, not an enforcement guarantee.
Effect of Collation on Result Sets in SQL Server
The effect of collation on result sets is easy to see once you run the same query against two collations. This post builds a small demo and shows how sorting, comparing and grouping change. It also explains collation conflicts, including the one temp tables cause.







