I do think large columns should be out of row, as Jeff noted.

However, I also do like vertical partitions of tables, especially when developers struggle to avoid SELECT *.

My main...

I'd focus on what you know. Ultimately the cost difference with Azure SQL, Maria as a PaaS service, PostgreSQL, etc. will be small compared to you understanding the system and...

Double check your configuration settings for the network. You could have something else open and available. Ideally, we do not expose SQL Servers on the Internet in any way, only...

You cannot do this directly. There isn't a capability for T-SQL to do something like "select x from @mytable".

If you want something like:

declare @Product2Count int
exec @Product2Count =...

Thanks, I've updated the question.

Bump. Looking for a positive test result to close this.

I still think WHILE (1=1) is poor coding, even with cursors. Using a test that can end is a better practice.

In the Henry v Cook wars, I lost badly.

Thanks for the kind comments. Glad that you enjoyed it.

Be good to see the Linked Server definition and query.

This is definitely in the driver or front end that the cursor is being set up. Posting that code may help.

Choose how or where? I'm not quite sure what you're looking for here.

If there are multiple pages in a thread/topic, the numbers are at the top:

If...

One other note, this info from MS assumes you have a valid .hdr file from  this database.

It is silly to look back an investment and now try to justify it. I know at RG we are examining if we need to make investments going forward, but...

From MS, this suggestion:

If the user really does not care about the data in the filestream folder structure, it is possible but they would have to drop and recreate the...