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 an identity column in insert statements?

1076

Where are sql server user names and passwords stored in sql server?

1155

What is the difference between substr and charindex in the sql server?

1187

What is the difference between getdate and sysdatetime?

1062

What is the use of for clause?

1166

What are scheduled tasks in sql server?

1141

What is bulkcopy in sql?

998

Which command is used for user defined error messages?

1105

What is the use of sign function?

1196

What is the difference between varchar and nvarchar types?

1 1674

What will be query used to get the list of triggers in a database?

1053

What are the two authentication modes in sql server?

1170

Can we check locks in database? If so, how can we do this lock check?

986

What is sub query and its properties?

1024

What is the use of @@spid?

1049

Un-Answered Questions { SQL Server }

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1059

List out different types of normalizations in sql server and explain each of them?

975

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1385

What is importing utility?

1038

What is named calculation? : sql server analysis services, ssas

1025

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

1026

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1004

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1050

What is data compression?

1066

What is fill factor and pad index?

1060

How connect excel to sql server?

1054

What does Master database contains?

1182

What is extended stored procedures?

1026

Explain what stored procedure sp_replcounters is used for? : sql server replication

1577

Explain the collation?

1149

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