The world needs more Performance Tuning consultants, but is tuning really the top skill for a SQL Server consultant? Brian Moran answers from a business view.
Page Verify CHECKSUM and Why It Matters
Page verify CHECKSUM detects altered database pages on read; inspect old settings, understand new writes, and review suspect pages.
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 – List the Name of the Months Between Date Ranges – Correction
Sanjay Monpara caught a small error in my script to list the name of the months between two dates: it skipped the first month. Here is his corrected script.
SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Seattle – November 5, 2014
I presented Database Worst Practices at SQLPASS 2014 in Seattle on November 5. Here is the title and abstract of the session in case you missed it.
SQL SERVER – Reverse String Word By Word Part 4
In Reverse String Word By Word Part 4, Paul G slices the string by a delimiter and rebuilds it in reverse order. Here is his full script.
SQL SERVER – Creating the SSIS Catalog – Notes from the Field #058
SQL Server 2012 added the SSIS Catalog to store, run and log packages in one place. In Notes from the Field #058, Tim Mitchell shows how to set it up.
SQL SERVER – Reverse String Word By Word Part 3
Reverse String Word By Word Part 3 shows Yuri Petrov’s way to reverse words in a sentence, using an auxiliary numbers table in two parts.










