dustin.mueller (9/3/2010)

---

Grant, just wanted to let you know that I have used this particular script (or a slight variation of it) at 3 different clients/employers now, and it has GREATLY...

Then it sounds messed up. I suspect you may have some poor performance in some areas because of this.

Oooh, rereading it that came across a little bad.

I meant pointless for the people trying to save space.

Not the test. The test was great!

george sibbald (9/3/2010)

---

Ok, a bit of humble pie eating here.

this is the output from msdb..backupset. a full backup was taken followed by 3 tranlog backups. Nothing changed between the full...

Sorry, I've been in meetings all day.

Steve already nailed it. Thanks Steve.

Thanks.

I'm confused. You mean he only used views in queries inside of stored procedures? It sounds like you're saying he created views using stored procedures, which is weird.

In general, I'd...

Different ANSI settings could result in multiple execution plans.

There's no standard. In fact, I'd probably just leave the extension as is and rename the file as the other poster did.

After the silly work I had to go through to get this to function, I went ahead and made it into a blog post[/url] if anyone is interested.

If it's running faster it makes sense. 😉

But seriously, 16ms is hard to argue with, however it might still be possible to tweak it more. I'd try the suggestions offered...

b

Either the interviewer was trying to trap you (possible) or you've just found the first place you can help that business. Yes, deleting logs because "not much, or nothing, has...

Horatio (9/2/2010)

---

Hi there, me again,

Just another question, the database server is currently running on Windows Server 2003 Enterprise R2 (x86), with SQL 2008 Standard (x86) with SP1.

Would upgrading the server...

Just curious why you thought it might matter? Would it matter if the opening paren was on the same line as the column or on a different line? Just wondering...