Viewing 15 posts - 6,856 through 6,870 (of 22,229 total)
benjamin.seidle (1/27/2015)
Any thoughts on how these stack up with the scripts from Ola Hallengren that some of us know?
I think they stack up quite well. In fact, there's some degree...
"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 27, 2015 at 10:45 pm
Brandie Tarvin (1/27/2015)
Dear SQLSaturday Speakers,
This is a one-time system message for SQLSaturday #398. SQLSaturday #398 is coming...
"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 27, 2015 at 7:59 am
Since the days of SQL Server 7.0, if I've seen backups impacting a system in a way that affected performance, it was because there were already a bunch of other...
"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 27, 2015 at 1:16 am
2 & 7. Yes.
The rest, I don't know. I'd have to go look it up. I'm sure Sean will be haunting this discussion 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
January 27, 2015 at 12:33 am
What it's like, at this exact moment, everywhere in Massachusetts.
"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 26, 2015 at 9:53 am
ChrisM@Work (1/26/2015)
Grant Fritchey (1/26/2015)
ChrisM@Work (1/26/2015)
Your wish etc etc PM me if you're sure and we'll fix it up.
Thanks! But I've already spent the money to build the other costume. Might...
"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 26, 2015 at 6:29 am
ChrisM@Work (1/26/2015)
Your wish etc etc PM me if you're sure and we'll fix it up.
Thanks! But I've already spent the money to build the other costume. Might as well go...
"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 26, 2015 at 4:50 am
ChrisM@Work (1/26/2015)
GilaMonster (1/23/2015)
Luis Cazares (1/22/2015)
Brandie Tarvin (1/22/2015)
rodjkidd (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes...
"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 26, 2015 at 2:00 am
You can't restore a table. You can restore a filegroup, so if you put the table into it's own filegroup, that can work. But otherwise, you have to restore 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 24, 2015 at 12:22 pm
sm_iransoftware (1/24/2015)
"but that means you need to be prepared to deal with a lot of data. You should probably add the query_hash to 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
January 24, 2015 at 7:43 am
If your server is already under stress, don't use Profiler on it. Since you're on 2014 (assuming this since you're in a 2014 forum), use Extended Events. They inherently cause...
"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 24, 2015 at 6:47 am
Pulivarthi Sasidhar (1/22/2015)
1. In-place upgrade
Easy to implement
...
"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 24, 2015 at 6:43 am
If you already have updated hardware, I'd say the problems are probably code and/or data structure related. You need to understand what exactly is running slow and exactly why it's...
"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 24, 2015 at 6:30 am
Sean Lange (1/23/2015)
"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 24, 2015 at 3:54 am
Jeff Moden (1/23/2015)
Grant Fritchey (1/23/2015)
sm_iransoftware (1/23/2015)
No :blush:I think I should Know more about these tools and performance Basics.
Thank you
If you really want to get into all that, I'd suggest picking...
"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, 2015 at 12:58 pm
Viewing 15 posts - 6,856 through 6,870 (of 22,229 total)