Viewing 15 posts - 16,771 through 16,785 (of 22,226 total)
Please don't cross-post. Let's hold the discussion over here.
"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 8:17 am
OK, how about "all the databases you should be messing around with" can be accessed through sys.databases? :hehe:
"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 7:46 am
GilaMonster (8/7/2009)
Grant Fritchey (8/7/2009)
Is there a trigger or something that relates dbo.intPolicy and dbo.afl?Could be from other statements earlier in the procs if there are explicit transactions been used.
True. 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
August 7, 2009 at 7:15 am
Well, understand, I am adopting a middle way on this. Unfortunately I'm working with developers who are not. They're goal, stated, is to get DBA's out of the way so...
"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 7:12 am
dsimpson (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 7, 2009 at 6:53 am
Check out the system table sys.databases.
"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:51 am
Are you planning on storing the text, as text, or were you planning on dividing it up into some kind of relational or dimensional storage so that you can run...
"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:51 am
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
Viewing 15 posts - 16,771 through 16,785 (of 22,226 total)