Viewing 15 posts - 18,781 through 18,795 (of 22,226 total)
Jeff Moden (1/13/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 13, 2009 at 6:37 am
If you're not using SSIS, you might want to look into 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
January 13, 2009 at 6:34 am
I've used VS2008 TSDBE in a team environment with the database objects all in source countrol in TFS. It works really well, especially the new GDR version that works with...
"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 13, 2009 at 6:32 am
Functionally, I don't see any major difference between the two. Seriously. However, since we're dealing with human beings, I agree with you. Never over-write an existing back-up, using a single...
"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 13, 2009 at 5:58 am
Jack Corbett (1/12/2009)
Sergiy (5/28/2007)
If you don't specify the version that means it must work on EVERY version, not only the one you know.
Of course these means that CTE's are out...
"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 13, 2009 at 5:41 am
Can post the whole execution plan? Save it as .sqlplan file and zip it up.
On a guess, it's performing an aggregation to satisfy the criteria. It might be accessing 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
January 12, 2009 at 1:15 pm
rons (1/12/2009)
1) What is the "logical device" and how is that usually expressed? Same question for the physical device location?
...
"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:28 am
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
Viewing 15 posts - 18,781 through 18,795 (of 22,226 total)