Viewing 15 posts - 20,206 through 20,220 (of 59,072 total)
Ok... Chris' code on the subject of logical reads gave me an idea for different code to prove it to myself (which is no easy task). Early findings support...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2015 at 9:09 am
ChrisM@Work (6/26/2015)
Jeff Moden (6/26/2015)
Ed Pollack (6/26/2015)
https://msdn.microsoft.com/en-us/library/ms184361.aspx
If their documentation is wrong, then I'd definitely like to see some sort of proof of...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2015 at 7:57 am
GilaMonster (6/26/2015)
This industry is way too small and way too polarised to intentionally make more enemies.
Best comment on this whole thread!
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 5:48 pm
Steve Smith-307669 (6/26/2015)
"Have a nice life!"
For some reason, to me, that's dripping with sarcasm. I'd never say such a thing on an exit.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 5:47 pm
David.Poole (6/26/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 5:46 pm
ScottPletcher (6/26/2015)
Sean Lange (6/26/2015)
ScottPletcher (6/25/2015)
GilaMonster (6/25/2015)
Nolock hints, do you know what they do? (hint, they don't make queries faster)
Why does everyone keep repeating that?
Scott you have been around sql...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 5:34 pm
ScottPletcher (6/26/2015)
Jeff Moden (6/25/2015)
ScottPletcher (6/25/2015)
sgmunson (6/25/2015)
ScottPletcher (6/25/2015)
GilaMonster (6/25/2015)
Nolock hints, do you know what they do? (hint, they don't make queries faster)
Why does everyone keep repeating that? Of course NOLOCK...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 5:30 pm
Ed Pollack (6/26/2015)
https://msdn.microsoft.com/en-us/library/ms184361.aspx
If their documentation is wrong, then I'd definitely like to see some sort of proof of that (query/IO measurements,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 8:53 am
Why do people insist on making any kind of an exit statement? If management is actually concerned, they'll let you know and ask to have a talk with you....
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 8:39 am
ChrisM@Work (6/26/2015)
Ed Pollack (6/26/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2015 at 8:11 am
ScottPletcher (6/25/2015)
sgmunson (6/25/2015)
ScottPletcher (6/25/2015)
GilaMonster (6/25/2015)
Nolock hints, do you know what they do? (hint, they don't make queries faster)
Why does everyone keep repeating that? Of course NOLOCK hints make queries...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2015 at 8:06 pm
And, like I said [font="Arial Black"]here[/font], it would seem that you need to do a little "Divide'n'Conquer" and well as a bit of preaggregation although the final insert is looking...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2015 at 7:31 pm
How many indexes do you have on the HEAP that you're inserting to?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2015 at 7:28 pm
a4apple (6/25/2015)
It sounds like this structure is for a company that uses network marketing for its sales force. The problem here is that I'm not sure quite what...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2015 at 5:26 pm
As a bit of a sidebar, this is why I'm sometimes considered to be a bit of a Luddite. Everyone, especially new front-end developers but not limited to just...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 25, 2015 at 8:15 am
Viewing 15 posts - 20,206 through 20,220 (of 59,072 total)