IN Vs OR operator which is best to use sql server.4 8196
why cluster and non clusterindex are used in sqlserver 2000? explain with example1 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 20003 3770
how to select a field with firstletter as capital and remaining are small letters11 11568
How to write stored procedure to update the data in 10 tables4 10616
How to write query to Delete the records in child table and corresponding records in parent table11 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 curser.9 6435
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?