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?

TCS,

3 12763

whate is advantages of sql server 2000

889




what is the purpose of creating view is sql server 2000

Wipro,

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?.

ABC,

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.

L&T, IBM,

1137

what is curser.

9 6435

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

TCS,

5 9690


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

663


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?

1006


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

812


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

781


ow to bring suspect mode datbase online from scratch

644






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

2579


What is the query optimization statistics?

1177


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

835


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

834


Tell about MOM Tool(Microsoft Operator Manager)?

634


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

1192


Comment,Datatypes are unlimited

871


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

131


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.

1305


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?

573