|
|
-
|
|
RESTORE-Auxiliary statements-What does this backup contain? How much space will this restore need? And many more answers......
|
|
-
|
|
The script helps to identify the top 10 queries that use the most I/O as ordered by Total IO, taking more time to execute (means most expensive) across all databases on the server....
|
|
-
|
|
When we fire any query in SSMS, it returns data, we generally check status bar/message tab to get the information of the records affected or retrieved.
Do you know SQL Profiler provides facility to capture the record count (ROWCOUNT)?
Though it is small feature and often unnoticed, I would like t......
|
|