Answer Posted / vj tan
SQL Server Profiler shows how SQL Server resolves queries
internally. This allows administrators to see exactly what
Transact-SQL statements or Multi-Dimensional Expressions
are submitted to the server and how the server accesses the
database or cube to return result sets.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you find out how many rows returned in a cursor?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What is partition in sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
When a primary key constraint is included in a table, what other constraints does this imply?
Can you explain different types of locks in sql server?
What is indexed view? How to create it?
Can we insert data into a view?
What are the disadvantages of indexes?
Are connections to sql server encrypted?
on line cluster can we make if yes tell me the procedure
Explain what are the basic functions for master, msdb, model, tempdb databases?
Explain what you mean by 3 tier architecture.
What are the key configuration files for sql server reporting services ?
Where are sql server usernames and passwords stored in the sql server?
