July « 2011 « SQL Server Journey with SQL Authority

Archive for July, 2011

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 17 of 31

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 17, 2011 | 1 Comment »

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs How will you Handle Error in SQL SERVER 2008? SQL Server now supports the use of TRY…CATCH constructs for [...]

Read Full Post »

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 16, 2011 | 5 Comments »

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What are the Advantages of Using CTE? Using CTE improves the readability and enables easy maintenance of complex queries. [...]

Read Full Post »

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 15 of 31

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 15, 2011 | 1 Comment »

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What is Service Broker? Service Broker is a message-queuing technology in SQL Server that allows developers to integrate SQL [...]

Read Full Post »

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 14 of 31

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 14, 2011 | 4 Comments »

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs 3) Questions on SQL SERVER 2008 What are the basic functions for master, msdb, model, tempdb and resource databases? [...]

Read Full Post »

SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Index, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 13, 2011 | 8 Comments »

Download Duplicate Index Script with Unused Index Script and Missing Index Script I was recently delivering session on Performance Tuning subject. I was asking if there is any harm having duplicate indexes. Of course, duplicate indexes are nothing but overhead on the database system. Database system has to maintain two sets of indexes when it [...]

Read Full Post »

« Newer Posts - Older Posts »