Viewing 15 posts - 18,571 through 18,585 (of 22,219 total)
I've been a DBA, exclusively, for about 10 years now and no certification whatsoever. You just don't need one. Knowledge and experience are what really counts. If you have three...
"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
January 29, 2009 at 12:56 pm
Since the functions seem well in hand, I'll address other stuff.
You're using CONVERT on your columns in the WHERE clause. This will absolutely prevent the indexes, if any from being...
"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
January 29, 2009 at 12:01 pm
It sounds like you're locking the resource and then blocking all others, not like a deadlock. Leave the deadlock monitors in place, but you should take a look at 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
January 29, 2009 at 11:50 am
The thing is, MAXDOP is a way to limit paralellism. A lot of times, in the OLTP type systems I work in, parallel queries cost more than they provide benefit....
"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
January 29, 2009 at 8:24 am
Why do you want to mess with MAXDOP? Your default setting is 0, which means that SQL SErver will use as many processors as it has available to it. Maybe...
"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
January 29, 2009 at 7:45 am
Take a look at the information availabe on SQL Server Agent in the Books Online. You can do exactly what you want through there.
"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
January 29, 2009 at 7:41 am
As far as "when" to create a clustered or nonclustered index, I'd strongly suggest creating the cluster first, then the noncluster. Since a clustered index key defines the storage 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
January 29, 2009 at 7:37 am
My absolute favorite is Embarcadero ERSTudio. Fantastic set of functionality.
CA offers another that's extremely popular ERWin. There are a couple of others available, but those are the two big ones.
"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
January 29, 2009 at 7:32 am
The Thread (1/29/2009)
We do not know fear or pain or mercy. We will not stop. Ever.
OK. While I'm in absolute, bowel voiding fear from this...
I have to...
"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
January 29, 2009 at 7:11 am
GilaMonster (1/29/2009)
Ninja's_RGR'us (1/29/2009)
I was under the impression you were only filthy rich :D.I wish!
So that's confirmation, she's filthy rich AND a consultant. Just like the rest of those consultants, milking...
"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
January 29, 2009 at 6:43 am
I've said it before and I'll say it again, you do great work here. Thank 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
January 29, 2009 at 6:36 am
Congratulations! Well done Steve! And a hearty thank you to all the regulars. Here's to the next million.
"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
January 29, 2009 at 6:33 am
KB (1/28/2009)
I tried using a subquery as well as CTE, the results for ColA3 are not right.
Suppose Table B has 4 rows that need to be inserted into Table...
"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
January 29, 2009 at 6:07 am
GilaMonster (1/29/2009)
I was thinking the super, ultimate, extremely awesome version. Why settle for second-best?
Ah, the life of a fithy rich consultant...
"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
January 29, 2009 at 5:54 am
Bob Hovious (1/28/2009)
What are the odds of this thread evolving into SkyNet? I have children and I am worried about their future.
We've given it way too much knowledge....
"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
January 29, 2009 at 5:54 am
Viewing 15 posts - 18,571 through 18,585 (of 22,219 total)