Viewing 15 posts - 2,221 through 2,235 (of 22,202 total)
Total agreement with Erland & Thom.
December 13, 2019 at 3:44 pm
Aggregates and analysis queries. That's where it shines. A really simple GROUP BY on a larger data set will immediately show the benefits. Columnstore works well with aggregates and large...
December 13, 2019 at 3:41 pm
I was told (but have not tested) that Extended Events cannot return the query that is causing an event. If that's not true, then my apologies and I'll go...
December 12, 2019 at 8:40 pm
... but rumor has it that Extended Events can't return queries for such things.
What do you mean on this one Jeff? I'm not aware of anything that Trace/Profiler...
December 12, 2019 at 3:18 pm
I'd suggest capturing the execution plans for both versions of the query and compare them. You can use the estimated plans just fine, you don't need the actuals for this....
December 12, 2019 at 2:03 pm
I'm not sure how you'd accomplish this to be honest. Microsoft's focus is on moving you into Azure, not out of it. Probably, your best bet, would be Azure Sync...
December 12, 2019 at 1:56 pm
If you've set nothing up for monitoring queries, then your only option is to use the Dynamic Management Views (DMV). There are a few directly related to queries:
December 12, 2019 at 1:48 pm
You could set up your firewall (and please, tell me you have one) so that it only allows connections from specific IP addresses or IP address ranges, that would make...
December 12, 2019 at 1:40 pm
Oh yeah, I'm not complaining that people don't use it EVERYWHERE. I'm complaining that people don't use it, even in places where it would offer a clear advantage.
December 11, 2019 at 8:34 pm
If the exec plans are the same, it's got to be a difference elsewhere. Database settings (probably not since this is a restore), server settings, os settings, vm settings. Something...
December 11, 2019 at 1:50 pm
Under most circumstances, not getting into data skew, bad column choices, etc.
Yeah.
In fact, having an index on C1 or an index on C1 and C2 as keys would be effective...
December 11, 2019 at 1:47 pm
I don't have specific data, but I think it's the same reason that people are shy about using Extended Events.
In 2008, Extended Events were introduced, but, weren't quite functional. In...
December 11, 2019 at 12:46 pm
Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.
Heh... guess I'm more ancient. I've not found much that will actually beat BCP...
December 11, 2019 at 12:36 pm
Yeah, I am ancient. I'd still pick SQLCMD or PowerShell over bcp though.
December 10, 2019 at 3:17 pm
If you can't reset to capture the older plans, you're stuck. Code modification is the best way to go. You could also look to plan guides to supply the hint.
Most...
December 10, 2019 at 3:14 pm
Viewing 15 posts - 2,221 through 2,235 (of 22,202 total)