Viewing 15 posts - 4,171 through 4,185 (of 22,224 total)
BLOB EATER (12/19/2016)
Grant Fritchey (12/19/2016)
BLOB EATER (12/19/2016)
I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?
I submitted sessions today....
"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, 2016 at 7:30 am
BLOB EATER (12/19/2016)
I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?
I submitted sessions today. Fingers crossed I get...
"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, 2016 at 7:07 am
ThomasRushton (12/16/2016)
Grant Fritchey (12/16/2016)
BLOB EATER (12/16/2016)
On twitter when someone adds you to a list - what does that mean?
Oh no.
Don't let anyone do that. It's horrible. Quick, go and change...
"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, 2016 at 4:34 am
BLOB EATER (12/16/2016)
On twitter when someone adds you to a list - what does that mean?
Oh no.
Don't let anyone do that. It's horrible. Quick, go and change your password and...
"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, 2016 at 2:52 am
Sue_H (12/14/2016)
tt-615680 (12/14/2016)
If you keep getting errors about running out of log space then it's likely that you aren't doing log backups often enough and/or you aren't sizing the log...
"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 15, 2016 at 2:38 am
Oh here, let me help.
"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 15, 2016 at 2:37 am
So 36% of people thought that either: You don't need to compare them since the graphical plans are the same, which is blatantly false, or that You can compare 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 15, 2016 at 2:17 am
Is your database in Full recovery? If it is in Full recovery, are you running regular log backups? If not, you need to run backups, or you need to run...
"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 14, 2016 at 3:28 am
Stewart "Arturius" Campbell (12/13/2016)
That is a really neat addition to SSMS.However, still to be taken with a pinch of salt.
How do you mean? It's just comparing the underlying XML on...
"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, 2016 at 11:47 pm
The MDW itself puts too much load on a system. The overhead is not worth the benefits. That's the number one reason I'd recommend against 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
December 6, 2016 at 10:30 am
Jeff Moden (12/3/2016)
Grant Fritchey (12/2/2016)
Talib123 (12/2/2016)
"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 4, 2016 at 3:53 am
Availability Groups only support read only secondaries. Is QA a read only process or do they do writes? If they do writes, you can't use AG to solve this 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
December 2, 2016 at 10:36 am
Talib123 (12/2/2016)
OK Grant, I might finally start looking @Extend Events.I have been avoiding it. Wish me luck.
Ha!
It's not that bad. Erin Stellato has a bunch of blog posts on getting...
"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 2, 2016 at 7:21 am
Talib123 (12/2/2016)
I would try the default trace, if your qucik enough you may get some information of what caused the files to grow and at what time.
The system_health extended event...
"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 2, 2016 at 6:48 am
Jeff Moden (12/1/2016)
Grant Fritchey (12/1/2016)
It's going to be more than a little sloppy.Not sure why anyone would say such a thing. What kind of "slop" are you taking about?
Running...
"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 2, 2016 at 6:36 am
Viewing 15 posts - 4,171 through 4,185 (of 22,224 total)