Viewing 15 posts - 6,601 through 6,615 (of 49,571 total)
GPO (2/8/2015)
I think there's some pretty funky data validation code built into the front end to keep everything lined up.
And does it work? Or do you have data that makes...
February 9, 2015 at 1:43 am
The SET options are different between the two plans, hence two different plans in cache as they're technically different queries.
One has
ANSI_NULLS: True, ANSI_PADDING: True, ANSI_WARNINGS: True, ARITHABORT: True, CONCAT_NULL_YIELDS_NULL:...
February 9, 2015 at 1:31 am
SQLKnowItAll (2/5/2015)
February 9, 2015 at 1:23 am
The you would have something like a status history table which records the changes, rather than duplicating the entire row for one column change.
As it currently is, you've got a...
February 6, 2015 at 3:29 am
Firstly, why do you want to duplicate data in the table? Why create a new row when a column changes? Why not just change the column value?
Second, ditch the nolock...
February 6, 2015 at 2:52 am
No, you do not.
Altering a table changes the schema version of the table. As part of the pre-execution validation of a cached plan, the schema versions are checked to ensure...
February 6, 2015 at 2:27 am
Yes, it's probably the checkpoint process.
February 5, 2015 at 11:07 pm
Only reason would be if you want some older behaviour of the query execution engine. An example there was that the *= join syntax is only available in compatibility 80...
February 5, 2015 at 10:58 am
A job cannot start if it's already executing. If a job is scheduled to start and it's already running, nothing will happen.
February 5, 2015 at 5:50 am
Yes, it shows the complete object definition.
It has to be the object definition, not the EXEC, so that you can use the statement_start_offset and statement_end_offset to pinpoint the statements (DMVs...
February 5, 2015 at 5:49 am
And about 5 more 'generating units' have gone offline. And it's still summer, I dread to think what winter's going to be like, current forecasts are we're getting the blackouts...
February 4, 2015 at 11:06 pm
Double-check the deadlock graph you get from the replay against ones from prod, it's a rather large waste of time to fix stuff based on dev and have no effect...
February 4, 2015 at 11:01 pm
Viewing 15 posts - 6,601 through 6,615 (of 49,571 total)