CTE and joins begin Day 16 of the original interview series. The ten questions remain with corrected examples and clearer answers about XML, CLR, synonyms, and locking.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 15 of 31
Frequently Asked Questions Day 15: what Service Broker is, and where SQL Server stores usernames and passwords, with clear interview answers.
Interview Questions and Answers – FAQ Day 14 of 31
FAQ Day 14 of my interview series starts with the basic functions of the master, msdb, model, tempdb and resource databases in SQL Server 2008.
SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes
Duplicate indexes are pure overhead on every insert, update and delete. Here is my script to find duplicate and overlapping indexes so you can review them.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 13 of 31
Frequently Asked Questions Day 13 explains aggregate functions, what @@SPID returns and the difference between an index seek and an index scan.
SQL SERVER – Database Worst Practices
Let us talk about SQL SERVER – Database Worst Practices. Instead of writing best practices, I am going to write about few of the bad ones.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 12 of 31
Frequently Asked Questions Day 12: separate drives for performance, free disk space with xp_fixeddrives and why a table has only one clustered index.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.