Jeff Moden (9/29/2013)

---

Also, the absolute BEST way to do this would be to properly normalize Table 2. CSV columns are one of the worst things you can store in...

That won't allow you to calculate the size of the database files. It will allow you to calculate the total size of the allocated extents in the database. If you...

It's not going to get you better plans or better performance. If the stats you dropped weren't needed, they were never used. If they were needed, they'll be recreated. Stats...

DROP STATISTICS <table name>.<statistics name>

Why do you want to do this?

Oh dear....

If I may change the topic... For the purposes of a book chapter, what are your favourite statistics-related myths?

May I suggest getting familiar with the UPDATE, INSERT and DELETE statements? That edit data window should not be used in most cases, because it's not how you're going to...

Could you be a little more specific?

Jeff Moden (9/27/2013)

---

Speaking of "Are the posted questions getting worse"?... I was going through some old responses to some posts and I came across this one that no one responded...

Well, you can't do any operations at all to an offline database, so yes, you can switch with the database online (no other way)

No, the rows are not physically moved.

Look in books online for the format codes for CONVERT and use the one that matches the data that you have.

All of the posted code is vulnerable to SQL injection. Please, please, for the third or fourth time, read up on SQL injection and don't use dynamic SQL until you...

What do you mean exactly by 'online operation'? What do you categorise as a 'logical operation' and a 'physical operation'?

Duplicate post. No replies to this thread please. Replies to http://www.sqlservercentral.com/Forums/Topic1499649-392-1.aspx

Convert them to datetime with the correct format code and use the DATEDIFF function. Don't store dates as varchars, you end up with all sorts of problems if you do...

btw, it's polite to cite your references when you quote someone almost verbatim...

I will second the recommendation to simplify. Table spools occur when the optimiser decides it's easier and cheaper...