Thanks, appreciate the response. I'll close the bug for now.

Thanks, appreciate the response. I'll close the bug for now.

Good catch. I misread the help. I've updated the answers and explanation.

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...