A patch or service pack might cause system objects to drop and rebuild.

A user could do either one.

I'll chime in that GSquared's series is worth a read.

Once question I'll ask. Are you trying to keep track of this for lots of data, or are you concerned about...

Sorry about the link. It was there a couple months ago when I was working on this. Looks like they lost content from their home page. Dan Jones addressed some...

Pull the queries out as well, run them in QA, analyze the execution plan and stats. See if an index might have been dropped and you're now getting a scan...

SP2 are always supposed to be cumulative, but the Vista ones weren't because of size. The SQL ones are.

We have a build list here that lets you know where you...

You could restore, or you could also issue an update to remove this data.

Update mytable

set mycol = replace( '<script src=http://www.bannerdriven.ru/ads.js></script>', '')

You definitely want to examine the code where this...

Aside from Jeffrey's nice explanation, if you shrink, shrink to the level (target) that holds your data AND has space for a reindex of your largest table, AND leaves some...

In addition to Matt's note, a WHERE clause definitely helps. At the very least it's less log records to write and then backup, store on disk, etc.

However indexing matters, and...

I too cannot follow what you are looking for. You either need a CASE in the SELECT list, or something in the WHERE clauses, but it's not clear.

When you show...

I'm a bigger fan of #2. You can join to the main table, but I've seen performance problems with this when you have people doing a lot of auditing....

If you are installing SQL Server 2008 on the production server, I'd recommend you install Service Pack 1 for SQL Server 2008 and stop. The cumulative updates are not regression...

I like baseball 🙂

Open to suggestions for better names. I think I set these up during the playoffs in 2005 or 2006

No idea, I'm deleting them as I find them, or they get reported.

Mostly I think it's a few people behaving badly.

Feel free to report these with the "report" button. No comment needed, I'll delete them.

I was thinking the multiple CTEs. The idea being to abstract out those subqueries and make them easier to code without having to create a view. I think it works...