Caruncles (3/3/2011)

---

SSCrazy, I like the head-banging avatar. I need one of those and an automatic butt-kicking machine.

I saw this post and have been banging my head trying to set...

Good article.

Would really like to know how to incorporate SQL 2000 and SQL 2005 into the Management Data Warehouse. Think MS slipped up not allowing that.

Sure you can't capture...

TheSQLGuru (10/4/2010)

---

2) I have a client with pushing 40TB on virtualized SQL Servers. And yes, I did mean TERA there and not GIGA. It can be done, but...

Vera-428803 (10/3/2010)

---

We are running SQL Servers 2000 - 2005 - 2008 in a VMWare environment.

When we started with it, we thought it was a good idea to have a...

Database Developers and those developing on databases, should know enough to code efficiently without having it "...always fall to the DBA."

If you're in the position of being the sole database...

wbrianwhite (7/31/2010)

---

http://blogs.msdn.com/b/sqlazure/archive/2010/07/27/10043069.aspx

Just a note, non-clustered indexes (what you make when you do a covered index) reduce the performance of your writes. This is because on insertion or updates, the indexes...

Nadrek (7/30/2010)

---

...

When writing new SQL, why not take a little more time and do it well, instead of randomly? For existing bad SQL, most often I see that a...

@wbrianwhite & @Nadrek

The cost of adding and updating the indexes is actually a lot smaller than it's made out to be. Only under extreme change (meaning insert/update/delete) activity will you...

You could always use good old Windows Task Scheduler with OSQL/SQLCMD.

Best option would be to upgrade to SQL 2008 R2 and take advantage of the backup compression. Failing that, grab hold of a third-party compression tool. There are quite a...

Are you using any third-party backup utility?

We're using the freeware version of Idera SQLSafe on one of our servers. This causes backups for multiple databases to be performed synchronously. When...

Nadrek (7/29/2010)

---

I didn't see a very important one:

Pull up SQL Server Profiler, and watch the SQL:BatchCompleted and/or RPC:Completed numbers for CPU, Reads, Writes, and Duration. Know which is most...

Stan Kulp-439977 (7/14/2010)

---

Sorry, but the answer is you can't get the time stamp of a processed data file from an event handler.

I was just trying to show you why I...

Sorry, but I'm not going to provide the...

One thing I can think of at the moment is to check that you have Package Logging enabled in the Child Package as well as the Parent Package.

Don't have a...