Viewing 15 posts - 18,556 through 18,570 (of 22,202 total)
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...
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....
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...
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.
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...
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.
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...
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...
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.
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.
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...
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...
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....
January 29, 2009 at 5:54 am
GilaMonster (1/28/2009)
Steve Jones - Editor (1/28/2009)[hr "whether its transaction log backups, and XML indexes or whizbang fiber-optic laser beam assemblers." that were copied word for word, and these aren't phrases...
January 29, 2009 at 5:43 am
Cover your ears...
An execution plan is an execution plan. They all age and when the cache cleanup process comes along, they get removed from cache. No differences for stored procedures.
The...
January 28, 2009 at 12:22 pm
Viewing 15 posts - 18,556 through 18,570 (of 22,202 total)