Explain what is log shipping?
What stored by the msdb?
Explain what are page splits? : SQL Server Architecture
How to transfer a table from one schema to another?
How to skip remaining statements in a loop block using continue statements?
Does union all remove duplicates?
Plz tell about backup&recovery?
What is service broker? : sql server database administration
how you can list all the tables in a database?
How do you check the performance of a query and how do you optimize it?
What are transactions in sql?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What are user defined datatypes and when you should go for them?