Viewing 15 posts - 20,971 through 20,985 (of 22,219 total)
You're preaching to the choir now. I have a name plate (made by my boss as a joke/award) that says "The Scary DBA" because I've lifted scalps in the past....
"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
March 3, 2008 at 8:22 am
Oh, I just thought of another one you can do. When you suggest some change to schema or process that will improve up time or performanc and the developers baulk,...
"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
March 3, 2008 at 7:54 am
My developers don't listen to me either.
From the sounds of things, I'd do three things. First, when they have an issue with something that you propose, gather all the statistics...
"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
March 3, 2008 at 7:39 am
You are very likely not going to solve the problem. If the two processes are fighting for resources you have to put severe limits on one or both which 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
March 3, 2008 at 7:30 am
vishnu.swamynathan (3/3/2008)
Dear friends,Anybody can tell me deeply, about normalization (All types) with simple examples?
Vishnu S
Since this is a completely different topic from the one under discussion, you should...
"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
March 3, 2008 at 7:12 am
If I'm reading this correctly, you have:
Select leagueplayer, ltID, approved From leagueplayers ltID= xID
What I would expect to see in a SQL Server query is something like this (cleaned up...
"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
March 3, 2008 at 6:52 am
I've seen the optimizer choose to do index scans rather than table scans, even when the difference shouldn't matter. In this case, it sounds like it's a better index 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
March 3, 2008 at 6:47 am
Yeah, always more than one way to skin a cat.
"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
March 3, 2008 at 6:43 am
If I understand the question, you could add an extended property to identify the current version of the procedure.
"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
March 3, 2008 at 6:42 am
You'll have to walk through the databases on the server. Try something like this. It'll work, but it's not perfect.
sp_msforeachdb 'select DB_NAME() AS ''DBName''
FROM INFORMATION_SCHEMA.TABLES t
WHERE t.TABLE_NAME = ''Customer'''
"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
March 3, 2008 at 6:40 am
I agree with what most everyone has posted here. We have ten questions we ask everyone. They're really easy questions, insulting even, if you know SQL Server to even 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
March 3, 2008 at 6:22 am
Make sure you do the initial read to get the next 100 unflagged records with UPDLOCK (update lock) so that those records are no longer available for the next user...
"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
March 3, 2008 at 5:37 am
Sorry, I'm just not that acquainted with the details of implementation any more. I wrote a whole app against direct calls to ODBC about 13 years ago, but... It's all...
"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
February 29, 2008 at 11:41 am
Sorry, missed 3) I agree. Cursors are a killer. It doesn't much matter if it's client or server side. However, if you're talking disconnected, then client side is the least...
"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
February 29, 2008 at 9:46 am
I don't know, I've seen your posts, Jack. You look pretty knowledgeable. I know I could learn from you.
BTW, we are hiring over here in the Island of Rhode (aka...
"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
February 29, 2008 at 9:43 am
Viewing 15 posts - 20,971 through 20,985 (of 22,219 total)