Viewing 15 posts - 136 through 150 (of 1,219 total)
What's the use of creating that xsd in this environment if I can't create a table from it?
I'm not particularly good at XSDs, but as I understand it there...
July 27, 2020 at 9:03 pm
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...
July 27, 2020 at 7:22 am
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...
July 27, 2020 at 7:19 am
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...
July 26, 2020 at 9:51 pm
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...
July 26, 2020 at 9:02 pm
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,...
July 25, 2020 at 9:23 pm
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...
July 20, 2020 at 4:34 pm
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 ...
July 19, 2020 at 7:35 am
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...
July 18, 2020 at 10:07 pm
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...
July 17, 2020 at 7:50 am
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...
July 16, 2020 at 7:35 am
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...
July 13, 2020 at 7:59 am
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...
July 10, 2020 at 8:35 am
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...
July 2, 2020 at 9:40 am
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...
July 1, 2020 at 9:18 pm
Viewing 15 posts - 136 through 150 (of 1,219 total)