Another alternative would be table partitioning by date, whether a partition is one day, 7 days, etc. This determining factors would probably be insert volume(s) and table availability. The down...

... and I thought I was a mushroom in the winter (lack of sunlight) ...

Valparaiso, IN (US): 41n28, 87w04

About a 10 minute drive from the southern edge of Lake Michigan.

I was able to get in with no problems - we are using WebSense as an enterprise internet tracking and blocking.

What latitude and time zone are you at ?

Where was the interview at ??? Maybe they need some consulting services ...

There has to be something amiss. I just performed a test on one of my clusters and using a SQL authenticated user ID and a Windows Domain user account and...

Time sensitivity is really important in a number of areas. It is of tantamount importance in the healthcare industry, even more important than in the financial realm. In finance people and...

You say yjr SQL Server service is LocalSystem, how about the SQL Agent Service ?

NULL values are eliminated from agregate function results.

I prefer separation. The company has my equipment and I have mine <period>

I too have worn all 3 hats (now I'm down to 2)

 It is you, the DBA; you are the 'steward' of your organization's data. It is your role and more importantly, responsibility, to...

The comments, the code difference, the changes ... hmmm ... sounds like large project 'rookie' snafus that fell through the cracks due to lack of diligence and planning of QA.

I...

Here's a great tool It reads the event logs and creates files. It uses an very SQL-like selection criteria so you can be...

Quite simply, the primary job of the federal government is to take something simple and complicate it !

Q. What do you call 500 lawyers at the bottom of the sea ?

A. A good start !

Steve, even with  dual data center battery backup UPSs, dual separate power grid feeds, dual internet 'fat' pipes going to different level 1 providers and dual generators we still have had issues....