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.
This week, Erik, Richie, Doug, and Angie discuss a script for getting more information on a specific index, using partition tables, shrinking data and log files, stress testing SQL servers, as well as some entertaining things to ask Siri!