Good policy, and I tend to do that as well. Seems naive at times, but I'd like to think most people are worthy of trust.

Question?

I wouldn't mess with it unless you have real performance issues or are directed to by PSS. If you have some network issues, or you have set different sizes in...

Most of these can be found with some research, but as the first responder mentioned, you should know these if you are qualified to get the job. Or if you...

Based on software you build?

Is IT including developers? developer machines, etc? I think you need to spend what you need to spend to get the job done. If this is...

Once SQL Server has grabbed the memory, which it will do for caching, it tends to hold onto it unless it's needed by other applications. And then it grudgingly lets...

Watching the video today. I've seen a bunch of the early architectures in other presentations/articles, but this one is more interactive and interesting.

One big thing to note is that architecture...

I think this thread will never die.

Massages..... sheesh 😀

What's the URL you're linking to internally? Or is this external?

If it reports a FK violation, that's what you have. It's not Java, SPs, or anything else. You must be missing something in what you're checking. If it fails, what...

SQL Server = Oracle = DB2

Maybe not ==, but each has things the other doesn't and for 99% of us out there, any of them will do. It's a little...

I've almost always used domain accounts. Set one up, no rights outside Everyone, which has no rights, and then let SQL Setup (or Config manager) assign rights.

Easier to do that...

MySpace has been a great SQL Server story, but more importantly, they show where SQL Server has been weak and how they've had to re-architect things a few times to...

Lowell, great tip on the calculated columns and I would expect these to perform much better than triggers.

David, let us know if you find something. Or write an article...

It's definitely a trivia question and I wouldn't recommend coding like this as all, unless you're in some type of contest for obfuscating code.

I also wouldn't let someone use this...

There are quite a few entries in the Control Panel as well, so you want to be sure you remove them all if SETUP doesn't work.