Answer Posted / pradeep
DBCC commands gives you valuable insight into whats going on inside your sql server system......
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is mean by dml?
What are the restrictions that views have to follow?
What is SQL Server?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Explain sql server service broker?
What is application role in sql server database security? : sql server security
Detail about query optimizer?
Define cross join in sql server joins?
What different steps will a sql server developer take to secure sql server?
What is difference between aggregate and analytic function?
How do I find the default sql server instance?
List the different types of joins?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is store procedure? How do they work? When do you use?
What is the difference between functions and stored procedures?
