SQL Server Interview Questions and Answers Complete List Download(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

Question I received is do I ask the same questions in interviews which I administrate. Answer is YES. Though, I have few other questions, which I ask. All of them I came up myself and answers are unique to questions and not available on-line. Well, long story short, I have compiled list of questions in one PDF. Please download them and use them in your next interview or just for reading purpose. read more...

add a comment |category: Database |Views: 513

tags: SQL SQLAuthority pinaldave Interview SQLServer another

SQL SERVER - Insert Multiple Records Using One Insert Statement(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

How can I insert multiple values in table using only one insert? Now this is interesting question. When there are multiple records are to be inserted in the table following is the common way using T-SQL. read more...

add a comment |category: Database |Views: 302

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER - Count Duplicate Records - Rows(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

In this article we will see how to find count of all the duplicate records in the table. Following query demonstrates usage of GROUP BY, HAVING, ORDER BY in one query and returns the results with duplicate column and its count in descending order. read more...

add a comment |category: Database |Views: 236

tags: SQLServer SQLAuthority Database SQL another

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 10 months ago

Following tutorial about BPA is ran on one of my old laptop, which has SQL Server 2005 installed. The SQL Server had many issues and they all are displayed in the result. Please note this is not production server and all the errors are intentionally generated. This tutorial is explained using images, which are very easy to understand. read more...

add a comment |category: Database |Views: 9

tags: SQL SQLAuthority pinaldave Database SQLServer another