SQL Server

  1. Home
  2. SQL Server
  3. (Page 10)

SQL Server 2017: Statistics Information Comes To Query Plans

Warm fuzzies I think this is how my mom would have felt if I went to college. You see, once you stop cargo culting around index fragmentation, and disk queue length, you start to realize which things are actually important to query performance. Things like statistics, and cardinality estimation. And, sure, having the right indexes…
Read More

The 2017 Adaptive Join Optimization Eats Bad TSQL For Breakfast

Cheeky If you thought that title sounded familiar, you sure were right. That’s called a classical reference. So here we are, three whole years later, and yet another improvement to the engine promises to fix performance issues forever and ever. While this isn’t exactly an entirely new cardinality estimator, it’s an entirely new branch in…
Read More

Hold The FiIter: Startup Expression Predicates

Long distance information There was a rather interesting question posted on dba.stackexchange.com recently about CASE expression order of execution with an OR predicate. Mouthful, I know! When I saw it, I got all “I HAVE A REALLY GOOD ANSWER” and started to write demo queries. Then I wrote this blog post instead. Sorry, j.r. —…
Read More

[Video] Office Hours 2017/04/19 (With Transcriptions)

This week, Brent, Tara, Richie, and Erik discuss SQL Server 2017 CTP 2, quorum configuration for a 4-node availability group, database sharding, premature optimization, parameter sniffing, tracking query plans within cursors, and what’s coming up in the new version of Paste The Plan. Here’s the video on YouTube: You can register to attend next week’s Office Hours,…
Read More
Brent Ozar reading

SQL Server 2017 Release Date: May 31?

At the SQLbits conference in the UK, Victoria Holt sat in on a session about the State of the SQL Nation. She writes: “SQL Server vNext will be launched this year with the UK launch 31 May 2017.” Keep in mind that “launch” is a marketing term, very different from “release.” (Even “release” is tricky…
Read More
Pocket Square

[Video] Office Hours 2017/4/5 (With Transcriptions)

This week, Erik, Tara, and Richie discuss altered tables and update statements, parameter sniffing issues, their issues with Azure, a resource for column store indexes, AlwaysON availability groups, killing sleeping connections, and fill factor value for indexes. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to…
Read More