SQL Server

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

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

[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

[Video] Office Hours 2017/03/26 (With Transcriptions)

This week, Erik and Richie discuss truncating log files, reindexing, using sp_rename, query tuning, columnstore indexes, debugging parameter sniffing issues, query processing internals, and troubleshooting query performance issues. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast? Don’t miss…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}