Why do you think you are experiencing memory pressure?

How many plans are being used only once, and for how much ram?

kishoremania (8/6/2011)

---

Thanks Ninja ,

you opened my eyes, I mean after your calculations I don't want put that much of time in my life to SQL server to become an MVP....

Was it you Gail that said you don't even make 1$ / hour on your articles (this site pays 25$ / article)?

P.S. 1 article = maybe 10 posts if you...

Jeff, how does that remove multiple non consecutive "wrong" characters?

Jeff Moden (8/5/2011)

---

I suffer from massive amounts of CRS and appreciate it when every forum question has an answer to I can look it up instead of having to remember...

Added a comment. hopefully he'll understand where...

Might I point out that using the right nickname is a good start with the basics.

kraig Craig :Whistling:

Craig Farrell (8/5/2011)

---

Threw a hat into...

GilaMonster (8/5/2011)

---

Oh, to give you a rough idea, this is what my activity the last 12 months looks like.

25 blog posts, thousands of views per month

3 published articles

Tech-Editor on a...

I'd compared the concatenated version (wahtever string gets sent for the connection) to this : http://connectionstrings.com/

It's usually a small typo or using the wrong driver. Really hard to debug...

Ya but you still have to revalidate ALL the data in the table so that the constrain STAY trusted. If not they lose their hability to short-circuit some sql...

Just a final report. It took roughly 1 hour for the reorg to run. Fragmentation is now under 0.4%.

Like Gail said, not gone, but pretty darn close.

L8rs.

GilaMonster (8/5/2011)

---

Ninja's_RGR'us (8/5/2011)

---

Absolutely agree on the rebuild part... except when you're out of room :-).

Bulk-logged recovery model (unless there really are 0 dataloss requirements, no exceptions, which the OP has...

GilaMonster (8/5/2011)

---

Reorg however is not indicated for high levels of fragmentation. Rebuild...

Forgot the else...

IF EXISTS(...)

BEGIN

PRINT 'do something conditionally'

ELSE

PRINT 'do something else conditionally'

END

PRINT'always do this.'