Strong second to Grant's post.

I'll also add that partitioning a table can actually make performance worse like it did for me but was acceptable because of what I was trying...

I've been through this more times than I can shake a stick at.  With the utmost respect for those that provided them, none of the solutions offered are SARGable and...

I don't think...

And "Computer Shopper".

Actually, 100% can be generated using a little dynamic SQL, sys.columns, and sys.indexes.  I wrote some code for work that people are using.  I'll see if I can find the...

Man, thanks for the example, Erland.  Great stuff and timely, as well.  We just installed some 3rd party software where they required the database the software uses to be snapshot...

Erland... Before I spend a lot of time looking for it, do you have a link handy that talks about that problem?

Another thing, I that I did not observe until today, which is a quite important difference is this: If you have any form or snapshot enabled (and that includes...

I also have been having so many issue with SSMS load times, 30 seconds or more to refresh Tables list, or to Edit table, right-click and wait a life...

Friends, I've reached to a good improvement.

I destroyed fragmentation for table Groups_Roles Table. Result was very good. My goal procedure removed from SQL Serve Profiler with more than 3...

I'm thinking the reason why that worked is simply because that caused a rebuild of related...

Identifying results meaning...

Given a sample database schema and DML query provided, I have to come up with the results of the sample query.

This is a section of the...

Heh... I'm still waiting to hear back from the OP with an answer to my question! 😉

Yep... Totally agree... that's one of the many reasons why I avoid it like the plague. 😀

Totally agreed on the...

Because then your triggers don't have to be coded to do the conversions to VARCHAR().