Viewing 15 posts - 16,771 through 16,785 (of 22,219 total)
How about trying a GROUP BY on the incoming date and a MAX on the effective date?
SELECT e.IncomingDate
,MAX(e.EffectiveDate)
FROM dbo.Employees e
GROUP BY e.IncomingDate
Wouldn't that do 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
August 7, 2009 at 6:49 am
You can get the list of deprecated items from a search on MSDN. You can run DTS inside SSIS, but the behavior is very inconsistent. You'll need to do a...
"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 7, 2009 at 6:44 am
Is there a trigger or something that relates dbo.intPolicy and dbo.afl?
"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 7, 2009 at 6:41 am
If you're using the command "backup database" then you're getting a bit-by-bit copy. Nothing should be lost, data, structure, procedures... nothing.
"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 7, 2009 at 6:37 am
First, two instances on the same server are likely to run into contention. In all likelihood, one of them is using all the memory and the other is starving. As...
"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 7, 2009 at 6:33 am
But you're not going with VSS are you? 3rd party perhaps?
I'd think that MS must surely get TFS on to 64bit most riki tik.
"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 7, 2009 at 5:31 am
Sounds like you have it well enough in hand based on what you're dealing with. Did you get the kind of information you were looking for?
"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 7, 2009 at 5:26 am
GilaMonster (8/6/2009)
Grant Fritchey (8/6/2009)
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:13 pm
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
Viewing 15 posts - 16,771 through 16,785 (of 22,219 total)