I'm not particularly good at XSDs, but as I understand it there...

But, OK, if you open the shaft to the hammer, there is actually a screwdriver inside. That is, if you really want to do this inside SQL Server, you can...

But that still leaves the issue at the receiving end: SQLServer can READ files, can it not? The problem there is it needs to be fully dynamic. I could...

And SQL Server cannot write files.

You can escape to the command line to call programs that write files, but don't you hear how akward that sounds? You could just as...

Sssh, Jeff, you were not supposed to say that.

And what I said stands: there is no way to write files from SQL Server. Yes, you can call SQLCMD or BCP...

No, there is no simple SQL solution for this, because the Database Engine is not designed for reading or writing files, so there is a road block already there. OK,...

I don't think so.  As I understand it, REORG never needs more than one additional 8K page to do its work (that's its biggest appeal).  I can't imagine...

No, I don't have a link. I just played with a reasonably big table. As a starting point I had this output from sp_spaceused.

namerows reserveddata  ...

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

It can also easily cause extreme usage of the log file.  For example, I had (it's grown since the test) a 146GB Clustered Index that was only 12% logically...

Either should work fine. And with that small size, I'm tempted to say that it will work fine, even if you do nothing at all, assuming that the database is...

The second one: "it depends".

Overall, you cannot say this or that construct is faster. SQL is a declarative language. This means that you state what result you want, and the...

Did you look at the query plans? These are obviously different.

Generally, I have found that the optimizer often have problems with OR conditions, and rewriting them with UNION or similar...

To be able to say what is the correct data type, one needs to know the business domain, which no one here does. What I can give you are general...

I asked for @@version for your local instance, not for Azure MI. Anyway, it is in the plan. and it seems that you have SQL 2019 RTM. You could try...

• This reply was modified 5 years, 11 months ago by Erland Sommarskog. Reason: Addition