In terms of performance I doubt there is a difference. I think the advantages to parameters is that you stay object oriented - which while that might sound ivory towerish,...

I've tried a couple options - one was to write them locally and then have the app check for any stored errors the next time it started up and resubmit...

The status idea is useful for times when you (the dba) want to force an app offline. You may need to a repair or quick schema change and need everyone out....

Use caution about storing state in unencrypted files of any format. One problem is that you may be leaving identity or other valuable information just sitting on disk (think of...

Biggest reason is time - detach, move, attach is fairly quick.

You should be able to remove start date from the two non clustered indexes, it's implied since the clustered key is part of the non clustered index.

Im a little late reading this, but have a couple comments to add.

My first thought was to agree with Ian, that I think this would be better done in the...

CG search over, still nothing. Others still looking, and pondering other theories.

http://www.mercurynews.com/mld/mercurynews/news/16601612.htm

Its an older article, Steve sometimes will rerun one that he thinks is interesting on Friday.

Not sure why backup/restore would be faster - with attach you just copy the file to whatever server and attach.

This would be such a great discussion to have in person;-)

I think locking should be considered on a statement by statement (or least proc) basis with a good understanding of...

I think I'd just go with a simple table - row# or name, col# or name, value. So for a 3x3 matrix, you might have these

1, 1, "A"

1,...

The cost of SAN's has gone down, but it's still a lot more expensive than just a SCSI RAID container. I like the performance a SAN offers, but its offset...

I agree that making readers aware that a topic has a lot of discussion would be interesting, and emailed Steve already suggesting that maybe if a new article sparks a...

Simon, I don't entirely agree with your statement about only writing about things you know about. This isn't a referred journal and what I've always though made the community model...