Viewing 15 posts - 6,601 through 6,615 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 1:43 am
What are the errors?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 1:34 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:...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 1:31 am
SQLKnowItAll (2/5/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 6, 2015 at 2:27 am
Yes, it's probably the checkpoint process.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2015 at 11:07 pm
Probably the checkpoint process.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2015 at 10:49 pm
It's in sys.tables.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2015 at 10:28 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2015 at 11:01 pm
Viewing 15 posts - 6,601 through 6,615 (of 49,552 total)