Monthly Archives: October 2010

What is Advanced Mode on BIDS Report Designer and how do I get there?

Getting column headers to repeat on Tablix reports in SSRS 2008 is not really obvious.  There are many blog posts about this and they all refer to Advanced Mode.  Where the heck is it?  Is it under Tools, Projects… no … Continue reading

Posted in SQL Server Reporting Services | Tagged , , , | Leave a comment

How fast can my database read from disk?

The SAN world is one measured in IOPs.  That is not a database friendly measurement.   Even using local or direct attached storage it is difficult to determine maximum throughput.  Activity Monitor allows you to see activity in MB/sec.    So how … Continue reading

Posted in Database Administration | Tagged , , | Leave a comment

Case of the missing disk space

Have you ever had Windows report free space lower than you expect on a server?   From the disk in question open a command prompt and run dir/ah.  One of the folders may be $Recycle.Bin.  Check that directory for deleted files.  … Continue reading

Posted in Database Administration | Tagged , , , | Leave a comment

MSDB Recovery Model

It is always good to remember than whenever you run setup.exe the recovery model of msdb will get set to simple.

Posted in Uncategorized | Leave a comment

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!

Posted in Uncategorized | 1 Comment