Just a question about flushing temp tables.

From what I have experienced, if a routine creates one or more temp tables on the first run, these are just used again...

Just a thought,

every post I've replied to in the last few weeks has had updates and new info from pretty much the same bunch of people on here.

Grant, Jeff,KTFlash, Jonathan...

How can I force Sql Server to not use the cache or other optimizations so that the same query always takes the same amount of time? When trying to...

Also, thinking on this, are you saying that the query and the view are the same, but the view is slower? Or are you saying that you wrote a...

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...