Hmmm... I'm pretty sure that IP address is...

Heh... I did!

While it may come to having to do a reboot, recommending a reboot without qualification is a bad idea.

That's some really bad code to troubleshoot, Jeremy.  Someone not familiar with the tables would have a heluva time trying to figure what which columns come from which tables and...

I'm not going to answer your question.  YOU are.  Here's a test table that you can try all 3 answers on.  Don't let the "million" row thing scare you... this...

• This reply was modified 3 years, 7 months ago by Jeff Moden. Reason: Added more suggestions/info

If your ldf is actually larger than your mdf, like you say it is, then you have a much worse problem on your hands.  You need to find and fix...

@chris4600

I had same issues , the detach query executed for 4 hours but didn't completed.

The solution worked for me is very simple. I dont know the reason behind it...

Absolutely correct.  Can't believe I phat phingered that.  Thank you for the catch.

Ok... so tell us how you got the numbers is the "after" graphic from the numbers in the "currently have" graphic.  The don't add up.

Step 1 would be to query just the view to see if the date range returns anything.  Then add a piece of your query for one of the joins and...

If your system is like mine, the  data in the default trace lasts about 6 seconds.  😉

With the understanding that I've never used Power BI, are you suggesting that Power BI cannot get data directly from SQL Server without having to use a language like Python?

If...

I'm pretty sure that I'd remove the IP address and port from the original post. Just sayin'... you know... Security??? 😉

I just checked the MS documentation... Here's the link of the document section I'm looking at.

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql#recursive-triggers

It's amazing to me that this is still only a server level option but...

Just at a quick glance, I'm thinking the above from your original post is the source...

The use of COUNT() OVER will make light work of this.  It basically does what Phil says... provides a combination of COUNT with GROUP BY.  You would use the PARTITION...