What are functions3 6745
how to get the automatic backup of the database in the sql server4 31939
Which command using Query Analyzer will give you the version of SQL server and operating system?3 12389
What is the STUFF function and how does it differ from the REPLACE function?2 17366
What is the purpose of UPDATE STATISTICS?2 10291
What is de-normalization and when do you do it?3 5630
Explain some DBCC commands?6 14496
What is the purpose of using COLLATE in a query?1 16548
What is the difference between varchar and varchar(max) datatypes?
What are the dmvs?
What is SQL Azure Fabric?
What is a covered index?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is the difference between insensitive and scroll cursor?
How to stop log file growing too big?
How to invoke a trigger on demand?
What are basics of policy management?
Explain raiserror in sql server?
How to find out the list schema name and table name for the database?
What is shared lock?
What is lookup override?
Can binary strings be used in arithmetical operations?
How can you know if the row fetched from cursor is still valid in underlying table?