Viewing 15 posts - 12,196 through 12,210 (of 22,224 total)
How about normalize appropriately?
For a datawarehouse? I'd suggest looking at a star schema. I'd consider that normalized, but not necessarily in third normal form.
"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 8:50 am
AlexSQLForums (7/18/2011)
Grant Fritchey (7/18/2011)
AlexSQLForums (7/14/2011)
it does recommend creating indexes on every column in the where...
"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 8:20 am
Jayanth_Kurup (7/18/2011)
If SQL is already compressing the backup then using winzp or winrar doesnt do a great job...
"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 5:07 am
AlexSQLForums (7/14/2011)
it does recommend creating indexes on every column in the where clause and depending...
"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:53 am
You scared me very badly. I can't imagine saying that DTA would do a better job than an experienced DBA.
Personally, I'm extremely underwhelmed by what the DTA delivers. Is 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
July 18, 2011 at 2:51 am
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
Viewing 15 posts - 12,196 through 12,210 (of 22,224 total)