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

946

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

1178

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

1021

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

1039

what are user defined datatypes? : Sql server database administration

1015

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

1013

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

1049

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

1098

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

1135

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

1151

what are triggers? : Sql server database administration

952

what are cursors? : Sql server database administration

1100

what's sql server? : Sql server database administration

1051

Un-Answered Questions { SQL Server }

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1897

Can We Use Data-grids For Our Report In Ssrs?

188

Explain multiserver query

1113

What are the reporting services components?

144

How to find out the list schema name and table name for the database?

979

Explain a checkpoint?

1086

Explain trigger classes i.e. Instead of and after trigger?

918

What is the difference between for xml raw and for xml auto?

1080

What is a cube? : sql server analysis services, ssas

1052

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1114

How to round a numeric value to a specific precision?

1126

Why people hate cursor?

1202

How can you list all the columns in a database?

970

Write a query for primary key constraint with identity key word?

1080

What is replace and stuff function in sql server?

1113

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