What are the steps to process a single select statement?
What is the difference between SSAS 2000 and SSAS 2005?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
write sql program to get the detail of student in a class?
How to insert data into an existing table?
Explain what are the different index configurations a table can have?
How will you know when statistics on a table are obsolete?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
can you any body tell me the difference between candidate key and primary key
Explain triggers?
How do I run a trace in sql server?
Why we should not use triggers?
How to create a dml trigger using create trigger statements?