Okay, I have more copies of "Pirates of the Blue Kingdoms" in my hot little mitts. (Just in case you were waiting for this to place an order).

If you want...

Lynn,

I actually do have a good idea of what the dimensions and facts are looking like (and have gotten those questions answered). This is actually one of the dimension...

I just downloaded a trial version of this and it won't open any of my current Erwin diagrams. Bleargh. It seems nothing I can find will allow me...

At this point, I would call Microsoft and see if they can clear up the problem for you.

I am literally loading three types of values. Money (for financial buckets), bit fields (for determining if someone is a reseller or a direct seller and for determining if...

Ahhh... Interesting that the following statement will work perfectly:

INSERT INTO TESTVARIANT (ITEM) (Select Convert(money,(15)))

And SUM() still will not work with the datatype. I thought it would. In fact,...

I've actually already started adding semi-colons because there are times where it seems to help my code perform better (I guess because SQL doesn't have to decide if one of...

Wow. These are all very interesting suggestions. I'm glad I posted this topic. @=)

I've had difficulty figuring out how to use CTEs with my normal code needs and...

Not having used sql_variant before...

I was under the impression that sql_variant stores different datatypes in the same column. That you can determine which datatype to use for a specific...

There are ways around case insensitivity, but they aren't easy. There are usually cursors involved with Substrings or PatIndex/CharIndex used in the code.

We were forced to do a case...

Oh, yes. I have the same issue. I have developers who learned T-SQL from SS 6.5 or 7.0 and still refuse to update a lot of their practices,...

The point of my test was because someone at Microsoft (according to the OP) said that what many people have assumed for years about true about the pitfalls of Select...

You need to learn DOS commands. XCopy is probably your best bet.

Also, you'll need to make sure that:

A) Xp_Cmdshell is enabled on your SQL Server (check the SQL...

The quickest way (and as previously mentioned, you'll want to test this) is to script out all the objects in your database as Drop & Creates. Now you could...

Good point, Tim. I just found out about that yesterday. I'm about to spend a lot of time on Channel9. @=)