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 awe?

1078

When columns are added to existing tables, what do they initially contain?

1096

What is the order by used for?

1055

What is a transactions?

1086

What is row_number()?

1050

What stored by the master?

1010

What is 'write-ahead log' in sql server 2000 ?

1106

What is bcp? When does it used?

1043

Which are new data types introduced in sql server 2008?

1105

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1211

What are the basic functions for master, msdb, model, tempdb and resource databases?

1034

What is the purpose of the master database?

1198

Does server sql treat char as a variable-length or fixed-length column?

1090

Does sql server 2000 full-text search support clustering?

914

What is filtered index?

1142

Un-Answered Questions { SQL Server }

What is an sql server agent?

1112

How to disable triggers using "disable trigger"?

1105

What is acid properties?

1190

What is scalar user-defined function?

1189

What is the difference between value type and reference type?

988

How to transfer data from a cursor to variables with a "fetch" statement?

1143

What are types of storage modes? : sql server analysis services, ssas

1082

What is a trigger and its types?

1039

How to how to convert numeric expression data types using the convert() function??

1094

What is nested transaction?

1137

What is sql server used for?

1099

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

What is dimension table? : sql server analysis services, ssas

1065

Is foreign key unique?

1047

What is the current pricing model of SQL Azure?

104

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