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.

As David mentioned, SQL Server gets its time from the system. If you don't have your systems syncing time with some source, it is easy for this to happen. Also,...

It seems that everyone is talking about a similar thing here. Let's try to remain professional and respectful as we debate things. I had a few complaints that this was...

Wow, quiet a debate going on!

Brad, thanks for the break and a nice job on the editorial.

We all need to get "reset" at times, to have ourselves grounded back in...

Whenever you have a sourcing contract, you need to be sure you have this spelled out with the provider. If it's a small provider, you should also think about escrowing...