Just note that you've got an estimated plan there (or more correctly, an execution plan without run time information).

I can't thing offhand of another way. If it was a...

UBD?

Thanks, I'll send it to Steve over the weekend.

Lynn Pettis (5/8/2009)

---

Well, nothing wrong with a Masters by course work, that was my MA as well. Trust me, though, there was plenty of research work involved outside of...

Are you seeing IO bottlenecks? (perfmon, physical disk:avg sec/read, physical disk:avg sec/write, physical disk:% idle time)

First things first, before you go looking for hardware. Fix the queries, fix the indexes....

Create a new filegroup

Create a new file in that filegroup and put it on the D drive

You can move entire tables to the new filegroup by rebuilding the clustered index...

I've had a couple done. I used to work for a Premier client,...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic712854-9-1.aspx

Lynn Pettis (5/8/2009)

---

I'd have to do some searching, might be in that thread he started when he mentioned he wanted to get his PhD, that the M.C.A. is a Master...

GSquared (5/8/2009)

---

GilaMonster (5/8/2009)

---

From everything I've heard, I'm guessing that his Master's degree was done by coursework, not by dissertation. Odd thing is, I can't find any reference to a degree...

Again, what happens if you have only one backup, you go to restore...

sumanta.roy52 (5/8/2009)

---

Hi,

I am taking full backup everyday 23:00 and overwriting it with the existing one. Transaction log every one hour and appending it every hour to get to get all...

Last full backup. So if you have a full on Sunday,...

Agreed.

All too often I find that when people say that they 'denormalised for performance' they actually mean 'didn't...

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Log backups contain the log records since the previous log backup. Full and diff...