SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

How you would rewrite the sql query to return the customerid sorted numerically?

1003

What you can do to delete a table without the delete trigger firing?

974

What is the difference between insensitive and scroll cursor?

1168

Why transaction is important?

980

in the physical file layout, where should the transaction log be stored in relation to the data file?

996

What are the approximate numeric data types?

946

What is a partitioned view?

1003

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1037

What is a derived table?

935

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1198

Will the writetext statement activate a trigger?

1100

Other than truncate statement, which other command can by-pass the trigger on the tables?

1139

Is it important for a database administrator to understand the operating system and file access?

1005

What is the fastest way to permanently delete a 1 million row table named customers?

1255

How do you rebuild an identity column?

951

Un-Answered Questions { SQL Server }

What do you understand by replication in sql server?

1067

What are orphan records?

936

Can I save my report as html, excel or word? : sql server management studio

958

What is difference between table aliases and column aliases? Do they affect performance?

971

Do you know what is bit data type and whats the information that can be stored inside a bit column?

961

What is difference between primary key and foreign key?

909

Can you force a query to use a specific index?

950

What is sql server used for?

1058

How to backup SQL Server Reporting Services ?

150

What do you understand by check constraint in sql server?

950

What is data mart? : sql server analysis services, ssas

1060

What is the default value of an integer data type in sql server 2005?

957

What is Sqlpaging in SqlServer 2005 ?

1072

Is truncate autocommit?

943

What is the difference between drop table and truncate table?

932

For More Un-Answered { SQL Server } Questions Click Here