Ya'll are making the assumption that the problem is ReportServerTempDB. It's entirely possible that 400 GB is the correct size for it and there are databases that are not...

Making sure all of the databases on the drive have log backups is certainly something the op should check if there is unexpected growth. But...

Never having dealt with quite that much data I can't say for sure but I would lean towards multiple tables. Either way I would also look into partitioning for...

Just remember that Instant File Initialization is not an excuse to not grow the files yourself. There are other very good reasons to keep an eye on your free...

The problem with shrinking any tempdb file is that it probably is the size it is for a reason. There is a good chance once you have shrunk it...

Guras (8/17/2012)

---

One of our databases is 12 GB and currently about 800 MB free space left. The database gows about 300MB in a month. I have a few...

Yes. They are between 8pm and midnight every night. Unfortunately we use a 3rd party scheduling tool and have several thousand jobs over all. There is no...

SQL_path (8/8/2012)

---

Thank you a bunch !! 🙂 🙂

I see exams 70-448, 70-452, 70-467 , 70-460.

I work on 2008 what would be better ?

these are the videos you talked about...

Try going here:

http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

It is a post by Paul Randal about wait stats. It also includes a query you can run on your server to see where the worst of...

SQL_path (8/7/2012)

---

Hi,

I need help on deciding the track for certification in BI. I did search MS website , however it left me a little confused. Looking for latest information...

guerillaunit (8/7/2012)

---

Is there anyway to have HAVING and WHERE clauses work in conjecture with each other?

ie psuedocode:

CASE

HAVING count(children) > 3 THEN WHERE nationality = 'Mexican'

...

You might consider looking into partitioning. Partition your table so that the rows you want to get rid of are in their own partition then use SWITCH to put...

Honestly I would guess that LEN works the way it does because the vast majority of the time you don't want to have to worry about the trailing spaces. ...

Actually I got the idea from a rather odd instance I have on a cluster. You can reference it as InstanceA/InstanceA, InstanceA, or ClusterName/InstanceA. And on the same...

Specifically the plan is to try to find an easy way to move a bunch of instances to a single location.

So for example we have default instances on ServersA-D.

We can...