How Does QUOTED_IDENTIFIER Works in SQL Server? I explain it in very simple words, using SELECT “Order By” with the setting OFF and then ON.
SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login
A client’s Always On read-only routing failed with: an error was encountered during handshakes before login. Here are the checks I shared and how we fixed it.
Wide Update Plans: What Every Extra Index Costs a Write
Inspect wide update plans, compare index-maintenance work with narrow updates, and read per-index counters without misreading STATISTICS IO.
How to Track Data Platform Service Level and Performance Before and After Consolidation?
Planning data platform consolidation? Track service level and performance before and after consolidation, so you know how well the planning worked.
SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)
One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s)
Retired Features Still in Your Schema: Stretch, text and More
Before an upgrade, look for text and image columns, old rules and defaults, and Stretch metadata. These queries show what is there.
Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216
Do queries always respect the Cost Threshold for Parallelism? Not always, and a quick AdventureWorks test with the execution plan shows why.