Viewing 15 posts - 2,221 through 2,235 (of 22,219 total)
I don't know Dynamics well at all, so I did a quick search. Based on this, there are three possible timeout settings that you may need to adjust. I'd...
"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 19, 2019 at 1:04 pm
Happy Yuletide! Merry Christmas! Happy New Year!
Star Wars sucks (not the first two, chronological, films, just all the rest)!
Looking forward to going to see 1917 though.
"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 19, 2019 at 12:44 pm
RESTORE DATABASE name
WITH REPLACE, --if it's there already
MOVE 'file' TO 'x:\newfile.mdf',
MOVE 'log' TO 'z:\newlogfile.ldf'
Automate this.
However, I think Phil pointed out an excellent question, should development be occurring on a production...
"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 18, 2019 at 1:44 pm
Not necessarily replication. I'm very hesitant to ever suggest using that technology because it just doesn't get adequate support from Microsoft. No, instead, if you can write once and then...
"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 18, 2019 at 1:35 pm
Grant,
what would be a short checklist
of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it into...
"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 6:54 pm
Grant,
what would be a short checklist
of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it into...
"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 6:45 pm
In most cases, performance issues are in the actual code. If you post the ACTUAL execution plan, we might be able to see where the pain points are.
It doesn't...
"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:55 pm
It's not always about performance. My company has largely stopped buying servers (I think, one in the last 6-7 years). Instead, we're hosting most things on VMs online, or in...
"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:49 pm
I'd focus on the queries to see what's causing the pain. Document it for the vendor. Also, maybe a judicious index or a plan guide could fix the issue. Capture...
"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:45 pm
By secondary I assume you mean a differential? Or maybe you mean a file or filegroup backup. If the first thing, nope. You're stuck without the primary backup. If the...
"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:36 pm
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
Viewing 15 posts - 2,221 through 2,235 (of 22,219 total)