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

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1064

what is the system function to get the current user's user id? : Sql server database administration

1022

what's the maximum size of a row? : Sql server database administration

1084

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

1021

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

980

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

950

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

936

what is database replicaion? : Sql server database administration

1196

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

901

what purpose does the model database serve? : Sql server database administration

977

what are constraints? Explain different types of constraints? : Sql server database administration

984

what is a schema in sql server 2005? : Sql server database administration

1031

what are different types of raid configurations? : Sql server database administration

1056

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1018

how many clustered indexes can be created on a table? : Sql server database administration

1152

Un-Answered Questions { SQL Server }

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1064

What is sql server locking?

992

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1001

Explain the truncate command?

984

What do you mean by the term 'normalization'?

1209

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2785

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

980

plss anybody specify tha constrian management system in dbms

2151

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

957

How can you know if the row fetched from cursor is still valid in underlying table?

998

When I delete any data from a table, does the sql server reduce the size of that table?

1018

when you create a database how is it stored? : Sql server database administration

1023

What is isolation levels?

1029

What is the difference RDBMS and Graph Database?

1047

How to find the service pack installed? : sql server database administration

1023

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