I'd think the biggest issue with datetime is the "doh!" that you say everytime a report looks for sales on a date, forgetting there's a time component.

How many of you...

And I'll add that I don't do projects myself to save money. It's good to do so, but about half the time I spent the same amount because I do...

I knew you were a bunch of tinkerers and it's interesting to see how many people enjoy working with wood.

For a few items:

A bush hog is a brand of rotary...

Ben,

I haven't done enough cluster work and don't have a good environment in which to test a proper cluster with AD dependencies, etc. So I didn't expand on it for...

We do that here, but basically use a 2 step process.

We have a set of tables where we can store email info and then recipient info and link them....

How will it affect performance? Not sure.

An int in 4 bytes, so 32 bits are available. You could bitmask, but I think the storage overhead for bits is minimal, they...

The indexing is a logged operation, so you end up with 2x index size (+ pad) when it's working, so I can see if doubling in size if you have...

use Datepart and be sure you know what your datefirst setting is. You can set any day to be the first day of the week.

I think you can also get...

Drop and recreate should use less log space.

Apr 8 I think was the SQL 2K mainstream support end. They'll do security patches, but if you find bugs, you need a support agreement to get support.

Their plan is...

Haven't seen that. Did you create the database before restoring? could the sizing have been wrong?

that message indicates that your network requests are not being responded to by the server. Either it's down, port is blocked (either way) or you are connecting on the wrong...

In that diagram, correct, but if I < J, then it would come before it.

Nope, totally fair question. I assume this is the Monday article this week.

The articles are proofread and often sent back to authors with ideas and suggestions for improvement. We run...

75 ft.

15 ft out the bedroom door, 20 ft across the hall and down 1/2 the stairs. 10 ft to get down around the corner and about 15ft back...