September 7, 2015 at 7:25 am
Hi guys,
I was reading the following from BOL ( which is news to me and was wondering it was really true) ... as I find it a slightly odd? The key part being the "after SQL Server is restarted"
"if a new index is added from which the stored procedure might benefit, optimization does not occur until the next time that the stored procedure is run after SQL Server is restarted"...
If it is true.. I have a lot still to learn.
September 7, 2015 at 7:26 am
More garbage from BoL, and trivial to test and prove false.
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
September 7, 2015 at 7:29 am
thanks for replying - I have an army of people demanding I reboot a SQL instance.... uhhhhm, this will be interesting to try and explain.
September 7, 2015 at 7:30 am
So write up a test and prove that BoL is wrong. Not hard thing to test.
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
September 7, 2015 at 7:33 am
Fair comment - thanks for the advice.
cheers.
September 8, 2015 at 6:57 am
BL0B_EATER (9/7/2015)
Hi guys,I was reading the following from BOL ( which is news to me and was wondering it was really true) ... as I find it a slightly odd? The key part being the "after SQL Server is restarted"
"if a new index is added from which the stored procedure might benefit, optimization does not occur until the next time that the stored procedure is run after SQL Server is restarted"...
If it is true.. I have a lot still to learn.
The team that supports BOL is pretty good about updating bad information. Can you post where exactly you found that? I'd be happy to pass it on to them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2015 at 7:26 am
Grant Fritchey (9/8/2015)
BL0B_EATER (9/7/2015)
Hi guys,I was reading the following from BOL ( which is news to me and was wondering it was really true) ... as I find it a slightly odd? The key part being the "after SQL Server is restarted"
"if a new index is added from which the stored procedure might benefit, optimization does not occur until the next time that the stored procedure is run after SQL Server is restarted"...
If it is true.. I have a lot still to learn.
The team that supports BOL is pretty good about updating bad information. Can you post where exactly you found that? I'd be happy to pass it on to them.
Yes sure thing, I read it here - 1st paragraph
https://technet.microsoft.com/en-us/library/ms190439(v=sql.105).aspx
September 8, 2015 at 7:40 am
That entire page is misleading. Not so much wrong, as inadequate and hence misleading.
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
September 8, 2015 at 8:56 am
Thanks. Passed the word on. Gail, if you feel like piling on, please do so.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2015 at 10:24 am
Well, I'm wrong today. Microsoft says that they fixed in the newer version of the documentation. Of course, if you look at the old documentation...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 9, 2015 at 12:47 am
Makes slightly more sense when comparing it to the 2008R2 docs. Thanks for following up!
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply