Viewing 15 posts - 6,841 through 6,855 (of 22,221 total)
I like Ola's scripts and Michele's. I recommended them both in my book.
There is another option to look into. Minion Reindex by Sean & Jen McCown. I wrote a review...
"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 1, 2015 at 3:30 am
Just so you're clear on terminology.
A backup is a page-by-page copy of the database including all the database objects and the data inside the database.
You're asking for a script 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
February 1, 2015 at 3:28 am
From the sounds of things, I'd probably keep the databases separate. It's not a question of whether or not there's a need for data between the two systems. It's more...
"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 1, 2015 at 3:22 am
sm_iransoftware (1/31/2015)
the most important and repeatedly Advise is :
Dont use Repair option. because ....
The impression from this recommendation can be
1- I must run only DBCC checkDB...
"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 31, 2015 at 3:03 am
Peter Schott (1/28/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 28, 2015 at 8:03 am
Michael Valentine Jones (1/28/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 28, 2015 at 7:59 am
marcia.j.wilson (1/27/2015)
Grant, Thanks for bringing this to our attention.Sean and Jen, I'm impressed by your responsiveness.
You're welcome.
I'm unimpressed by their responsiveness because I expected nothing less. 😛
Nah, I figured they...
"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:49 pm
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
Viewing 15 posts - 6,841 through 6,855 (of 22,221 total)