SQL Server Interview Questions
Questions Answers Views Company eMail

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

4 8196

Can anybody explain me cold backup and hot backup?


3 12763

whate is advantages of sql server 2000


what is the purpose of creating view is sql server 2000


13 12251

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

1 3122

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 3770

how to connect sybase to sql server 2005?.


1 2853

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

11 11568

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

4 10616

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

Semantic Space,

11 26596

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 4155

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 5115

what is difference between view and Dip.



what is curser.

9 6435

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


5 9690

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

If the job running very slow what is the action you do


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?


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


how can you attach more than 20 ldf files in sql server


ow to bring suspect mode datbase online from scratch


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


What is the query optimization statistics?


what is package and it uses and how can u call a package


role of sql sever 2005 in database rather than any other database


Tell about MOM Tool(Microsoft Operator Manager)?


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?


Comment,Datatypes are unlimited


If we delete pack Spec what will be the status of pack Body ?


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?