How much freespace are you dealing with? How much freespace on the volume that houses tempdb?

I think the best solution is to enforce 4 digit year on the input and in dates coming into the system.

Sure somebody could not have been born yet in 2029....

Doug J. (7/31/2014)

---

Jeff-

This:

Steve Jones - SSC Editor (7/31/2014)

---

Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring at him from the...

Sean Lange (7/31/2014)

---

SQLRNNR (7/31/2014)

---

swasheck (7/31/2014)

---

To qualify my statement, I have no personal context for anything involving Jeff Moden and I'd welcome him. I've only perused SSC forums in the past...

Task achieved!!

Well, you have good looking legs.

swasheck (7/31/2014)

---

To qualify my statement, I have no personal context for anything involving Jeff Moden and I'd welcome him. I've only perused SSC forums in the past and have just...

Lynn Pettis (7/31/2014)

---

Ed Wagner (7/31/2014)

---

Jason is braver than I am by upgrading in place. I've had SP installations fail, so I'm a bit wary of upgrading in-place.

When I upgrade,...

We're supposed to keep it hush hush and then party when we hit 100k.

Sidebar...are we supposed to pronounce your alias as "L Jerry"...

NUL

Lowell (7/31/2014)

---

there's a logonproperty function that lets you pull things like the last time the password was changed;

with this query, you could find items older than 180 days, and issue...

Disable the jobs on the mirror that are trying to perform the backups (or other maintenance). Those should only be enabled in the event of a failover.

I wouldn't use the method suggested by the boss.

I will typically use one of two methods. Either in-place upgrade or side-by-side upgrade. The side-by-side allows for easier rollback.

In...

dwilliscp (7/31/2014)

---

Thanks to SQL Sentry we have built on to our job step -- alert-- and can now check for jobs that run too long. But I do see one...

Miles Neale (7/31/2014)

---

Developers have in the past cursed bean counters for various reasons. However there are reasons for counting and tracking. Maybe we need to regularly check and...