how you can get the list of largest tables in a database? : Sql server administration
What is an index in sql?
can you any body tell me the difference between candidate key and primary key
Explain the phases a transaction has to undergo?
How to find out name of all employees who has salary less than 200 Rs.?
can primery key be a non clustered index?
how many type of indexing in database?
how would you improve etl (extract, transform, load) throughput?
Give an example of why you would want to denormalize a database
What is the sql case statement used for? Explain with an example?
What is compression - row-level and page-level compression?
syntax for deleting the database in T SQL
What are the different types of stored procedures?