I might agree with Dan here. Can you drop the plan, or all plans and see if the plan changes? If not, I'd suggest starting a new thread, and posting...

I think that David's and Wayne's...

The only way I think this is beneficial is that if you are covering a query with the NC, then it is less IO to seek to values in the...

Not a bad thing, but for those of you that are MVPs, keep that in mind when reporting. I tend to report about 3/4 of my posts to MVPs noting...

I'd separate them. I've dealt with this before and when someone rewrite the rules slightly, or you merge companies, move people, etc. it's painful.

I'd learn towards separate tables for the...

Top Ten Posters in this thread (out of 15,100 or so)

Lynn Pettis 1533

CirquedeSQLeil ...

Congrats, Grant. I wonder how many of those are in this thread. Hmmmm, maybe I should do a touch of analysis 🙂

If this is important, and it's worth money to your business to avoid data loss, or much data loss, hire someone. Building a DR solution is something that takes some...

The issues are likely complaints about slow performance. The resolution is to hire someone to help you.

Excellent! I'm going...

My take: Painting a picture

I've hot-linked the article.

I don't know how your system works, but the server does make an entry here that you have a 100GB file in the disk system. If that...

That is great. My own virtual imaginary world on FB!

http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.100%29.aspx

Is it going backwards? I'm not sure about that. I think that PWS, and Python, are actually moving forward by bridging some of the programming concepts that were missing in...