Interview Questions and Answers Part 1 starts with the basics: what an RDBMS is and what normalization means. The updated set now lives at a new location.
SQL SERVER – Stored Procedures Advantages and Best Advantage
My take on stored procedures advantages, and the best one of all: execution plan retention and reuse, since the rest can be had without them.
SQL SERVER – Script to Find SQL Server on Network
I manage lots of SQL Servers and forget their names, so I use xp_CMDShell and ISQL -L to find SQL Server on network machines. A short video is included.
SQL SERVER – SP Performance Improvement without changing T-SQL
Two easy ways to improve SP performance without changing T-SQL: do not prefix stored procedures with sp_, and call them by the fully qualified dbo name.
SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005
I compared a SQL Server 2005 paging query using ROW_NUMBER() with the SQL 2000 way of paging through temp or derived tables, both run on AdventureWorks.
SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
When TempDB is Full, I investigate capacity and usage before moving its files. A move requires a planned restart.
SQL SERVER – Fix : Error 701 There is insufficient system memory to run this query
For Error 701, insufficient system memory, compare max server memory with min server memory, check the paging file size, and free caches with DBCC commands.