Viewing 15 posts - 19,936 through 19,950 (of 22,226 total)
Your previous post scared me. I wasn't entirely kidding about sticking a fork in myself as a comarison. Using CLR is of questionable benefit in most situations. This one is...
"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
July 22, 2008 at 5:27 am
So what do I do with these pork chops? Sharpen the bones & throw 'em like a boomarang?
"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
July 22, 2008 at 5:24 am
Replaying Trace does work. It's a bit of a pain to set up, but it does work. However, a Trace is dependent on you already having a database and application...
"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
July 21, 2008 at 12:15 pm
I liked "DBAs of Dawn" better.
"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
July 21, 2008 at 12:00 pm
I've done a ton of testing of SQL Server 2000 and 2005. I've never tried load testing replication before, so I'm not sure of anything that would help you there.
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
July 21, 2008 at 10:26 am
It's not normal for a single procedure to take all the resources, no. But if the query is really poorly written or designed, it certainly could happen.
I'd make sure you...
"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
July 21, 2008 at 8:07 am
Nice post. Good set of rules. But now we'll have to refer to you as Jeff Isaac Rbar Moden. You're starting to sound like a Civil War general.
"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
July 21, 2008 at 7:16 am
Is it safe to assume that MovementIdentifierContext, MovementIdentifier and MovementIdentifierContext, while not unique as noted, combined identify a given Movement? Or is it just the IdentifierContext and IdentifierComposite fields, those...
"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
July 21, 2008 at 7:12 am
There's not enough information in the question to give you specfic answers, but some general thoughts I would have when faced with the general situation...
Can you test the update against...
"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
July 21, 2008 at 6:52 am
You can also need to update statistics on smaller tables where large percentages of the data changes regularly.
"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
July 21, 2008 at 6:45 am
No doubt. I wouldn't do it. Ever. I was just pretty sure that it was possible. It's also possible to stick my fork into my thigh... I'm not doing that...
"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
July 21, 2008 at 6:43 am
You've got two different issues you're going to be working with. First, the lack of PK & FK in the database could lead to serious integrity issues. That means 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
July 21, 2008 at 6:35 am
TRY/CATCH itself has no performance implications. What you do in the CATCH statement could have serious performance implications.
"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
July 21, 2008 at 6:30 am
This is something normally handled on the client, as was already said. But, you could use a CLR query to do it. I wouldn't recommend it, but it is possible....
"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
July 21, 2008 at 6:24 am
Steve Jones - Editor (7/18/2008)
I think Grant and Jeff must be related to Dwight Shroot. Sorry you guys lost your privileges to bring nunchakus and stars into the office.
That's actually...
"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
July 18, 2008 at 9:46 am
Viewing 15 posts - 19,936 through 19,950 (of 22,226 total)