Toreador (11/30/2011)

---

I've used it for generic audit tables, where we store something like table name, column...

Hugo Kornelis (11/30/2011)

---

Gerardo Galvan Castro (11/30/2011)

---

In the e-mail newsletter the QotD did not state it was for SQL Server 2008 and later, so I tested under SQL Server 2005 (the...

Thanks for the question.

Congrats

Microsoft already has all of that information for you to see through the system catalogs. Check the views that Craig mentioned.

If you are looking for a simple combine of the two (and if perf is not an issue - though I would look into changing this to a set-based routine...

I can't see a good reason for one to be affected and not the other.

I am of the same opinion as Gus. Simplify this query. I am not seeing a reason from the code provided to have it be dynamic. If...

The Rock

Here are a few that I like to use

http://jasonbrimhall.info/2011/11/17/table-space-revised-again/

http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/

3rd degree

Even with the 3rd party tool, it would be more likely to be able to recover if you are in Full recovery. Check that setting first.

Do you have tran log backups?

Is the server in Full or Simple recovery model?

Thanks for the question.

You can only use one datasource at a time.

If both sources are required at the same for the chart, consider porting the data from one into the other and then...