Update the Statistics on Recently Modified Tables OnlyCommented on: 4 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: 5 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...
Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More