Viewing 15 posts - 17,416 through 17,430 (of 22,226 total)
Ooooh. Cool. I like that one. You could really mess with people's heads with this.
"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
May 20, 2009 at 6:24 pm
Changing as little as possible... yeah, that's probably a good way to go. I assume that the larger index is the most common access path? If the smaller index is,...
"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
May 20, 2009 at 1:30 pm
Dean Jones (5/20/2009)
I have quite a few questions and thought instead of starting separate threads, I ask it all in one.
1) I know SQL 2005/2008 has built in maintenance...
"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
May 20, 2009 at 1:27 pm
By the way, with a little more experimentation, this also works:
SELECT 'dude'dudette
"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
May 20, 2009 at 1:06 pm
Wild. I've never seen that before. Cool. Good job figuring it out. I can sleep tonight now. Thanks.
"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
May 20, 2009 at 12:56 pm
OK. Spill.
"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
May 20, 2009 at 11:51 am
I just did several searches on Connect. I don't see this listed anywhere. Weird stuff. I think I'm going to post it to another newsgroup to see if others 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
May 20, 2009 at 11:50 am
Florian Reischl (5/20/2009)
Grant Fritchey (5/20/2009)
Florian Reischl (5/20/2009)
rofl!!!
Hey! Don't laugh at me. Just tell me what it is.
I'm starting to feel like Earl in Tremors:
"Hell Earl, everyone knows all about...
"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
May 20, 2009 at 11:48 am
Florian Reischl (5/20/2009)
rofl!!!
Hey! Don't laugh at me. Just tell me what it is.
I'm starting to feel like Earl in Tremors:
"Hell Earl, everyone knows all about these things. We just...
"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
May 20, 2009 at 11:41 am
Yeah, based on the behavior so far, that's about what I would expect. It's like some kind of alias short hand, but it doesn't work for strings. If you try...
"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
May 20, 2009 at 11:38 am
Weird isn't it? I've searched through the syntax in BOL and several books as well as a Google search. I can't find anything that references this type of syntax. I'm...
"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
May 20, 2009 at 11:21 am
Wow. I didn't realize that reference would be completely missed. Not that I know squat about the actual Woodstock. I just saw the documentary. There was a long, rambling, silly...
"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
May 20, 2009 at 11:00 am
ANNOUNCEMENT: Pay attention everyone. We've just been informed that there is a problem with the brown SQL statements. So we need you to stay away from the brown SQL statements....
"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
May 20, 2009 at 10:31 am
Alvin Ramard (5/20/2009)
Lynn Pettis (5/20/2009)
You know, there are a few people who just need to walk away from the computer and get a job flipping burgers or something.
You remind me...
"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
May 20, 2009 at 9:07 am
You can look at the script being used by SSMS, just click on the script icon. That should allow you to figure out what it's doing differently than 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
May 20, 2009 at 7:32 am
Viewing 15 posts - 17,416 through 17,430 (of 22,226 total)