Kim Vermeij (7/20/2009)

---

Hey David,

Nice article, I think you'll find the advantage with EXCEPT when you have to compare multiple columns with possible null values on both sides. When you compare...

I thought I'd replied to this, apparently I had not. It's been crazy around here.

In short, Eddie et al were absolutely correct. I called Microsoft, and it is...

That's kind of a complicated situation. The server, running as the server user, has to be able to write to a directory on your PC, so that folder has...

There we go! I was wondering what happened to the forum for this one!

Not a piece of advice, per se, more of a vendor problem. When I started...

Thank you for the solution, maleitzel. I just started migrating to 2005 and hit this problem this morning with one of my developers. I didn't notice it as...

Good luck, Ravinder. I don't know how large your shop is, but if you have a separate team for server administration, also talk to them and make sure that...

Eddie Wuerch (7/1/2009)

---

Also note that if you are using Enterprise Edition in a non-virtual instance, you must license the number of CPUs in the server available to the operating system,...

You might take a look at the NSA. They have guides for lots of software, they have one for SQL Server 2005, but not yet for 2008. I...

I'm debating whether I should just pick up your book, Brian. Probably be a good idea. Are you doing an update for SS2008?

My problem is that I'm doing...

GilaMonster (6/18/2009)

---

...

What I've found, by trial and error, works well for me is to not use speaker notes at all, to not memorise what I'm going to say and to...

One thing that definitely should be mentioned about Toastmasters: it's an excellent social networking opportunity,...

Grant Fritchey (6/18/2009)

---

Wayne West (6/18/2009)

---

One of the greatest things in Toastmasters are the "Uh" bells. One or two people are given 'ding' bells, the little silver dome-shaped bells stereotypically...

If you're going to speak in public, take a course or two in public speaking. Or join Toastmasters, and if you complete their program, you'll be pretty good at...

Weird design normalization (breaking comments into 70-character fields that you then have to reassemble), hideously profligate use of cursors, the same field has a different name in different tables, treating...

mps_42 (2/8/2008)

---

$sanjayattray (2/8/2008)

---

Yes and no. DBCC DBREINDEX does update statistics when executed, but it executes sp_updatestats and updates a sample of statistics on table/index.

But to get the best result...