Merry Christmas to all.

Movie traditions:

• National Lampoon's Christmas Vacation
• Rudolph the Red Nosed Reindeer
• The Hallmark channel
• The Lifetime channel
• Its a Wonderful Life

Grant, I agree with Miracle on 34th,...

Henk, Did you open a ticket with Microsoft about the issue?

 

Jeff, Your suggestion has plausibility. My question to you would be, if those characters are the problem, why does it only happen on the new versions of the driver?

We are...

We had the same problem starting last night when we shut down the VM that hosts one of our SQL Servers due to a Hyper-V host issue. This particular sql...

Thank you for the reply.

Could you clarify the Maximum Server Memory formula?
My VM's for sql server run with a minimum of 48gb.
If I follow your recommendation, I would be taking 9gb away...

Nice article. I have been working on a similar concept for our environments.
I did notice a disparity between you sql for the table and your paragraph describing it.
In...

tom.artz (3/9/2015)

---

Nice article. Unconsciously or unknowingly I have categorized our databases into six categories - a 2X3 array. One axis is disaster / recovery axis with two high level options;...

We are currently in the process of upgrading to 2012 for a majority of our sql servers. I still have one server on 2008 only because the 3rd party product...

Good script.

Here is an improved version that:

- fixes the length = -1 problem for MAX.

- PRINTs the output to the Messages tab to make it easier to copy and past...

Bill,

Your senario might work if I had only a few databases to mirror and a few "applications" to change connection strings.

I have 66 databases, and growing, on the cluster. I...

I found the article very interesting. As the sole DBA I am currently supporting 2 clustered environments in 2 domains. The headache I am going to be facing next summer...

Ed,

Thanks for the comments.

I would normally agree with you and have the box rebuilt.

But in this case the box is already in production with one instance of sql running clustered...

I should have done a little more digging before writing this post.

I figured it out.

Control Panel > Programs and Features.

Select Microsoft SQL Server 2012 (64-bit).

Click Uninstall/Change.

When the Add/Repair/Remove dialog come...

Thank you for the post, it looks interesting.

One question.

How do you recreate it when Sql restarts?

Since tempdb is deleted and recreated on a restart.