Viewing 15 posts - 4,831 through 4,845 (of 22,219 total)
jeff.mason (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
In 2016, with all of the available training, documentation, and general awareness and people STILL aren't taking backups?
Or, nuking the offsite backups along with...
"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
April 15, 2016 at 6:35 am
Sean Lange (4/14/2016)
Oh that's right. It should be
;select
BURN IT WITH FIRE!!!!
"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
April 14, 2016 at 2:35 pm
Jeff Moden (4/14/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
April 14, 2016 at 2:34 pm
This is a major tuning effort. I'd definitely be able to say more if I could see the execution plan. However, the other comments, JOINs on views, what appears 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
April 14, 2016 at 8:02 am
Hopefully you have backups in place. You may need to go to these and be prepared to do a page level restore. This is not an easy operation. Practice several...
"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
April 14, 2016 at 7:59 am
I've seen this argument before, and I actually lean towards what Jeff & Brent are advocating... if your queries are primarily seek. If you've tuned the system so you're largely...
"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
April 14, 2016 at 7:38 am
I agree with Jeff, it depends.
However, let's say Staging is really Staging, a place to validate deployments prior to production. Then no. I wouldn't have backups at all.
If they're...
"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
April 13, 2016 at 2:53 pm
You could look to mirroring. The failover to the secondary won't be instant, at all, but it'll almost do what you're looking for.
"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
April 13, 2016 at 2:50 pm
And another absolutely worth checking out:
I wrote a review of it here[/url].
"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
April 13, 2016 at 2:47 pm
nhansen pcc (4/13/2016)
Our SAN backup is actually pretty nice; it got me within 15 minutes of the time I wanted. Obviously not quite "point in time" like the SQL restore...
"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
April 13, 2016 at 8:10 am
WhiteLotus (4/12/2016)
Actually at that time I also used Performance monitor ( the value for TOTAL SERVER MEMORY was 1.6 GB – 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
April 13, 2016 at 6:14 am
nhansen pcc (4/12/2016)
If I do just a log backup in a timed job, and then restore a "snapshot" of...
"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
April 13, 2016 at 6:10 am
BL0B_EATER (4/13/2016)
ThomasRushton (4/13/2016)
BL0B_EATER (4/13/2016)
That's on my list of things to do...maybe next year:ermm:
It's on my list of things to get back to - not been since 2013.
Once I have finished...
"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
April 13, 2016 at 5:58 am
Hugo Kornelis (4/12/2016)
... - which would be rude when done by anoyone other than me. 😉
There go my plans.
"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
April 13, 2016 at 5:52 am
Eirikur Eiriksson (4/12/2016)
Will miss the breakfast but will be in time for your talk, Query Store at 11:00?😎
Is that when it is? Cool. I can sleep in a little. HA!
"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
April 13, 2016 at 5:51 am
Viewing 15 posts - 4,831 through 4,845 (of 22,219 total)