<p>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.</p>

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.

Office Hours - 4/12/2017

SQL Server Pain Relief: Office Hours is like listening in while patients bring their SQL Server pains to the emergency room, and the doctors give their opinions. Join your host, performance tuning specialist Brent Ozar, and his highly-qualified SQL Server Medical Team as they give you an inside look into some of the best solutions to your server problems. Tune in to get the best tips for performance tuning, virtualization, disaster recovery and much more. When you’re ready to do your own surgery, grab our free First Responder Kit at www.BrentOzar.com.

Share Office Hours - 4/12/2017

Sign up to save your podcasts

Office Hours - 4/12/2017

Office Hours - 4/12/2017