Declare @DBID Int Set @DBID = DB_ID ()
Checkpoint
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
DBCC FLUSHPROCINDB (@DBID) WITH NO_INFOMSGS

That will clear execution plans and data from memory, which would be...

I am confused, this...

the situation at my end is that begin can be less than equal to or greater than equal to. and by logic works for it , only thing is,...

as long as I can use scalar value function inlining and the new table variable cardinality estimation then i'm happy

For "may be" read "very often is".

Would you go further to say that if a query does run far more quickly the second time it runs, one of many...

I've just had a little cry in the corner, rocking back and forth

a few years ago I walked into a new job and was told that a certain system had...

would using 2019 compatability mode, but setting the "legacy cardanility" option on be a wise idea?

the only problem I've found with scripting this stuff out is that locks are quite transient - you spot them and then they disappear (this is a good thing ,...

Can I run a where statement on sp_who2 then a delete to "kill" that process?  I get the same issues with the master.dbo.sysprocesses. How do I remove the record...

if you have the pleasure of dealing with Amazon RDS - activity monitor will never work, good job i'm used to good old fashioned commands like

sp_who2

sp_lock

select * from master.dbo.sysprocesses

we're all going to ask the same thing - can you upload a query plan - I would suspect a missing index or the group by dateadd function….

without seeing the...

hey,

hold on - wasn't this why hierarchyID types were invented ?

you can even use persisted computed columns to make it nice and fast.

you would need a 1 time...

ok here is the most basic stuff you need - the rest you can google and find lots of cool code

CREATE TABLE #htest (id INT IDENTITY, hierarchyvalue...

might take me a little while just to pull all of the examples and test data together - it's 2 pm and I've not had lunch yet... my laptop is...

my advice - simplify the connection/session thing into SPIDs - much more useful.

quite often a connection will remain idle and the SPID does nothing (this gets more complicated when connection...