Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain Capacity planning to create a database? and how to monitor it?
what are file groups?
Get Current System Date Time
What are sql server functions?
What is the difference between online clustering and Offline clustering?
What is the filtered index?
Explain the difference between primary keys and foreign keys?
What is the use of keyword with encryption.
How to generate create table script on an existing table in ms sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
What is the difference between an index and a unique index?