DROP DATABASE <database name>

Then do a once-off shrink, leave enough free space in the database for normal operation, and rebuild all your indexes.

Why do you want to remove the free space?

Please assist what...

mpdillon (2/26/2013)

---

I am still a bit lost so let me paraphrase. A CTE never writes data to the TempDb. But in this instance since the TempDb grows from 8MB to...

Don't truncate your log (not that you can in SQL 2008).

Please read through this - Managing Transaction Logs[/url]

Please read through this - Managing Transaction Logs[/url] and - http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Don't just shrink or change recovery models without analysing and knowing the effects of the actions.

Errr... the entire first section of that article explains why partitioning does not get...

ScottPletcher (2/25/2013)

---

GilaMonster (2/25/2013)

---

ScottPletcher (2/25/2013)

---

Never??? What if enough memory does not exist to store the results? Surely the results would spill to disk then,...

ScottPletcher (2/25/2013)

---

Never??? What if enough memory does not exist to store the results? Surely the results would spill to disk then, presumably to...

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

That should work too, might have to aggregate, I...

A scan...

This kind of thing is incredibly difficult to do.

Probably best thing you can do is set up an extended events session for Object accessed (I think it's in the 2008...

mpdillon (2/25/2013)

---

I completely agree with you. Whatever is being created in the TempDb is not being reused between when the query runs the second, third, fourth, etc times. I do...