Script SQL Server Logins for Disaster Recovery In preparation for disaster recovery, I need to make sure I can recover the logins onto another server. In this tip we look at how to setup an automated process to script all SQL Server logins.
SQL Server JOIN Hints You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.
Step one is to discover where the time is going using standard server traces, code that analyzes the trace, and the new SQL Server Extended Events. Once we know where the time is going we will look at strategies to improve performanc