Have you simply tried clearing proc cache for the database that has the code that's causing you fits, which would cause a recompile of your all the code for that...

What is the code to sum this row of data (trip duration in hours and minutes, and about 800,000 rows). Characters are varchar, and I have tried casting based...

Since half of your replies have been flagged as SPAM and they all seem to be in the same vein of acknowledgement...

Can any enlightened cloud industry folk let me know why enterprise tech companies - particularly those cloudy ones - LOVE having a big, massive, expensive Sales Kick Off event...

Heh... ah... but we ARE judging. 😀 The third party code and database design sucks. 😀 😀 😀

Is it Monday?  It seems like Monday.

One of my DBA's set up a SQL account, with db_owner on a database in production.  The contractors have now raised havoc with...

Heh... "To err is human.... to really *&*&%^$%! things up, you need a computer". 😀

p.s. SQLProfiler isn't "dangerous".  People that don't know what they're doing with either SQLProfile or Extended Events are what's dangerous. 😀

Sometimes, even a good healthy dose of magic pixie dust can't break through a mountain of...

In a word, No. There are much better ways...

regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month

can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.

older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range

I can't reply...

I recommend that you don't make...

p.s.  I also notice in one of your previous posts above that the table has 4 non-clustered indexes... that's likely where the page splits are coming from.  Considering the very...

Yes. Its a small table.  Question is , when there is 0 rows in the table, and when we say SELECT * FROM <Tname> , why SQL Server is...

@eliob ,

Your post actually sounds like it was created by ChatGPT. 😀  And then we see the SPAM link that you included. 😀  So that others may learn, here's the...