Why not creating a NONCLUSTERED Index on the datetime column and "walk in small batches" through the table.

Small chunks of data prevent LOCK ESCALATION and you can run it smoothly...

SELECT r.session_id, s.text
FROM sys.dm_exec_requests AS r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS s
WHERE r.status = 'running';

This will work. The author used the wrong aliases 🙂

BTW: I would not check for...

Hey Leo,

your assumption is correct. This is an indicator of an Clustered Index Creation or Clustered Index REBUILD. This pattern (INSERT INTO MyTable SELECT * FROM MyTable) is an internal...

I am here with Brian Gale. For me it is more a commercial than a technical post.

I would love to see the incoming statements on the database side.

e.g.

            
January 27, 2024 at 8:43 am
            
#4368573

            
            
                                                
        

I suspect that you wanted to describe something else with your article but not the benefits of MIXED vs. UNIFORM extents.

• The default behavior of SQL Server BEFORE SQL 2016...

• This reply was modified 1 year, 10 months ago by Uwe Ricken.

Although this topic came quite late to my attention it is more actual than ever. I see lots of people favorite sequential INT/BIGINT as PK but - as Jeff has...

Hi Stuart,

WHY would you not recommend partitioned heaps? Can you give reasons for your rejection?

Hi Steve,

I trapped into the pitfall and didn't see that the last query was not using any predicate 🙂

If you use a query with a predicate it will create a...

Although this article is over 3 years old I came around by accident today. Very interesting and - to be honest - I didn't had it on the focus so...

Hi Jeff,
THREADPOOL is definitely a problem of a heavy used system with lots of requests at the same time. To fight against it I would of course check the...

Hi Kev,
" Can anyone explain the discrepancy between max_workers_count and the calculation as I presented it here?"
You can set the max number of threads manually (basically not...

Thank you David,
i can only repeat the others; very interesting. I will definitly use this as a good example for uneven configured multiple database files 🙂

Thank you all for your positive feedback.

I love to create QotD with a bit more "substance" from my real world experiences.

I will try to write more of them in the...

Hi,

of course you can test it with a clustered index on one or...