Again - this is just one persons personal observations, but it is a person whose opinion I respect (a lot) 🙂

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

Steve Jones - Editor (3/8/2010)

---

Jeffrey,

Do you have a 64 bit reference? I haven't seen this.

Even on 32-bit machines, with 2GB of RAM, I haven't seen SQL Server starve the OS....

I am not familiar with Veritas clustering, but it sounds like this is an issue with how that is working. On Microsoft clusters, you would reference the VIP instead...

Looks like you have a process that is running at the same time as this step in your maintenance plan that is dropping that table.

When the maintenance plan starts, it...

You really don't...

Steve Jones - Editor (3/8/2010)

---

It look like you have no limits on SQL Server memory, which is OK if this is a dedicated SQL Server machine.

you might want to read...

The two previous posts answered the question - if you need additional help, let us know.

If the default trace was running when the object was deleted, you can look in the trace file and find when and who dropped the database.

simflex-897410 (3/5/2010)

---

WOW, I just love it when I see elaborate explanations such as yours.

Thanks a lot Jeff.

Your queries beg one question.

So, the only reason you used this -> getdate()) +...

simflex-897410 (3/5/2010)

---

Thanks a lot Jeff,

All I am trying clear up (for my current and fututre benefit) is that in a situation such as mine, where a fieldname is of DateTime...

simflex-897410 (3/5/2010)

---

Many thanks again Lutz but one more question.

Are you saying that just being of dateTime datatype, that last code you wrote would work even though, there is no...

There is this tool: http://sqlh2.codeplex.com/

On SQL Server 2008 - you can also implement and use the data collector to monitor multiple systems.

There are other free tools available at the above...

tluker (3/5/2010)

---

Thanks for the information. We'll probably end up doing the active / passive approach since there wasn't really a hard demand for us to provide the seamless failover....

Unfortunately, unless your column is defined as a date data type (only available in SQL 2008), then you do not have a date. You have a string representation of...

The download will include all of the tools available in the toolkit. There are two tools that you would be interested in for this project:

SQL Compare

SQL Data Compare

The first...