SSMS doesn't do this directly, but you can query sys.locks for information. You might start, however, by examining the execution plan and seeing if you have issues with your code.

Why...

http://www.solidq.com/sqj/Pages/Relational/Identifying-and-Solving-Sort-Warnings-Problems-in-SQL-Server.aspx

http://amihalj.wordpress.com/2011/12/07/sql-server-2012-detecting-sort-warnings-with-extended-events-sort_warning-event-part-2/

You have to provide more information. What are the data types of the source fields and DDL?

It might be as simple as concatenating the fields and converting to date time.

It's also entirely possible with your workload that you need the space. There is not set size for tempdb. You need what you need for your workload.

If it grows consistently...

glad it's working for you. Usually if you install with defaults, the firewall isn't too much of an issue, but it can be frustrating to get it working.

I'd also note your logic is always going to be split this way. Since someone has access with no rows, you have to account for that separately in your logic...

patrickmcginnis59 10839 (8/1/2013)

---

paul.knibbs (8/1/2013)

---

That's all true, but I come from a programming background, and I know that you will pretty much never, ever anticipate every daft or incorrect input a...

Interesting. Never heard...

Hugo Kornelis (8/1/2013)

---

I understand what you're saying, Steve. But there is also another side to the equation.

First, on using the script button in SSMS.

Using this button to generate code can...

jasona.work (8/1/2013)

---

Steve Jones - SSC Editor (7/31/2013)

---

As of now, most of the last year has been spent on Simple Talk, which had a very creaky, and cumbersome platform. This one,...

PhilipC (7/31/2013)

---

Yeah that's a fair enough point. Most of time, it seems to be rapid development over quality development that wins out. As a DBA, it just becomes a nightmare...

Jeff Moden (7/31/2013)

---

Heh... I guess there's no use in responding to anymore...

Jeff Moden (7/31/2013)

---

Ah......

I'd reboot the machine. I've seen issues with the DB2 driver in the past leaking memory or having some issue through a linked server that a reboot solved.

Not great advice,...

Alvin Ramard (7/31/2013)

---

Revenant (7/31/2013)

---

Steve Jones - SSC Editor (7/31/2013)

---

. . .

So I get this is probably in jest and partially true, but it's insulting. It's not selling out any more...