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

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

948

what are the types of indexes? : Sql server database administration

1187

what kind of lan types do you know? : Sql server database administration

1023

what's the difference between delete table and truncate table commands? : Sql server database administration

1041

what are user defined datatypes? : Sql server database administration

1018

explain databases and sql server databases architecture? : Sql server database administration

1017

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

1051

do you know how to configure db2 side of the application? : Sql server database administration

1101

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1138

how to determine the service pack currently installed on sql server? : Sql server database administration

1026

what are the different types of replication you can set up in sql server? : Sql server database administration

1063

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1153

what are triggers? : Sql server database administration

954

what are cursors? : Sql server database administration

1107

what's sql server? : Sql server database administration

1054

Un-Answered Questions { SQL Server }

What is db stored procedure?

945

What are the different types of Indexes available in SQL Server?

1063

How many clustered indexes there can be on table ?

1075

What is left outer join in sql server joins?

1111

What happens if null values are involved in string operations?

1032

Will sql server 2005 allow you to reduce the size of a column?

1062

What are SSL and TSL protocols?

1037

What is difference between foreign key and unique key?

1052

Explain can you implement data mining in ssrs?

161

What is the sql server 2000 version number?

1152

Using the customer, and order table in northwind database, please write a query to produce xml?

1119

What is an etl file?

1015

Which is the latest version of sql server and when it is released?

1207

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1162

How to Sync Two SQL Azure Databases?

121

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