Another area where cascade can be benefical is maintaining/changing large schemas that are deep into their life cycle. I have seen to many times where a critical, worthwhile schema...

In my experience many of these apps need sa to setup there application db, etc. Then the app should create its own normal securables for its daily operation. If...

If you are supporting a B2B (or even B2C) app, many organizations hold user level training for these application. I have attended these sessions and come away with very...

Most of the shops currently the next step is Database Architect. It seem this position is one level removed from the day to day operations of the DB environment. ...

I am still pretty old school in regards to my SQL sevice account accessing file resources.

Now of course every environment is different, but I have seen way to...

This question is not Politically correct. I celebrate Codduka every December, and one of our celebrations is to ignore all checkdb errors. Please think of other holidays this time...

Is License cost the reason not to upgrade exsiting to Enterprirse? I have never done this, but this should be easy to QA and would expect a new named...

Does a Clustered indenitiy really do anything for you? Have you experimented with the Cluster on a real SARG and just having the ident nonclust?

Can you post source?

This may be off topic, but Snapshot isolation is a really big deal.  Hopefully the tempdb involvement needed does not take away from this new feature.

Have you tried using the 2000 version of TEXTCopy against the 2005 code?  May stil work.

Optimizer 1 != Optimizer 2

Can someone talk about transactions a little?  If transaction control resides in the app tier, would this approach increase transactional locking that may be uneeded?  Like the article, thanks.

SQL Server 2004 really flew under the radar . Just kidding, nice article.

I had zero luck in acomplising this as a restore. I have come to the assumption it is not possible. Any bcp/ssis task to export then import could meet your needs,...