Find an implicit conversion in your SQL Server plan, understand which value changes type, and match application parameters to indexed columns.
SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER
A junior developer used the FORCE ORDER query hint without knowing what it does. Here is how it works and how much this one hint can change performance.
Color-Coding Production Connections in SSMS
Color-coding production connections in SSMS adds a visual warning, while an identity query confirms the real destination.
LIKE ESCAPE: Search for a Literal Percent Sign
LIKE ESCAPE expresses a literal punctuation search. Preserve the distinction between wildcard pattern instructions and stored text.
SQL SERVER – Backup master Database Interval – master Database Best Practices
How often should you back up master? It holds logins and server settings, so here are my master database best practices for backup timing.
Monitoring With What You Already Have
Build useful SQL Server alerts with Agent, operators, failed-job notifications, and a review routine that verifies the whole delivery path.
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
SQL Server 2008 lets you copy database with data: turn on Script Data in the Generate Scripts wizard to get INSERT statements for the rows in your tables.