Being a production or operational DBAs, whomever I know may rely on third party monitoring tools, which is not questionable. There are many good SQL server-monitoring tools help us to keep an eye on our database production infrastructure. What I suggest/prefer is to have native alerts as first line of notification or this option could … Continue reading 5 Native SQL Server Performance Alerts
“Switch” Huge Non Partitioned Tables in Seconds
ALTER TABLE [onetable] SWITCH TO [anothertable] There are many challenges with gigantic tables and modifying their schema is one of those that could make many operational DBAs cry. I had to go through a schema change where I have to make data type and identity changes to one of the largest transactional table in the … Continue reading “Switch” Huge Non Partitioned Tables in Seconds
Perform Professional, Comprehensive SQL HealthChecks
A gigantic script that gives you a lot information to view and review current databases and SQL Server settings, options and configurations. I see it becoming very favorite of many operational DBA folks. I’d recommend it run it at least once in a month or anytime you want to have very detailed information for any … Continue reading Perform Professional, Comprehensive SQL HealthChecks
adrshen 