Viewing 15 posts - 2,236 through 2,250 (of 22,224 total)
There's not enough information here to go on. We could be looking at all sorts of things from bad or missing indexes, out of date statistics, blocking and locking, to...
"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
December 17, 2019 at 12:33 pm
You are in a tough spot. Most organizations, like you, don't have adequate IT experience and knowledge to manage development well, assuming you get a good contractor who isn't out...
"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
December 17, 2019 at 12:01 pm
Sorry. That was meant as a joke. Apologies.
"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
December 16, 2019 at 3:29 pm
Both? I mean if we're going for clarity. Although, if I see xxTable as a parameters defined data type, I'm going to assume something custom.
"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
December 16, 2019 at 2:46 pm
Online trading didn't kill financial advisers, prefab construction didn't kill architects, TV dinners didn't kill professional chefs, blogging didn't kill journalism, NoSQL didn't kill SQL, and DaaS won't kill...
"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
December 16, 2019 at 2:31 pm
I've been saying this for years. Take CosmosDB. No DBA needed. However, there is an HA/DR aspect to it. There is the need for performance tuning. There is a need...
"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
December 16, 2019 at 2:11 pm
You're looking a fully customized CRM solution built from scratch? Yeah, a few months, at least, to deliver that. However, weeks to start releasing code to you if they're doing...
"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
December 16, 2019 at 2:06 pm
Do you have to be able to both read and write in each of these locations? If so, that radically complicates the issue. If all writes are to a single...
"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
December 16, 2019 at 2:03 pm
Total agreement with Erland & Thom.
"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
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...
"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
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...
"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
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...
"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
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....
"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
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...
"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
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:
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 12, 2019 at 1:48 pm
Viewing 15 posts - 2,236 through 2,250 (of 22,224 total)