Dugi (4/29/2010)

---

I think we choose the situation, now what any solution scenario for...

krypto69 (4/29/2010)

---

Grant,

I've now been told that I need to not delete any records from table C.

I'm trying to run this:

declare @DaysToRetainSMALLINT

DECLARE @cutoffdate DATE

SET @daystoretain = '200'

SET @cutoffdate = '12/01/2009'

SELECT@CUTOFFDATE =...

ricardo_chicas (4/29/2010)

---

Yes I use sp_updatestats, The query is actually the same I am running ( just with different names)--something weird us that if I add one more number to the...

Dave Ballantyne (4/29/2010)

---

You can always mark you share for my attention,...

Well, based on the information provided, I'd expect to see a seek, so I have to assume that some piece of information is missing. Without seeing any of the actual...

It really depends on how many cpu's you have. Zero sets it to use as many as it has available. Setting it to 1 limits it to a single cpu.

Paul White NZ (4/29/2010)

---

I replied on Ask, but thanks for posting the thread reference there too.

I don't usually post on...

Sqlfrenzy (4/29/2010)

---

Grant Fritchey (4/29/2010)

---

No, waits are not because of inadequate storage. It's because either the network, or the storage system itself, is running slow and causing SQL Server to wait...

It's not parallelism itself that's the issue, it's the cost threshold. The default value of 5 is ridiculously low. I'd suggest starting off with it at 25 and see things...

GilaMonster (4/29/2010)

---

Grant Fritchey (4/29/2010)

---

But... almost forgot this, part of why you use monotonically increasing values as clustered keys so often (or identities defaulted to the primary key) is because inserts...

ricardo_chicas (4/29/2010)

---

Presumably, with an index on the column and the LIKE operator only have a wild card at the end of the string, you have a sargeable (search argument able)...

Paul White NZ (4/29/2010)

---

Grant Fritchey (4/29/2010)

---

Jeff, or anyone else that knows a heck of a lot more about decimals than I do, please go check this question on Ask.SQLServerCentral. I...

krypto69 (4/29/2010)

---

Grant

Im trying to use your statement:

But when I run the below code I get the error:

"Must declare the scalar variable "@CUTOFFDATE".

declare @DaysToRetainSMALLINT

DECLARE @cutoffdate DATE

SET @daystoretain = '1'

SET @cutoffdate =...

But... almost forgot this, part of why you use monotonically increasing values as clustered keys so often (or identities defaulted to the primary key) is because inserts always occur at...

It's down to page splitting as inserts and updates occur, the data may not fit on a given page. At that point the page is split. Half the data remains...