Thanks, Jeff, for this great article.

I have one small editorial comment.

In the section Filtering for "2" Products, the query is the one below:

--===== Find Customers that bought either "A" OR...

Thanks for this editorial. You know, it's funny. A lot of things that I used to see as grumpy in DBAs or in other IT people is actually a lot...

SQLDCH (6/4/2014)

---

In your procedure, the temporary table that is created to hold the output from RESTORE FILELISTONLY creates the columns [FileID] and [BackupSizeInBytes] as an INT. It should be...

Thanks to everyone for their replies!

Yes, I am restoring using the same version of SQL Server, just on a different server.

I will take some time to go through the...

TheSQLGuru (5/28/2014)

---

Another vote for Red-Gate SQL Compare. There are a number of other options from third parties...

I feel the same way.

- webrunner

Thank you, Erin! Pretty impressive article. I look forward to using the scripts as soon as possible.

- webrunner

I think this is the most complete etymological explanation:

http://english.stackexchange.com/questions/10976/does-the-word-table-have-anything-to-do-with-a-table

That kind of table comes from the Latin tabula meaning "a board or plank" which was used for writing down columns of...

Thanks - great question. I got it wrong, so back to the books!

- webrunner

Yes, I agree. It would help a lot to post the...

Lynn Pettis (5/21/2014)

---

webrunner (5/21/2014)

...

Thank you for your response, Jeff!

Yes, I am working on a test server. I just want to be confident that when I submit all these changes to...

Jeff Moden (5/20/2014)

---

webrunner (5/20/2014)

---

Hello experts,

I'm working on an upgrade to SQL Server 2012. One of the things that came up is that the text, ntext, and image are being deprecated....

As others have said, that involves updating many rows when, with...

Cool question. Thanks.

- webrunner

This is great! Thanks for your help.

- webrunner