Viewing 15 posts - 946 through 960 (of 7,472 total)
September 7, 2017 at 1:16 am
ChrisM@Work - Wednesday, September 6, 2017 9:05 AM
The results:
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time =...
September 7, 2017 at 1:14 am
Can you also post the DDL...
September 6, 2017 at 7:22 am
sit and wait. I guess it has to rewrite the whole table and its indexes. i.e. +190GB
(I/O bound operation)
It all depends on the original datatype and length...
September 6, 2017 at 2:26 am
This will work when performing piecemeal restores (after primary FG has been restored):
Select ...
from sys.data_spaces DS
inner join sys.database_files F
on F.data_space_id...
September 4, 2017 at 2:25 am
Already great work by Mark 🙂
I only came to this starting point:
Select PlanXML.xmlnode.value('@FieldName', 'varchar(255)') AS FieldName
, PlanXML.xmlnode.value('@FieldValue', 'varchar(255)') AS...
May 26, 2017 at 5:27 am
May 22, 2017 at 1:37 am
there seem to be a couple more parallel operations in the 58 plan vs the 3:45plan
Do you also monitor blocking operations in your system ?
Do these...
May 5, 2017 at 7:05 am
replace " with no_wait" to "with rollback immediate" !
May 5, 2017 at 4:03 am
There can be dosens of reasons why a plan will get invalidated.
e.g. changes to indexes (rebuilds), create/drop index, statistics update, ...
Compare the old and the new plan...
May 5, 2017 at 3:56 am
Viewing 15 posts - 946 through 960 (of 7,472 total)