Viewing 15 posts - 1 through 15 (of 361 total)
Back in the day people used to talk about making sure you used all the parts of the name to prevent extra lookups on default schemas and so on.
May 10, 2018 at 7:01 pm
Surprised that no one has commented on the overhead of the table variable.
September 17, 2017 at 7:48 pm
As a matter of interest - did you have the same block size disk format?did you experience file growth?If so did you have the same size db...
February 15, 2017 at 5:55 pm
What utter flamebait.
As to people who are saying it's the DBA's job to index - Developers can't possibly be expected to grasp the subtleties... hogwash.
May 6, 2016 at 1:20 am
Curious to see how it works with a non unique clustered index.
April 11, 2016 at 6:54 pm
Might be worth noting that the default collation on a modern 2014 install appears to be different depending on your os locale settings... so some of the servers will...
January 17, 2016 at 5:51 pm
May I suggest showing an extra couple of screenshots of the query plans showing where to see the implicit conversion? It might add a little to the learning experience....
June 22, 2015 at 4:13 am
I've had similar issues before, also being an sp_helptext fan, but typically got round it by adjusting results to text and upping the output in query options.
I suspect that some...
June 18, 2015 at 2:59 am
Thanks, guess it's obvious when you know 😉
Cheers for the info!
June 17, 2015 at 6:47 am
I do tend to think that if it's important enough for you to want to analyse it in depth, it's important enough for you to learn how to do that...
January 12, 2015 at 4:19 am
So... to summarise my findings:
Server - Physical, 2x8CPU, 128GB Ram
MAXDOP 5 or above
Numa ALL Auto
Numa 1 or more Cores...
August 5, 2014 at 9:55 am
Looking into this in more detail over at http://msdn.microsoft.com/en-us/library/gg415714.aspx
This is a whitepaper Understanding and Controlling Parallel Query Processing in SQL Server
Writers: Don Pinto, Eric Hanson
Guessing it will...
August 5, 2014 at 9:31 am
Thanks for the input, found it a bit puzzling tbh.
August 5, 2014 at 9:24 am
Further fiddling suggests it is happy to parallelize even with only one core per numa node... I always understood it preferred to keep it on a single node.
Yes, I don't doubt it.
Any idea why using a single Numa node with 8 cores would throw away the parallel plan, whereas using both nodes, but limited to maxdop 6...
August 5, 2014 at 9:19 am