erh

I believe they (the network admins) would have to move your profile (roaming profile) to the new domain, then your entire desktop should be the same as it was before you...

Look in Books Online under "Moving System Databases"

I think what it is telling you is that you have to set them for the query explicitly (over rides server settings).

Hey Jeff, for you:

http://worsethanfailure.com/Articles/OMGWTF-Finalist-08-Universal-Calculator.aspx

Most entertaining thread on this site in years!

(Now someone know Giordy's real name so I can make sure I never take a job where I will have to interact with...

What's the use of the data?  Is this storing simply whenever a user opens a screen that pull back data for example? 

I would set up some sort of archiving, or...

Check out "User-defined Function Design Guidelines" in Books Online.  Most imoprtantly they will be non-deterministic if they use call other functions that are non-deterministic or extended stored procedures.

"Deterministic functions...

So do I, but using pivot it seems almost necessary to do it.  I don't know about the rest of you, but rarely do I know excatly what the data...

In a month I have pretty much restored all our databases from production to dev and test.  Those are all my disk backups of course.

I do however randomly ask for...

May I be as bold as asking why you are trying to do this?  Just to prove that you should not trust the estimated query plan when you are working...

You can even restore databases between the two.

I'm starting to slowly look into it.  I'm about as convinced as I am about allowing CLR.... I.e. until there is a specific need for it, I am not allowing it on...

Actually you can do dynamic names for columns with pivot function, just have to use dynamic SQL (and it becomes a rather "fun" query to read).   See below for an...

I think the documentation is wrong on this point!  At least I have not found a way to do this without aggregation of some sort.

Try to create a clustered index that spreds the inserts around.  (might have been what you did when you changed your PK, but make sure).