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...

opc.three (10/7/2011)

---

jasona.work (10/7/2011)

---

I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell....

I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell. I...

Never mind, I figured out I could (and how) wrap the restore in a Try / Catch block. Now I just need to set about getting it to loop.

Thanks!

Jason...

GSquared (8/30/2011)

---

GilaMonster (8/30/2011)

---

Just about...

Games still come with manuals?? Since when? 😉

Seriously, the last game I...

My understanding has always been that RAID-1 can be set up using two or more disks, all mirrored. I think generally most people look at other RAID levels when...

Brandie,

Your comment got me thinking, and caused me to (further) modify the backup batch file I'm creating. It now uses SQLCMD to backup the DB or Transaction log (2...