1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category
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

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