Thanks for the input. My searches just didn't lead to any answers.

Scott

Maybe I asked the question wrong. When you implemented mirroring, did you change your existing database backup plan?

Immediately as I read the editorial this morning, I was thinking how computers are great tools, but too many people today rely on them too heavily.

Then blandry pointed...

Indexed views

An index on a view materializes (executes), the view and the result set is permanently stored in a unique clustered index in the same way a table with...

In SQL Server 2000 (not sure about 2005 or...

Jack -

I started to write out the reasons why I had designed all of these reports, then just erased them because I would have had to add the "don't start"...

Hmmm, I think I like the term Business Integrity Audits! I finally have a good description of the reports that I go through each morning to confirm that things...

Yes, it was running on the Exchange Server.

Scott

It was a Trend Micro spam filter running on the server.

Finally, after intermittent problems over two months, I went and stood in the cube of one of our IT staff. It turns out that there was a spam filter...

I am also a big fan of naming conventions. Unfortunately, my group currently has none. 🙁

A personal pet peeve is adding "sp" to the beginning of a stored...

Jerry Hung (10/23/2008)

3. Attach all jobs to a "shared schedule" instead of 1 schedule per job

(so in each job, you Pick a schedule from the buttom "Pick" instead of creating...

That's a good question and I should have noted that the server operates on UTC. So, if I don't do anything, the report that a customer currently gets at...

I have seen firsthand that the way things are built can be changed.

Our development group has undergone such a change. As I see it, 3 things happened to make...

Thanks for the input. We do have Enterprise edition, so that is why we are considering this option. As we design the partitions, we'll try to keep the...