Viewing 15 posts - 5,116 through 5,130 (of 22,219 total)
SQL-DBA-01 (2/16/2016)
Wanted to add that, DTA sometimes recommends to create custom stats based on the workload data. Even in many cases, DBA/Dev create custom stats for the query optimizer...
"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 16, 2016 at 3:51 pm
Hugo Kornelis (2/15/2016)
Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before...
"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 16, 2016 at 10:31 am
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses...
"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 15, 2016 at 2:15 pm
jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was...
"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 15, 2016 at 8:04 am
We did have a piece of software that did that. It was discontinued.
However, you could try using SQL Compare [/url]and SQL Data Compare[/url]. They can be run against a backup...
"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, 2016 at 5:58 am
Assuming that list is also your priority order, I'd change it.
First and foremost, get the backups set up. Most importantly here, establish, with the help of the business, what your...
"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, 2016 at 4:31 am
jasona.work (2/11/2016)
Ed Wagner (2/11/2016)
jasona.work (2/11/2016)
Grumpy DBA (2/11/2016)
At least he didn't name it WOPR ("shall we play a game?").
No, that's one of my domain controllers.
It's an older box.
😎
(Now I want 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
February 12, 2016 at 4:16 am
Yes, there's not built-in file expiration. You can set the size of your files and limit the number of rollover files, but you can't have them automatically remove themselves. 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 11, 2016 at 2:54 pm
I'm pretty sure you have to manage that outside of the extended events session. It doesn't manage data files. It just collects them.
"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, 2016 at 11:22 am
I prefer a server named Colossus, but I've always loved the classics.
"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, 2016 at 5:46 am
Excellent. I wasn't aware of that.
"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 10, 2016 at 10:25 am
Muhanned Maayeh-445298 (2/10/2016)
Grant Fritchey (2/10/2016)
Muhanned Maayeh-445298 (2/10/2016)
Grant Fritchey (2/10/2016)
Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.
I certainly hope not but, I think...
"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 10, 2016 at 8:49 am
Muhanned Maayeh-445298 (2/10/2016)
Grant Fritchey (2/10/2016)
Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.
I certainly hope not but, I think these releases will have...
"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 10, 2016 at 8:28 am
Be prepared for a lot of friction. It's actually difficult to coordinate releases of this type.
"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 10, 2016 at 7:42 am
PSB (2/10/2016)
How can I investigate that ? When I look at...
"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 10, 2016 at 6:52 am
Viewing 15 posts - 5,116 through 5,130 (of 22,219 total)