what is the query and condition to delete datas in sql server.2 3264
what is diffence between replicaion and logshipping?1 2981
what is physical sort data and logical sort data in index?2 5942
how can do you the system monitoring?1 5685
what is the Enterprise manager(2000) and management studio (2005)?2 3256
How the data stores in a page?1 3489
what are the problems in logshipping?3 19709
How to tune a stored procedure?6 13574
what is index seek and index scan?2 10284
What is the difference between IN and EXISTS operators in SQL Server?9 60838
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?2 4095
can you any body tell me the difference between candidate key and primary key4 5689
How is table type constraint applied to a table?
What is the difference between locking and multi-versioning?
Do you know what is a linked server in sql server?
What is the recovery model? List the types of recovery model available in sql server?
Which table keeps information about stored procedures?
How optimize sql query with multiple joins in sql server?
What are constraints in microsoft sql server?
What happens if date-only values are provided as date and time literals?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain linked server in sql?
Indexes are updated automatically is the full-text index also updated automatically?
Explain datetimeoffset data type in sal server 2008?
Explain syntax for dropping triggers?
Is sql server free?
Explain the different types of joins?