How can you see what type of locks used?
Determine when to use stored procedure to complete sql server tasks?
How we can refresh the view?
How to execute a stored procedure in ms sql server?
How would you choose between a clustered and a non-clustered index?
where do you use Isolations?give me some exmpale?
What is shared lock?
why would you call update statistics? : Sql server database administration
How will u test the stroded procedures and functions? difference between SP and Triggers
Is it possible to delete duplicate rows in a table without using a temporary table ?
can you any body tell me suppose database is suspect mode. how can take to normal?
How do I find sql server instance name?
Which autogrowth database setting is good?