My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.
SQL Server Interview Questions and Answers Part 6
Interview Questions and Answers Part 6 covers the six properties of relational tables and de-normalization, adding redundant data to help performance.
SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
TempDB is full and you see Event ID 17052 for the tempdb log? Here is what to check first and how to move TempDB from one drive to another.
SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks
My 20 SQL Commandments for SQL Server, rewritten from an Oracle article: know your data, test with realistic data, write identical statements, and more tips.
SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
Restore Database backups with a T-SQL script: read the logical file names with RESTORE FILELISTONLY, set single user mode, then run RESTORE WITH MOVE.
SQL SERVER – Shrinking Truncate Log File – Log Full
The old code I used to truncate log file space with DBCC SHRINKFILE and BACKUP LOG WITH TRUNCATE_ONLY. It breaks the log chain, so take a full backup after.