Update the Statistics on Recently Modified Tables OnlyCommented on: 3 years ago
(April 1, 2010)
Why are you using sp_ as a naming convention for stored proc's when it is best practice not to. And Grant Fitchly( aka Scary DBA ) in his book 'SQL 2008 Performance tuning distilled' shows the...
Seven Tips for SQL Server Production DBAsCommented on: 4 years ago
(July 15, 2009)
Just a question as to what you would do if your policy is to remove the builtin admin account after a SQL install is done then this will not work. Also I have always thought that buildin admin...
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More