Viewing 15 posts - 15,241 through 15,255 (of 22,219 total)
I sure wouldn't recommend triggers as a mechanism for this.
It really depends on what your business needs are. If you have the need for a near real time copy 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
April 29, 2010 at 11:52 am
Yeah, rearchitect the storage so that you've got normalized data.
Barring that, look at this approach for delimited lists from Jeff Moden[/url]. It'll help.
"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
April 29, 2010 at 11:48 am
I'm not aware of third party SCOM management packs for SQL Server. Microsoft has a management pack for SQL Server. We use it to do most of our SQL Monitoring....
"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
April 29, 2010 at 11:28 am
First things first, contact Blythe Morrow (blythe.morrow@sqlpass dot org) at PASS. They have a starter kit and an infrastructure that will get you going. After that, get help. There are...
"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
April 29, 2010 at 11:13 am
ricardo_chicas (4/29/2010)
I just did the Update statistics and retrieve the ten million rows is two minutes, so I am happy nowThanks to all of you
Ah, so the FULL SCAN did...
"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
April 29, 2010 at 11:03 am
izdede (4/29/2010)
In fact, I have tried restarting my machine to no...
"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
April 29, 2010 at 10:42 am
Luke L (4/29/2010)
Tom.Thomson (4/29/2010)
Dave Ballantyne (4/29/2010)
We can hate them both. Besides, they won't stop sending us beer. If you drink it, they'll keep exporting it.
You can always mark you share...
"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
April 29, 2010 at 9:40 am
Paul White NZ (4/29/2010)
Grant Fritchey (4/29/2010)
Weird. You should complain to the guys that run the site.I should. Any idea who that is? 🙂
Hard to know. Guys like that tend...
"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
April 29, 2010 at 9:27 am
Dugi (4/29/2010)
WayneS (4/29/2010)
D.Oc (4/29/2010)
My bet is on GB's not TB.Especially singe "G" is right under "T" on the keyboard...
I think we choose the situation, now what any solution scenario 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
April 29, 2010 at 9:24 am
krypto69 (4/29/2010)
I've now been told that I need to not delete any records from table C.
I'm trying to run this:
declare @DaysToRetainSMALLINT
DECLARE @cutoffdate DATE
SET @daystoretain = '200'
SET @cutoffdate = '12/01/2009'
SELECT@CUTOFFDATE =...
"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
April 29, 2010 at 9:21 am
ricardo_chicas (4/29/2010)
"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
April 29, 2010 at 9:02 am
Dave Ballantyne (4/29/2010)
We can hate them both. Besides, they won't stop sending us beer. If you drink it, they'll keep exporting it.
You can always mark you share for my attention,...
"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
April 29, 2010 at 8:44 am
Well, based on the information provided, I'd expect to see a seek, so I have to assume that some piece of information is missing. Without seeing any of the actual...
"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
April 29, 2010 at 8:35 am
It really depends on how many cpu's you have. Zero sets it to use as many as it has available. Setting it to 1 limits it to a single cpu.
"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
April 29, 2010 at 8:30 am
Paul White NZ (4/29/2010)
Grant Fritchey (4/29/2010)
Thanks. I'll pass it on if you haven't already.
I replied on Ask, but thanks for posting the thread reference there too.
I don't usually post on...
"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
April 29, 2010 at 8:28 am
Viewing 15 posts - 15,241 through 15,255 (of 22,219 total)