SQL Server Pain Relief: Office Hours

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.

This week, Brent, Richie, and Erik discuss updating stats and rebuilding indexes, feature request for Paste the Plan, included columns' effect on DML, CLR store procedures, SQL command and SQL command query mode, ALTER TABLE statements, using a GUID as a primary key instead of an IDENTITY column, keeping SQL server settings across multiple servers in sync, and more.

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.

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.

This week, Tara, Erik, and Richie discuss statistics updates, in-place upgrades, row vs page compression, deadlocks, replacing SQL backup vendors, server load, ETL, and whether they think that database mail should be used by user applications to send their emails.

This week, Brent, Richie, and Erik discuss the requirements for getting a Senior DBA or Database Architect job, data migration, encryption, fragmentation, differences between SQL server 2016 and 2014, update stat strategies for large tables vs small ones, and more!

This week, Erik and Richie discuss creating/updating statistics, tools for viewing large flat file tables, the worst code they have ever seen, high disc queue length, dealing with databases that store blobs, reindexing jobs, transparent data encryption, and more.

This week, Brent and Tara discuss AlwaysOn failure scenarios, partitioning without consulting vendors, multi-subnet clustering with AGs, licensing, long running queries, replication, improving index maintenance, avoiding deadlocks, index space usage, and much more.

This week, Erik, Tara, and Richie discuss clustered and unclustered indexes, query timeouts, fill factor, mirroring vs. log shipping, IO tests, temp tables and common table expressions, and tempdb spills.

This week, Erik, Tara, and Richie discuss tempdb etiquette for developers, elastic search vs full-text search, server CPU spiking issues, source control in a database project, querying transaction logs, and more.