Viewing 15 posts - 14,131 through 14,145 (of 22,224 total)
RonKyle (10/12/2010)
I think there's a bit too much fear around GUIDs.
Fear isn't the issue. In situations for which there is a simpler solution, they are a royal pain.
'
Oh absolutely....
"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
October 12, 2010 at 6:01 am
Brandie Tarvin (10/12/2010)
Paul White NZ (10/11/2010)
Jack Corbett (10/11/2010)
$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.
A cheaper room-mate?...
"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
October 12, 2010 at 5:49 am
reggie burns-317942 (10/11/2010)
Thanks for all the input.
After running update statics on 5 of the must active tables the queries are running much better, as if it was still in...
"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
October 12, 2010 at 5:43 am
I think there's a bit too much fear around GUIDs. In my own experiences, as long as they're not the clustered key, even the sequential ones, you generally won't have...
"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
October 12, 2010 at 5:37 am
Also CATCH won't catch syntactical (is that a word) errors, so you may see two errors in fact, but you'll only catch one
"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
October 8, 2010 at 4:17 pm
Craig Farrell (10/8/2010)
Alvin Ramard (10/8/2010)
Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.It's nice to see everyone can learn.
I...
"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
October 8, 2010 at 3:51 pm
Best thing you can do is pick up a copy of Itzik Ben-Gan's Inside SQL Server TSQL Querying. Make all the developers read that. That'll do more positive than any...
"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
October 8, 2010 at 11:37 am
At this point in time, coming up on 2011, SQL Server 2005 is six years old and 2008R2 is 9 months old. There'll be a new version (either SQL Server...
"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
October 8, 2010 at 11:33 am
Chris Morris-439714 (10/8/2010)
Brandie Tarvin (10/8/2010)
Chris Morris-439714 (10/8/2010)
Brandie Tarvin (10/8/2010)
Grant Fritchey (10/8/2010)
what is it we do for work again?
Work is a four letter word. My mother taught me to behavior better...
"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
October 8, 2010 at 9:03 am
Chris Morris-439714 (10/8/2010)
Grant Fritchey (10/8/2010)
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/2010)
"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
October 8, 2010 at 8:40 am
steveb. (10/8/2010)
Pradyothana Shastry (10/8/2010)
Check the indexes and as well as fragmentation level toowould an upgrade change the fragmentation level?
Assuming either a restore or attach style upgrade.... nope.
There are some...
"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
October 8, 2010 at 6:22 am
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/2010)
"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
October 8, 2010 at 6:08 am
I'm a huge fan of side-by-side upgrades. So far, knock wood, I haven't had a single 2008 upgrade go wrong, but if one did, having the 2000 server sitting there...
"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
October 7, 2010 at 1:13 pm
Prayer and living sacrifices to the gods...
Barring that... It's not that bad. It could be worse. It could be SQL Server 6.5.
Standard stuff. Make sure you have backups in place....
"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
October 7, 2010 at 1:04 pm
Brandie Tarvin (10/7/2010)
jcrawf02 (10/7/2010)
"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
October 7, 2010 at 12:38 pm
Viewing 15 posts - 14,131 through 14,145 (of 22,224 total)