Get a copy of ApexSQL's log parser (www.ApexSQL.com) and it can look for the deletion in the log backups for you. If you're on Full recovery, the delete will...

I'm...

ItalianOlgi (10/16/2009)

---

GSquared (10/13/2009)

---

I'd...

Take a look at Gail's blog entry on parameter sniffing (http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/). That's a likely cause of the issue.

All of the things you're doing, rebuilding stats, clearing the cache, rebuilding...

So far as I can tell, you'll need to code in the password(s) or use input parameters for them. An XML parameter would work for multiple, or a table...

My main prediction is that people will continue to make predictions.

I think more and more work will revolve around moving money from point A to point B, instead of actually...

talltop-969015 (10/15/2009)

---

If I ever have to defend my job by withholding information/knowledge from a co-worker, or anything similar to that, I'll find another employer, or start my own business or...

Elliott W (10/15/2009)

---

I have an additional suggestion..

Put a computed column in the table that contains the formula and set it to persisted. Then instead of the int column you...

I would suggest using a rowversion column for that. Look up "timestamp" in Books Online, since that explains how to use these. It's a very, very easy way...

Of course, if you want to prove this beyond any doubt, either download the trial version, or buy a copy of Dev Edition (worth having anyway), and run the database...

talltop-969015 (10/15/2009)

---

reclark-579786 (10/15/2009)

---

Have a solid SDLC that are made "public" to the folks who need it the most in their every day life at work. When application developers, management...

There isn't a query throttle on Express. If the queries aren't pushing the limits on the hardware, there's no reason for there to be a speed difference, at least...

On the question of separating or uniting the common data, the question that would settle it for me is: How much work will it save to separate it now, vs...

Yes.

I generally don't have a problem asking for help or being asked for it. Happens all the time. We're a cooperative species that does best when individuals specialize...