GilaMonster (11/26/2009)

---

Andrew Gothard-467944 (11/26/2009)

---

What it does is clear down your procedure cache - if you run against live you're going to see your box hammered until your most commonly used...

How about putting Profiler on the target server to see if you can pin down more precisely where it's breaking?

Aw. Sorry if I sent you off on a wild goose chase mate.

Use for performance testing on dev servers, checkpoint the db before running. Don't run against live.

What it does is clear down your procedure cache - if you...

Might it be because you have - on both databases - an autogenerated UNIQUEIDENTIFIER column, so the log shipping is attempting to update a column with a specific value (from...

http://www.vogon-international.com/

Not cheap - but if the data is valuable (and why would you have it otherwise)

I have a feeling that this may well be more a Business Process/Functional Analysis issue - rather than something to be addressed from the DB side.

Don't know about anyone else,...

Paul White (11/10/2009)

---

Just for anyone who's really into this: http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx

One might even persist the first few characters of the unencrypted value and index that. It all depends on the...

Paul White (11/11/2009)

---

CREATE VIEW dbo.CrystalBalls

WITH SCHEMABINDING

AS SELECT Egg FROM

(

VALUES

('Egg'), ('Egg'), ('Egg'), ('Egg'),

...

ORM - Obscene Relation Mangling?

Rather than denormalise (assuming the db is correctly normalised in the first place) and potentially throwing the baby out with the bathwater, if you have complex reporting needs you would...

In addition to the advice from Eliott W and robert.mcleod, I would also recommend that you have a QA version of the database that mirrors live. First test all...

If stopped, dbcc reindex will rollback - ie it will use the t logs to undo all the work carried out to that point, meaning your index will still be...

For the delete, I'd put the process in a loop deleting, say, 4500 rows at a time until your target removal records are all gone.

The reason for this...

Ah, good old ttdssls045123.t_dqua etc, etc.

How I don't miss the...