Tag Archives: 2012

Top 40 SQL Server Performance Tuning Interview Questions

Top 40 SQL Server Performance Tuning Interview Questions SQL THE ONE There are total 254 questions are answered under SQL Server Performance Tuning category in the book “SQL THE ONE”. In this chapter we can see questions and answers on … Continue reading

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | 7 Comments

SQL Server Health Check

SQL Server Health Check Hello there, if you are a SQL DBA the most common task that you perform is “SQL Server Health Check”. You may already have an automated report but this is for doing a quick SQL Server … Continue reading

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , | 26 Comments

Update Without Where Clause

Update Without Where Clause Running Update Without Where Clause might causes a data damage when it is with the critical table that creates a lot of problems and escalations. Recently while working with one of the customer we had a … Continue reading

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , | Leave a comment