Viewing 15 posts - 1 through 15 (of 61 total)
For partitioned tables, we can TRUNCATE a partition without use partition switching.
TRUNCATE TABLE YourTable WITH ( PARTITIONS 2, 4 to 7)
October 7, 2024 at 9:13 am
Table variables never stores data in memory but always in tempdb. It's also shown in the article referenced in the article.
It is possible for table variables to define the constraints...
February 10, 2024 at 10:01 pm
I agree. But it is interesting when we talk about physical or logical order. We see again and again on the web that in a clustered index data is stored...
January 9, 2024 at 2:30 pm
"However, the physical storage of the row on that page is not necessarily maintained in key value order" - the only important is, that the rows only can be accessed...
January 9, 2024 at 8:15 am
Some of the pages from my book published on Kindle.
January 8, 2024 at 12:05 pm
When the book is profiled several times on your site, it must also be reasonable that it is the same place with the same readers who are warned. It is...
January 4, 2024 at 6:48 pm
I strongly disagree. The book is Advanced/Expert, so I have to assume that it is not only read by beginners. So my code and example is just a simple example.
It...
January 4, 2024 at 7:48 am
There is a great problem in the book, when we are talking about performance. In a HEAP - on page 3 - data is NOT ordered as inserted. We reuse...
January 3, 2024 at 2:57 pm
I don't agree with the rules about the order of columns in a multi-column index. It is correct that it depends on the consumption pattern with "equal to" operator before...
September 4, 2023 at 8:27 am
YES! And the elapsed time will change more than CPU time on a production server with many users.
February 22, 2023 at 2:12 am
I use your script and just show the result.
February 22, 2023 at 12:58 am
Here is a test that shows using a separate MERGE is faster than a UPDATE/INSERT.
If you change your data to a more realistic scenario, you will come to the opposite...
February 21, 2023 at 8:55 pm
I have seen - and being removed - because I told
December 20, 2022 at 6:56 am
Else the whole solution is wrong!
December 19, 2022 at 8:56 pm
Viewing 15 posts - 1 through 15 (of 61 total)