Viewing 15 posts - 16,786 through 16,800 (of 22,226 total)
Jeff Moden (8/6/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
August 6, 2009 at 1:03 pm
Jeff Moden (8/6/2009)
Grant Fritchey (8/6/2009)
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
I recognize...
"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
August 6, 2009 at 12:02 pm
Yep, absolutely. Every one is running a different instance. You can't have them share an instance. Each is a different code base showing different versions from @@Version.
"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
August 6, 2009 at 11:22 am
Yes & no. You can work directly with the files in source control through SSMS, but you can't work directly with database objects IN source control, no such thing. Source...
"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
August 6, 2009 at 7:02 am
Team Foundation Services or (shudder) Visual SourceSafe will both work. Understand, you'll be versioning the scripts that define the objects in the database, not the objects in the database themselves....
"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
August 6, 2009 at 6:44 am
How many places was this posted? This is the third that I've seen.
Many, maybe most, of the people who read the forums & answer questions regularly hit most of 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
August 6, 2009 at 6:35 am
I'm running 2000, 2005, 2008, Compact and three different versions of Express, all on the same desktop. Luckily I'm only accessing one or two a time or the machine would...
"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
August 6, 2009 at 6:33 am
That could be the compile time and the time needed to move the data from disk to memory and from there to your machine. All that adds up. Instead 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
August 6, 2009 at 6:29 am
It does depend on what you're trying to do. You can save a query as a view, a procedure, a function... If it's just a pre-defined select statement, you probably...
"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
August 6, 2009 at 6:27 am
A CTE can be used multiple times within a single statement, but it can't be shared across statements. If you need to use it twice, you'll either have to create...
"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
August 6, 2009 at 6:24 am
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
I recognize that mood. Have fun!
"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
August 6, 2009 at 5:46 am
Grant Fritchey (8/5/2009)
I'm feeling a bit stupid. I thought RPG = Role Playing Game.
While I may be that old, I did get my start in IT a little later than...
"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
August 5, 2009 at 9:31 am
TheSQLGuru (8/5/2009)
Grant Fritchey (8/5/2009)
I can't support .rar compression files at work (don't ask). Can you zip the files?Grant, aren't you supposed to be doing WORK at work?? 😀
SSHHHHHH!
"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
August 5, 2009 at 9:23 am
I'm feeling a bit stupid. I thought RPG = Role Playing Game.
"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
August 5, 2009 at 9:23 am
We've been using Microsoft Visual Studio Team Edition for Database Professionals. It allows us to hook right into the existing development metholodogies with labelling, version control, build #'s, the works....
"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
August 5, 2009 at 7:43 am
Viewing 15 posts - 16,786 through 16,800 (of 22,226 total)