The default float to text conversion keeps about six digits. Here is the one style that gives your float back exactly, and the traps around it.
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.
SQL Server Performance Mistakes: Three Checks to Run Today
SQL Server performance mistakes hide in the settings, the files and the code. This post checks four server settings, shows poor file growth and its fix, and measures two code mistakes, a function on an indexed column and a data type mismatch, in logical reads.
Spotting Definition Drift With HASHBYTES on Module Code
Did someone change a production procedure and forget to tell you? Hash the module text, compare it with a baseline, and let SQL Server point at the culprit.
SQL SERVER – Testing Database Performance with tSQLt and SQLQueryStress
Database testing is often skipped until there is a problem. Here is my approach to testing database performance with tSQLt and SQLQueryStress.
Columnstore Segment Elimination: Loading Data So Scans Skip Work
See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.
Horizontal and Vertical Scalability: Why They Work Better Together
Horizontal and vertical scalability are not an either-or choice. Here is how scale-up and scale-out can work better together in one application.