Viewing 15 posts - 18,781 through 18,795 (of 22,219 total)
gary (1/12/2009)
Im on SQL Server 2000 and i read CTEs are not supported?
From what ive read also, my first example...
"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 12, 2009 at 9:20 am
Beating accepted. 😀
I just remember seeing the solution in his book. It's not something I played with a lot myself, mainly because I long stopped worrying about gaps in an...
"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 11, 2009 at 9:53 am
Yeah, but "reflect in another block"?
"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 9, 2009 at 1:32 pm
Utterly and completely lost me on that 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
January 9, 2009 at 1:32 pm
Jack Corbett (1/9/2009)
Grant Fritchey (1/9/2009)
Jack Corbett (1/9/2009)Hey, that's why I've spent the last 2+ months in NH.
Because my wife told you too?
Every married man has a "She who must be...
"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 9, 2009 at 11:29 am
You need to go back to the TSQL that the GUI is doing for you. You can script all the restores using:
RESTORE DATBASE X FROM DISK/DEVICE = 'Something' WITH REPLACE,...
"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 9, 2009 at 11:23 am
It could be generated code. A lot of the code generators put that in so that everything can be "AND" from that point forward.
"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 9, 2009 at 11:19 am
Jack Corbett (1/9/2009)Hey, that's why I've spent the last 2+ months in NH.
Because my wife told you too?
"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 9, 2009 at 11:18 am
george sibbald (1/9/2009)
Grant Fritchey (1/9/2009
No imagination required. I have two kilts (so far) and I've done all sorts of work in them. I don't see the issue 😛
.
from your angle...
"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 9, 2009 at 11:07 am
GilaMonster (1/9/2009)
Grant Fritchey (1/9/2009)
Oh heck yes. I've got no issues with heat. You sweat, what's the big deal?Cold hurts.
I'm actually the other way around. The heat just kills 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
January 9, 2009 at 11:04 am
Jack Corbett (1/9/2009)
Steve Jones - Editor (1/9/2009)
I'm with Grant, heat, heat, heat.I like skiing, but other than that, I'd like warm weather all the time.
Denver doesn't seem like the right...
"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 9, 2009 at 11:03 am
jpowers (1/9/2009)
"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 9, 2009 at 10:40 am
Steve Jones - Editor (1/9/2009)
And Grant in a suit!?!?!!!
I can sometimes pretend to be civilized for hours at a time.
"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 9, 2009 at 10:36 am
Jeff Moden (1/9/2009)
"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 9, 2009 at 10:28 am
rtbhosale (1/9/2009)
I have tried the BULK INSERT by using .csv file it is working correct.
Because i have not specified the KEEPIDENTITY attribute it was giving incorrect result.
Thank...
"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 9, 2009 at 8:05 am
Viewing 15 posts - 18,781 through 18,795 (of 22,219 total)