SQL Server Interview Questions
Questions Answers Views Company eMail

IN Vs OR operator which is best to use sql server.

4 8125

Can anybody explain me cold backup and hot backup?


3 12675

whate is advantages of sql server 2000


what is the purpose of creating view is sql server 2000


13 12034

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 3082

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 3718

how to connect sybase to sql server 2005?.


1 2811

how to select a field with firstletter as capital and remaining are small letters

11 11430

How to write stored procedure to update the data in 10 tables

4 10555

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 26461

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 4092

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 5064

what is difference between view and Dip.



what is curser.

9 6315

what is Data Transformation Services (DTS) ?can u explain me in detail?


5 9578

Post New SQL Server Questions

Un-Answered Questions { SQL Server }



How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.


how to do partition in sqlserver


Tell about MOM Tool(Microsoft Operator Manager)?


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


How do you Implement SSIS Packages in your Project?


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


If a stored procedure is taking a table data type, how it looks?


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?


sql database suspect We have a sql database that is showing as suspect. How can we recover?


SQL Server Architecture ?


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


What is the query optimization statistics?


where the connection string store in the database