Is it only me that is struggling to understand how we get 3 columns from a 1 column table..?

Jeff Moden (7/21/2011)

---

RichB (7/21/2011)

---

Presumably that also has the effect of turning the temporary table into a global temporary table that magically disappears as soon as the original session clears it...

Presumably that also has the effect of turning the temporary table into a global temporary table that magically disappears as soon as the original session clears it out? :hehe:

Bet that...

Just as a matter of curiosity, is there any reason why you didn't simply attach all the user databases? Had their original files disappeared?

The...

I run fusionIO SSDs - pcie cards. Stripe them together, mirror the databases.

Absolutely amazing performance.

Thats : http://www.sommarskog.se/query-plan-mysteries.html

if you missed it!

On the front page of sql central is a link to erland sommerskogs page.

Suggest you have a read of it, it may help.

That rather depends on whether he thought it was one of the typically arsey trick questions...

Perhaps a rule of thumb is to only use 1 question mark per question?

Ah, not the missing option of 'wtf are you using sql logins in production for anyway?'

What with them being inherently, disgracefully insecure.

For anyone that hasn't I strongly recommend using your...

am I being stupid - or can I genuinely not rate the article?

How fat are the tables?

Sure, what's the rate?

As this place is sponsored by redgate, why not have a look at their tools - sqlpackager (if its still called that!) probably would do what you want!

you could pop it into a different structure and use some bit operators on it, just to upset the folk on here!

eg:

create table sources

(sourceval int, name varchar(20))

go

create table folk

(personid int,...