Need to spot In-Memory OLTP tables among thousands of tables? I show a simple T-SQL query and the SSMS options that list only those tables.
SQL SERVER – Puzzle – Why Decimal is Rounded Up?
Why decimal is rounded up in one script and not in the other when both divide 10000 by 17? Try this holiday puzzle before you read the comments.
SQL SERVER – Story of Temporary Objects
Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.
SQL SERVER – List the Name of the Months Between Date Ranges – Part 2
Part 2 on listing the names of the months between date ranges, with an improved script from readers Miladin Joksic and Peter Lalovsky that adds more details.
SQL SERVER – Reverse String Word By Word Part 2
In Reverse String Word By Word Part 2, Sanjay Monpara and Yuri Petrov improve my script. The new, more robust version uses a Split function.
Primary Data File Extensions: Does the .mdf Name Matter?
Can a primary data file end in something other than .mdf? I built a demo database with odd names, checked each file, then detached and attached it.
Reading a Workload Capture Without a Tool
Read a workload capture by grouping related queries, comparing total resource use, and separating one slow execution from repeated work.






