Viewing 15 posts - 1,981 through 1,995 (of 22,232 total)
Not going to lie, I was hoping more people got this wrong.
"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
February 13, 2020 at 12:46 pm
Just remember, while this may be tough, constraints are what keep us from getting dirty data, and you are already dealing with dirty data. Cleaner data means better analysis. Better...
"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
February 13, 2020 at 11:32 am
I have not implemented this, but I believe what you're looking for is covered in the Activity Logs. If you were only monitoring a given "server" within Azure, you...
"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
February 12, 2020 at 12:56 pm
Honestly, for a few documents, probably filestream. For lots of documents as you're describing, don't use SQL Server. It's not going to do a good job. Determine if you 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
February 12, 2020 at 12:52 pm
There's no easy way to do this other than querying all the tables... Or, ensuring that the code that is generating your inserts is using appropriate data. The application shouldn'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
February 12, 2020 at 12:46 pm
Not enough to go on.
First, fundamentally a deadlock is a performance problem. If all the locking occurs so fast that there's no interference, you will never see deadlocks. So, I...
"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
February 12, 2020 at 12:43 pm
It's funny that the biggest concern is actually guaranteed to happen. You are going to disrupt your existing work flow. That's sort of the point. I also see this as...
"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
February 12, 2020 at 12:32 pm
SQL Server doesn't manage it's memory in one giant pool. It segments the memory management into different areas with different purposes for efficiency of the management.
The plan cache is 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
February 12, 2020 at 12:29 pm
Honest to god, I thought it was .index.
"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
February 12, 2020 at 12:22 pm
Here is the question that I wonder - how does it make sense to risk one's livelihood working for a company that doesn't upgrade?
Great point and, I'm sure, an...
"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
February 11, 2020 at 4:40 pm
I joined an IT operations department in 2013. At the time, they were all on 2008 R2. I warned them at the time that they should begin upgrading immediately....
"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
February 11, 2020 at 2:42 pm
Now, Grant, to answer your question ("Tell me why rolling the dice and planning on good luck is the more sensible approach?"), my answer is only one thing; budget....
"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
February 11, 2020 at 2:18 pm
While I completely agree that a controlled upgrade path is absolutely valid for service machines, where I work we produce software dependent upon older environments for builds. These are...
"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
February 11, 2020 at 2:14 pm
Oddball code bug related to rescheduling QOTD. It was scheduled for one day, moved to another, that affected the link. They're working on 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
February 11, 2020 at 2:11 pm
Cheers Grant
Testing appears to be working, so I'm going for it. Just wondered if anyone else had tried.
I may ask a loaded question at one your SQL Bits sessions...
@Frederico...
"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
February 11, 2020 at 2:09 pm
Viewing 15 posts - 1,981 through 1,995 (of 22,232 total)