An improved script to print all stored procedures of database, now with schema names. Jerry Hung’s cursor uses sys.all_objects and sp_HelpText.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3
The last day at South Asia MVP Open Day in Goa: Open Space sessions at midnight, Nitin Paranjape on being an entrepreneur, and a quiet walk on the beach.
Baselines: Knowing What Normal Looks Like
Build a SQL Server baseline with timestamped workload, wait, and IO samples so you can compare a slowdown with a similar period of normal work.
SQL SERVER – Delete Backup History – Cleanup Backup History
SQL Server keeps backup history in msdb forever. Use sp_delete_backuphistory to delete backup history older than 30 days, or any number you pick.
Why WHERE Runs Before SELECT
Learn logical query processing to understand WHERE, SELECT aliases, grouped filters, and ordering without confusing syntax with execution.
SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server
SQLAuthority.com crossed 5 million visitors and turned 2 years old. I also share my note on the economy slow down and job opportunity for SQL Server folks.
SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio
Is the SSMS connect drop down list full of old server names? Delete the mru.dat file for SQL Server 2005 or 2008 to clear it and start fresh.