SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 6450

What is a join and their types?

Challenger Financial,

2 4882

What is the difference between referencing and joining?

1 2133

What is the difference between constraints and triggers?


9 24226

What is ACID Property of Transaction?

10 29469

What is an index?

Yardi Software,

8 9459

What is normalization and its forms?

Challenger Financial,

4 10086

What is a cursor in SQL Server 2000 and their types?

8 13469

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 45295

How do we return a record set from a Stored Procedure in SQl server 2000?

3 3497

What are the magic tables in SQL Server 2000?

Merrill Lynch, Infogain,

7 19680

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 42526

What are the differences between stored procedure and functions in SQL Server 2000?

Infosys, HCL, TCS, College School Exams Tests,

25 95630

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 3588

Which is best Subquery (or) joins in sql server? explain why

2 8805

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

1 01 101 01010


plss anybody specify tha constrian management system in dbms


on line cluster can we make if yes tell me the procedure


System variable and temporary variables


What is Lock table in SQL?


How do use Having,Group by,Group function in SQL?


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?


What is the query optimization statistics?


How do you Implement SSIS Packages in your Project?


which backup strategy you are following at ur company


SQL Server Architecture ?


optimization techinques


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?