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?

1041

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

1011

What is the difference between insensitive and scroll cursor?

1237

Why transaction is important?

1017

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

1038

What are the approximate numeric data types?

984

What is a partitioned view?

1050

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

1082

What is a derived table?

988

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

1250

Will the writetext statement activate a trigger?

1152

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

1182

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

1041

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

1322

How do you rebuild an identity column?

994

Un-Answered Questions { SQL Server }

Explain throw statement in sql server 2008?

1052

Which table keeps the locking information?

984

what is the difference between count(*) and count(1) ?

1123

What are the different types of stored procedures?

1155

What is a transact-sql statement?

1126

What is an expression in ms sql server?

1139

How you can change the database name in SQL SERVER?

1246

What are the different index configurations a table can have?

1008

What are drillthrough reports?

161

What is built-in function?

1054

What are the features of Embedded SQL

1170

Explain about Joins?

1034

What is model database? : SQL Server Architecture

1186

What is bit data type?

1081

What are different types of table joins?

1050

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