How can you check the level of fragmentation on a table?
Explain an automatic checkpoint
If no size is defined while creating the database, what size will the database have?
How you would rewrite the sql query to return the customerid sorted numerically?
What you can do to delete a table without the delete trigger firing?
What is the difference between insensitive and scroll cursor?
Why transaction is important?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What are the approximate numeric data types?
What is a partitioned view?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is a derived table?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Will the writetext statement activate a trigger?
Other than truncate statement, which other command can by-pass the trigger on the tables?