jgrubb (1/30/2009)

---

Lynn Pettis (1/29/2009)

---

Cardinal Moden himself,...

Sounds like a lot of fun but, consider this, would you like it if your post and name showed up on a "Twit List". Bad enough they show up...

Thanks for the detailed explanation... I'll take a look tonight after I get home.

See the following...

http://www.sqlservercentral.com/articles/Test+Data/61572/

Better question would be, what are you really concatenating and why?

You can shrink temp DB through the GUI without bouncing the server or the service.

My question would be... what's causing it to grow to 50GB? There's definately something like...

krayknot (1/29/2009)

---

PhilPacha (1/28/2009)

---

A former co-worker has asked this question; I admit, I'm a bit intrigued.

Given the name of a stored procedure, is there an “efficient” way to determine...

rog pike (1/29/2009)

---

select emp_id,emp_name,emp_address,rank

from

(select emp_id,emp_name,emp_address,

row_number()over(partition by emp_address order by emp_name) as rank

from ##emp) as A

where rank=1

order by emp_address,emp_name

emp_id emp_name ...

Heh... you tell us... you're the one that can see the table....

Tim Wilson-Brown (1/29/2009)

---

Which is not reliable either - what if the identity values wrap?

There...

The 1.0 is to implicity force the calculation to a FLOAT datatype if everything turns out to be an INTEGER. The rest is a matter of simple substitution and...

I'll trade ya... 😉 Tell me the business reason behind this and I'll give you some code to do it. The reason for the "trade" is, I'm writting...

I recently ran into a similar problem (this morning, in fact). The backups to disk had taken up all the harddrive space because they had a problem getting moved...

Correct... instead, they give it away as a free download. 😉

Jonathan Kehayias (1/28/2009)

---

Does it really matter for the context of the question posed in this thread?

Your aversion to CLR takes every thread in this forum completely off topic...

David McKinney (1/25/2009)

---

As Peter pointed out a few posts ago, a CTE is more akin to a subquery than a temp table, in that it is constructed when it is...