Viewing 15 posts - 12,196 through 12,210 (of 22,219 total)
Like Gus says, just use the command line. To set it up automatically, just use SQL Agent and have one step that does the backup and, assuming successful completion 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
July 18, 2011 at 2:43 am
I'm very confused by the question. You're talking about backups, result sets and ISNULL all at the same time. They're not really related to one another.
If the app is 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
July 18, 2011 at 2:41 am
jmaia (7/12/2011)
Ninja's_RGR'us (7/12/2011)
I'm no expert in waits but I'll hang around if I can help more.
What's the normal use of the system? OLTP, OLAP,...
"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
July 12, 2011 at 10:07 am
Trey Staker (7/11/2011)
Grant, Thanks for writing this book and thanks to you and red gate for putting online for free in PDF format.
Thanks. I hope it's helpful.
"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
July 11, 2011 at 5:19 pm
CDA (7/11/2011)
I've passed this on to my team for recommended reading.
second question: why does the word Kindle in front of Ebook bump 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
July 11, 2011 at 5:18 pm
Ninja's_RGR'us (7/11/2011)
Hey grant I've surfed to http://www.scarydba.com/2008/07/02/code-from-dissecting-sql-server-execution-plans/ to download the code of the book and I just can't seem to find the download button.Care to help a blind man?
Not sure....
"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
July 11, 2011 at 5:18 pm
SQLkiwi (7/5/2011)
"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
July 7, 2011 at 6:58 am
Ninja's_RGR'us (7/4/2011)
"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
July 4, 2011 at 7:02 am
GilaMonster (7/3/2011)
What Paul mentions is MVP-specific stuff that come straight to us (eg spending time in the 'ask the experts', hosting a 'birds of a feather' lunch...
"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
July 4, 2011 at 6:44 am
opc.three (7/2/2011)
opc.three (7/2/2011)
Lynn Pettis (7/2/2011)
"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
July 3, 2011 at 5:56 am
TST1 (7/1/2011)
Thanks Gail, but the guy closed his session so I guess he'll have to re-write!
I did the same thing myself a couple of weeks back. This little query[/url] saved...
"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
July 1, 2011 at 11:20 am
Jim Murphy (7/1/2011)
Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!
DITTO!
"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
July 1, 2011 at 11:13 am
Just using a SQL Query? No.
You can program it, but you'd want to look into using something like Powershell in combination with SMO in order to do 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
June 30, 2011 at 8:08 am
Speaking honestly, there is no best tool. There is a best tool for your situation and the amount of money you're prepared to spend and the type of monitoring 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
June 30, 2011 at 7:15 am
sqlnaive (6/29/2011)
Here is the attachment. I've scratched my head blue and black. 🙁
The optimizer is timing out on this query, so whatever plan you have is less than optimal.
Why all...
"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
June 30, 2011 at 7:03 am
Viewing 15 posts - 12,196 through 12,210 (of 22,219 total)