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?

1082

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

1103

What is the order by used for?

1063

What is a transactions?

1090

What is row_number()?

1054

What stored by the master?

1015

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

1110

What is bcp? When does it used?

1044

Which are new data types introduced in sql server 2008?

1108

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?

1038

What is the purpose of the master database?

1206

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

1096

Does sql server 2000 full-text search support clustering?

915

What is filtered index?

1145

Un-Answered Questions { SQL Server }

Does partitioning improve performance sql server?

1038

What is primary key and example?

999

How to count duplicated values in a column in ms sql server?

1176

How to delete database objects with "drop" statements in ms sql server?

1155

How many types of triggers are there?

1126

What are a database and a data warehouse?

1078

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

2027

How to divide query output into multiple groups with the group by clause in ms sql server?

1094

what is an index? : Sql server database administration

1029

What is 2nf in normalization?

1058

What is the difference between value type and reference type?

992

What is the difference between ‘having’ clause and a ‘where’ clause?

1093

What are user-defined functions (udfs) in sql server?

1051

How to use linked server?

1274

What is filestream?

1052

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