@ Jeffrey

thanks, i hope someone from Microsoft reads this and fixes the bug in the Activity monitor.

I think i have a special non standard configuration on my servers, the...

I haven't reviewed them yet, but did wonder if, perhaps, the order in which the data engine is running the joins is different when I run the SQL and...

Sue, thanks for the reply.  I'll take a look at that article.

Chris, thanks for the info.  Just to clarify, I'm fairly certain the log file always seems to grow...

That would be my guess - in fact, having a DB in an availability group that is offline could actually prevent an automatic fail over from occurring because the secondary...

next update:

if i watch the CPU in taskmanager, after i openend processes in activity monitor, the vCPUs goes from 10 % to 30%. So it seems that the...

If the log drive goes offline - or the data drive for that matter - then yes, the database will go offline and will not come back online automatically.

When and...

I did not see anyone mention compressing the table - have you looked at those options to see if either row or page compression reduces the size of the table(s)...

ISNUMERIC() doesn't do what you think it does. I think you'd be surprised by what all SQL Server considers "numeric".

SELECT 
cv.char_val,
is_numeric = ISNUMERIC(cv.char_val),
is_int = TRY_CONVERT(INT, cv.char_val),
is_decimal...

The OP wants to setup a read-only secondary for 'reporting' and extracts.  I would not recommend allowing any external users access to a production system to perform data extracts.

In this...

Hi Jeffrey,

i noticed the same with SSMS 18.4 and MSSQL 2014.

But the funny thing is, if you execute the query "WITH profiled_sessions as (SELECT DISTINCT session_id profiled_session_id from sys.dm_exec_query_profiles...

Can you try putting in TOP (1) to insure you only get a single value?  Also, can you provide the execution plans for both ASC and DESC versions - it...

First - you really need to identify the process that is causing the problem and fix that process so you don't get these invalid entries.  Second - some of these...

How you address this issue will depend on how that database is accessed.  If there are a lot of queries that join to tables in the other database - then...

Have you tried rebuilding the table?

How is this other DB not a part of the upgrade?  Does it reside on a separate system now - and if so, how does the application access that database...