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...

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...

Bill Galashan (7/12/2010)

---

Anything wrong with the event handlers already available within SSIS. It is very simple to set up an SSIS template with the event handlers coded to generate logging,...

Yeh, was planning to post it, but was rushed with the earlier posting 😀

Just replace

"<< YOUR SERVER >>" with server name

"<< INSTANCE >>" with instance name, or DEFAULT...

I have a script that runs in a Powershell script step of a SQL Agent job to do this.

Makes deployment pretty easy as it's just T-SQL to create the SQL...