I think (right now) I'd probably be a Ford Crown Victoria. Rugged, dependable, keeps on going no matter what crap gets thrown at it...

Why do you think the Crown...

A few possibilities to look into on this:

1. Are your systems both in an Active Directory Domain? Can you ping each server from the other by name NOT...

Thank you!

Now to get myself into the habit of using them...

Jason A

Thanks, I'll look at picking it up!

Jason A.

Tony Davis (1/30/2012)

---

My understanding is that the log chain starts at the last full DB backup. So if someone runs a full backup of the DB in the...

Megistal (1/27/2012)

---

First nice article!

Second, must I understand that the only way in SQL 2008 and Up to break the log chain is to switch to simple recovery model?

Pre-SQL Server 2008,...

Once more, thank you!

I'm poking around on Technet / MSDN now, trying to get a feel for those counters, and how to understand them.

Jason

Thank you!

I had forgotten about caching the various query plans, etc.

Is there any way to see what's currently in the caches, to see how much cache space query plans, etc...

I've often played the "what if" game about winning the lottery. I've always figured what I would do is first take 1/2 of every check and put it in...

About the only suggestion I could make, would be to either hide the script window, or if you need to be able to pull it up, minimize the window. ...

I've thus far not used either (hey, I still a noob...) But I have run into the exact situation as far as finding answers to problems goes...

I think this...

To some extent it does depend on who asks, but I generally start with:

Server Admin / Network Admin / Database Admin / Senior Support / General Flunky / Slave...

Sort of...

Thanks!

The Logical Name field in question, is in:

Database properties->Files

See the attached JPG, the section in question is in the red box.

I'm going to presume from where I found this, it...

If I win, can I bring my wife, and a curtain?

:ermm:

I may only be an "accidental" DBA, but I'm entering, if only for the chance to go for the ride...

To...