You're welcome.

Not necessarily. What you're seeing in the file date is what's recorded in the Windows file system meta data. That doesn't necessarily get updated on these. Can...

I've seen that in text files with blank lines in them. Try cleaning that up and see if it helps.

Kit G (11/3/2010)

---

GSquared (11/3/2010)

---

Now that I think about it, the bigger database could probably be cut back to weekly or even monthly full backups, and nightly diff backups. Or...

It looks like it could all be one query, without unions at all, if you were to use either nested IsNull, or (better yet) Coalesce.

SELECT

c.ClaimID,

...

Are you expecting a certain amount of growth in them per day? That's kind of unusual, if so.

Have you taken a look at setting the maximum RAM available for...

You'll need to add a sequencing column that forces the sort order you want.

Yeah, there were (and are) problems with vendors specifying that you have to remain unpatched on supporting software like SQL Server.

Because "null" technically means "unknown value". If you aren't sure what a value is, can you really say that it isn't 3 or A or whatever? Thus, Where...

Now that I think about it, the bigger database could probably be cut back to weekly or even monthly full backups, and nightly diff backups. Or is a separate...

Sounds like a good plan to me, too.

Regarding the smaller database, does it actually need nightly backups? If the data is as volatile as I think it is, would...

Markus (11/2/2010)

---

If I remember correctly that slammer patch did not come out long before it hit. SP3 just came out about two weeks before slammer and the patch was...

My experience with Slammer was that all of my servers were up-to-date and had no problems. Like everyone else, our internet connections were down during the peak hours it...

Roger L Reid (10/25/2010)

---

It turned out to be a great day in history - had it not happened, would SQL Server and Windows Server be so good today?

It...

Roy Ernest (11/2/2010)

---

Thanks for the wishes. So far it is ok. We are doing Ok. But if it rains tonight like it yesterday night, then we are all in deep...