Viewing 15 posts - 3,751 through 3,765 (of 8,416 total)
General advice:
Check that threads are processing a roughly equal number of rows.
Ensure useful, up-to-date statistics are available.
Avoid order-preserving exchanges where possible.
Check the type of partitioning being used.
Avoid driving parallelism from...
April 20, 2010 at 8:44 pm
Hey Tom,
The article has a small error when it comes to using Method 2: a clustered index is *required* to take advantage of the Quirky Update method. This is...
April 20, 2010 at 7:40 pm
Matt Miller (#4) (4/20/2010)
April 20, 2010 at 6:21 pm
Hugo Kornelis (4/20/2010)
April 20, 2010 at 6:14 pm
Aspet Golestanian Namagerdi (4/20/2010)
Thanks a lot for your reply.But,I just was wondering if I can re-produce primary key violation in Second(SP2) by using Raiserror.
No, you are limited in the range...
April 20, 2010 at 6:05 pm
CirquedeSQLeil (4/20/2010)
Unfortunate score - really.
:laugh: Though if I remember correctly, the Number of the Beast is 616, not 666...
April 20, 2010 at 6:01 pm
CirquedeSQLeil (4/20/2010)
April 20, 2010 at 6:01 pm
PaulB-TheOneAndOnly (4/20/2010)
Statement is correct but, it is good to remember PKs are built on top of not-null columns because PKs are there to enforce referential integrity.
While we are splitting hairs,...
April 20, 2010 at 5:55 pm
ALZDBA (4/20/2010)
Can you use that kind of filtered index for DRI purposes?
Not for enforcement purposes, no - you need an unfiltered UNIQUE index/constraint or a PRIMARY KEY.
It can be used...
April 20, 2010 at 5:53 pm
pYak (4/20/2010)
are there any particular cases that you can think of where using the PIVOT operator would be more appropriate?
Not really, no. The PIVOT is shorthand for a very...
April 20, 2010 at 5:37 pm
Carla Wilson-484785 (4/20/2010)
Can you share some examples of other ways to use APPLY. I would definitely like to learn some other techniques. Thanks.
Take a look in the download...
April 20, 2010 at 5:21 pm
Grant Fritchey (4/20/2010)
But, you don't simply have an ID column and apply a cluster and a noncluster to it, right?
That is exactly what I do 😉
Heh. I feel evil...
April 20, 2010 at 5:56 am
COldCoffee (4/20/2010)
April 20, 2010 at 5:54 am
sheeba 88002 (4/20/2010)
send me the codings
You have to be kidding, right?
April 20, 2010 at 5:47 am
April 20, 2010 at 5:46 am
Viewing 15 posts - 3,751 through 3,765 (of 8,416 total)