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?

984

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

965

What is the difference between insensitive and scroll cursor?

1153

Why transaction is important?

971

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

989

What are the approximate numeric data types?

923

What is a partitioned view?

982

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

1024

What is a derived table?

923

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

1180

Will the writetext statement activate a trigger?

1086

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

1129

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

975

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

1249

How do you rebuild an identity column?

944

Un-Answered Questions { SQL Server }

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1022

Define Joins?

1023

How to enter comments in transact-sql statements?

937

How we create SQL Server 2005 Reporting Services ? Give me Sample

1983

What is the sql server agent?

1083

How to backup SQL Server Reporting Services ?

148

Can I work with several databases simultaneously? : sql server management studio

982

What is linked report?

131

Do you know what guidelines should be followed to help minimize deadlocks?

968

Explain error and transaction handling in sql server?

1006

Give an example of SQL injection attack ?

1002

When would you use sql joins?

952

How do I view views in sql server?

1002

Explain magic tables in sql server?

1052

How to convert character strings into numeric values?

1092

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