Interview Questions and Answers Part 2 explains clustered vs non-clustered indexes and the index configurations a table can have. The updated set has moved.
SQL Server Interview Questions and Answers Part 1
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 Interview Questions and Answers Introduction
Interview Questions and Answers Introduction: why I started this six part series after many reader requests. The updated questions now live at a new location.
SQL SERVER – 64 bit Architecture and White Paper
A Microsoft white paper on the 64 bit architecture of SQL Server 2005: more addressable memory, better parallelism and the key differences from 32-bit.
SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
Error: 18452 Login failed for user ‘(null)’ means the server only allows Windows Authentication. Switch to Mixed Mode and enable the sa login to fix it.
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 – 2005 – Disable Triggers – Drop Triggers
Two ways to stop a trigger from firing in SQL Server 2005: drop it or disable it. I prefer DISABLE TRIGGER and show the syntax to disable triggers.