Joseph,

Were your dbs created with files that size or have they grown? If you want smaller data files, meaning file groups, you can easily create those and then move the...

First, is this Enterprise edition?

Second, each app gets 4GB of virtual memory, which is mapped and swapped out to physical memory. I'm not sure what the Delta stat is, but...

Lynn has a great question, but you don't necessarily need the log for a restore. The data file backup is what you need for the restore. The log, if you're...

Oh come on Lynn, we could get a 1000 post thread going

Actually it's kind of become fun to watch them go.

It's coming. We should go into limited Beta next week and a enw site in 2-3 weeks, which will have tags and other sorting options, including voting and comments on...

David,

As long as that doesn't happen every hour, that would be cool.

Not sure David Reed of Microsoft Consulting, one of the new SQL Rangers. http://blogs.msdn.com/reedme/

Good to hear most of you are working around 40. It's definitely worth the balance to not work 50-60 hours a week. Even for less money.

I still think most people...

The US is usually a right to work environment, but there are still lots of employee protections against random firing, and especially firing for health reasons. Typically a medical leave...

Not sure, I think so.

I think the GOOF button hooked up to a foghorn placed near the query writer's desk would be sufficient

I've done the variant thing and it was problematic for queries at times. The implicit casting in your queries sometimes causes issues when to tries to bang dates into ints.

I'd...

The setting can be altered by clients. Since it doesn't specify a client, which could be some ADO.NET app you wrote, the server default should apply.

OK, lots of responses and I can see what people are thinking. First, a little defensive answer. Writing questions is hard. Coming up with the "wrong answers" is usually the...

, yeah this is a good place to post.

It's fixed. This was a break in our security when we moved from W2K to W2k3....