See why FLOAT math produces approximate sums and comparisons in SQL Server, then use DECIMAL or tolerance checks for the right data.
Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276
Question: Where to Download SQL Server 2019 for FREE?
Answer: This is one of the most popular questions, I keep on receiving from blog readers.
Entity-Attribute-Value Tables: Why They Hurt Queries
Understand entity-attribute-value query costs, lost types, indexing limits, and alternatives using real columns, sparse columns, or JSON.
Stress Testing with oStress – SQL in Sixty Seconds #087
One of the things which we cover in my Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.
SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column
Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.
How to Get Details of All Files Associated with Database from MDF? – Interview Question of the Week #275
Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.
Writing Rerunnable Deployment Scripts for Database Changes
Write rerunnable deployment scripts with guarded schema changes, version records, and a dry run on a restored database copy.