delete without a where clause.

Done it too many times to count.

Tend to agree with Gail, good indexes mean that 10mm rows shouldn't matter.

These are separate functions. Monitor could be a lot of stuff, and lots of tools. SQL Response (I work for REd GAte), Server's Alive, What's Up, multiple packages here. Depends...

Walked into a startup and they'd been making backups before all deployments to their mission critical database for their product. They were having a crisis and couldn't restore the db.

Watching...

Luke has great advice. This isn't a Reporting Services issue, it's a permissions issue in the database that holds this data.

You could potentially use a second fact table, but is that easier to query? I mean you'll have multiple rows of the same data there.

I think having Paul's advice works,...

You could use Red Gate's Data Compare as well, but what you're talking about is a custom job. There's no easy way for a tool to make the decisions about...

Don't use network shares. You're just asking for trouble. Get a proper SAN or local storage.

Are you looking for a deliberate flush, like a DBCC comment? The default trace might help.

Thought you might like some statistics. Someone asked me, so....

In terms of total points (as of about 15 minutes ago), on the overall list

#100 - 2,303 points

#50 - 2,884 points

#500...

I have awarded back all points and edited the question to include the answer for future people.

Not a great question, and my apologies.

I'd agree we need to do more here, but

more from workers != more hours

It's a question of being more efficient and being more strategic.

Traces can work, but I'd agree with Gus. Third party tool. Log to a folder that the tool and the DBAs can not read from. Only write to.

Tim Parker (10/15/2010)

---

I believe the industry as a whole may place too much emphasis on the years of experience, versus the actual aptitude of the individual they are interviewing. ...

I'm not sure what you can do here, except perhaps limiting the deletes to smaller batches and then use less RAM.

You could use separate instances, but then you'll be balancing...