Viewing 15 posts - 121 through 135 (of 1,199 total)
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.
name rows reserved data ...
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
I don't know might be going on. The result certainly is not expected. Could you post the output of "SELECT @@version" for your local instance?
Also, can you attach the query...
July 1, 2020 at 7:27 pm
OUTER APPLY is quite similar to a LEFT JOIN. The difference between JOIN and APPLY is that when you have A JOIN B, B cannot be a query that refers...
July 1, 2020 at 7:19 pm
The (nolock) is out of my control. My code won't pass code review if i don't have it. 😀
If I am doing the code review, it will not pass...
June 29, 2020 at 7:16 pm
First: stop using NOLOCK all over the place! It litters the code and it can lead to incorrect results being returned in a matter which is difficult to reproduce.
Next, if...
June 27, 2020 at 8:38 am
Viewing 15 posts - 121 through 135 (of 1,199 total)