Viewing 15 posts - 5,851 through 5,865 (of 22,211 total)
It sounds like you're largely on track.
On the implied relationship, I'd get that enforced if possible. The more tools you give the optimizer, the better the results.
July 8, 2015 at 5:55 am
The MAXDOP hint is a way of adjusting the degree of parallelism for a given query. It won't force parallelism onto a query. To do that, you have two options....
July 8, 2015 at 2:28 am
More memory.
July 8, 2015 at 2:27 am
I'm not sure why you're choosing to go with all the clustered indexes on the identity columns? I would only do this if that was also the primary path to...
July 8, 2015 at 2:21 am
Not sure what it is, but I've heard of others having this issue. I haven't seen it myself, so I don't have much advice.
July 8, 2015 at 2:15 am
Hey Eric, no query hint I'm aware of that will tell the optimizer to ignore an index.
Ramana, so your concern then is not whether or not an index is...
July 8, 2015 at 1:45 am
I'm not understanding all your structures. In order for the partitions to be eliminated, you have to be able to filter on them. You're saying that partitions are eliminated in...
July 8, 2015 at 1:41 am
You may have found the difference then. If this query needs to execute in parallel and production has more CPUs than Dev, that would explain why it's slower in Dev.
July 7, 2015 at 9:26 am
I'm just surprised you didn't get a table spool in 2008 with a recursive CTE. That's pretty common.
July 7, 2015 at 5:10 am
What's the clustered index on the tables? I'll bet it's the OID column. If so, it can eliminate partitions. If the other column in use has no indexes or only...
July 7, 2015 at 5:09 am
CXPACKET waits are just an indication of parallel execution. They're neither good nor bad. What other waits are being experienced? Are both production and dev set to the same number...
July 7, 2015 at 3:16 am
BL0B_EATER (7/3/2015)
Koen Verbeeck (7/3/2015)
Grant Fritchey (7/3/2015)
That reminds me of the old dot com days. It was expected that everyone was going to work like pigs, nights & weekends. Most of...
July 3, 2015 at 7:04 am
:alien:
<singing> One of these things is not like the others... </singing>
July 3, 2015 at 7:02 am
thbaig (7/3/2015)
Grant Fritchey (7/3/2015)
July 3, 2015 at 6:07 am
krypto69 (7/3/2015)
Capture the wait statistics when the procedure is run in order to understand what...
July 3, 2015 at 6:05 am
Viewing 15 posts - 5,851 through 5,865 (of 22,211 total)