Might start somewhere like this: http://www.cs.bris.ac.uk/maintain/OracleDocs/server.816/a76994/logical.htm

I'd be curious to know how you did that, mostly to tell people not to do that.

Since system table updates are disabled in 2005, I'm not sure what you can...

Tend to agree with GSqaured, don't forget size 🙂

No matter how you want to report it, you want to break out the repeating elements, like color, and drop them in...

I'd use Mark's solution if that's what you need. You don't want to write lots of subqueries as you're scanning the table multiple times and will take a big performance...

I believe that's a 2005 only construct. If you are running 2000, you posted in the wrong place. Let us know and we'll help.

In 2000, there's no good way to...

Or better yet, Camtasia your screen when you're analyzing something, record the actions, and then play them back in a loop 🙂

How did you move the databases over? Was this a wizard or backup/restore?

The logins don't move, so you have to move them. The easiest way to do this is search...

Look at your dateimport. They include times, so you are likely getting a "count" for each group of the time, not the date.

If you need it by date, then extract...

Once you get SSMS, you need to "Connect" to your instance since you're working in client server mode now. SSMS won't "Open" the database.

Go to Databases, expand that, then expand...

1...2...3...4... enough recounting.

I'll add points back to the True's later :). The system doesn't allow "either or" answers. If I ticked both, both would be required.

Happy April Fool's!

Ian,

Thanks and it's tough writing every day, but it's also fun for me.

Once in awhile!?!?! Hopefully more often than that, or what that just the editorials? 😉

The Prius fits our family of 5 (6 ft, 6ft, 5' 10, 4' 6, and 4') fine. If we have all 5 of us in the car and a load...

There is actually an air car in the NY Auto Show slide show if you check it out as well. It's a neat idea, though anything highly compressed contains energy...

I don't think anyone's tried this or knows, but I'll ask a few people.

From my understanding, you can't run two clusters as you're trying. If you have two machines, you'd...

Nice example, Jeremy and it doesn't work because of an implicit conversion of the answer to int, the data types of the inputs.