What does the is_not_trusted column in sys.foreign_keys mean? Books Online is not very clear, so I explain it with a simple example using three tables.
SQL SERVER – Filter In-Memory OLTP Tables in SSMS
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.