Forum Replies Created
Viewing 15 posts - 3,751 through 3,765 (of 8,416 total)
-
RE: CXPACKET wait_type on every thread in session_id
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...
-
RE: Statistics question: Rolling window graph
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...
-
RE: Why doesn't this work?
Matt Miller (#4) (4/20/2010)
Not necessarily, but it can be rather easy to essentially make your encryption worthless using the built-in components. In most cases, things like TDE get confused... -
RE: Using IDENTITY as a key column
Hugo Kornelis (4/20/2010)
SQL Server will not add this index on its own, so SQL Server has no efficient way to retrieve rows based on a known value for PersonID. We... -
RE: using try/Catch in SLQ SERVER 2008
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...
-
RE: Are the posted questions getting worse?
CirquedeSQLeil (4/20/2010)
Unfortunate score - really.:laugh: Though if I remember correctly, the Number of the Beast is 616, not 666...
-
RE: Are the posted questions getting worse?
CirquedeSQLeil (4/20/2010)
I did note a few things, he still uses sysprocesses (I believe it is for the blocking process count), implements a ton of dynamic sql, uses 4 cursors, and... -
RE: Is Primary key clustered index different from Unique key clustered index??
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,...
-
RE: Is Primary key clustered index different from Unique key clustered index??
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...
-
RE: Pivoting name value pairs
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...
-
RE: Understanding and Using APPLY (Part 1)
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...
-
RE: Columns that contain both clustered and unclustered
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...
-
RE: Pivoting name value pairs
COldCoffee (4/20/2010)
Paul, i initially coded both pivot-join and nested-pivot solution which is exactly similar to yours, but i feared tat 2 pivots and a join willl over-load the cpu and... -
RE: DDL trigger
sheeba 88002 (4/20/2010)
send me the codingsYou have to be kidding, right?
Viewing 15 posts - 3,751 through 3,765 (of 8,416 total)