Viewing 15 posts - 2,101 through 2,115 (of 22,219 total)
44 years as a software developer; starting from a mainframe using PL/1, then programming assembler on Intel 8080 8-bit microprocessors, to C++ and now C# on Intel servers. I've...
"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
January 23, 2020 at 2:45 pm
LadyRuna wrote:Get off my lawn.
Whoa! Whoa! Whoa!
This is my lawn. You get off my lawn.
Oh, and test your backups on the way.
Can we find a way to use...
"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
January 23, 2020 at 2:44 pm
Get off my lawn.
Whoa! Whoa! Whoa!
This is my lawn. You get off my lawn.
Oh, and test your backups on the way.
"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
January 23, 2020 at 2:20 pm
i'm going to re-read the phoenix project (for about the 5th time) and seek wisdom. 🙂
I need to get the Unicorn Project and read it.
"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
January 23, 2020 at 2:19 pm
Piling on because this bears repeating.
Yes, in order to do recovery you need backups. Further, in order to ensure your backups are good, you need to test them regularly. 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
January 23, 2020 at 1:50 pm
I agree with what Anthony posted above and I would add one wrinkle.
After the upgrade, leave your databases at the old compatibility mode for a period of time. Run Query...
"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
January 23, 2020 at 1:48 pm
I'm not sure you have a spinlock problem based on what you've posted. I'd suggest more reading here and here (especially Paul's post).
In general, start with wait statistics...
"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
January 23, 2020 at 1:46 pm
That's not a shock really. But a little more sharing ahead of time, might, might, prevent some outages.
"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
January 23, 2020 at 1:13 pm
but you are correct - dammit , now I want to buy a Pi and see what I can do
AND
on this note, SQL Server on Edge is now 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
January 23, 2020 at 1:10 pm
I always loved having to work with logic like this:
DBAs are an aging population.
Duh! Isn't the whole population aging?
I'm a PROUD CC
Yeah, that qualifies.
"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
January 23, 2020 at 1:09 pm
Congrats on the license upgrade. one more level to go.
We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better or cheaper...
"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
January 23, 2020 at 1:08 pm
thanks Grant, now I can't CC anyone on an email without feeling guilty (and buying cakes for everyone.)
I used to be cranky, but now i'm the nice DBA who...
"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
January 23, 2020 at 1:06 pm
I realized not long ago that I’ve spent a good 20 years complaining about how cranky and curmudgeonly SQL DBAs can be. Now I’ve joined their ranks.
Welcome to 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
January 23, 2020 at 1:05 pm
You have a starting point. There are some primary keys. Heck there are two foreign keys that I saw. So, again, this is largely a paper process to start, spread...
"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
January 22, 2020 at 7:19 pm
Agreed. Excellent point.
"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
January 22, 2020 at 6:44 pm
Viewing 15 posts - 2,101 through 2,115 (of 22,219 total)