What is the difference between seek predicate and predicate?
How to defragment indexes with alter index ... Reorganize?
How many types of stored procedures are there in sql server?
Explain different forms of normalization?
If a table does not have a unique index, can a cursor be opened on it?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
Explain transaction server implicit?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Do you know sql server 2008 introduces automatic auditing?
What are the features of Embedded SQL
what is raid? : Sql server database administration
Tell me about pre-defined functions of sql?