We need to really emphasize what RatBak posted (re-quoted below)...

Do not expect performance improvements for queries, inserts,...

hi,

I heard many people saying "functions are denounced in tsql" is there any catch?

q1) need to know what are the cases where we should not use?

q2) should we avoid...

Interesting solutions, so far.  Let's try one more...

First, let's simplify the code to make the readily consumable data.  This is the best one of the better ways to post such...

I'm thinking that the answer is somewhere in the Actual Execution Plans.

p.s. That's a major hint for what you might want to provide.

• This reply was modified 1 years, 11 months ago by Jeff Moden. Reason: Add p.s

I was offered the help of a secretary once when I was getting around 350 emails per day so it was very hard to find the important emails mixed...

The concept of AI in the picture near the end of the article is actually pretty grotesque, IMHO.  Sex doll for both the body and the mind.  Possibly the worst...

Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...

Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the...

The *data* file drives should be 64K.  Log file drives should still be 4K.  If you mix data and log files on the same drive, you'll want to use...

Hi All,

I have a data in column A in where in need to achieve the count which I have mentioned in column B. Please find the attached excel dataset...

Cool.  Can you show us what you settled on?

I'll take a smart "Pepper" (think Iron Man) over an AI all day long.  And, no... not for looks... for smarts that I can trust instead of having serious doubts. ...

I got my "best job ever" by answering the ultimate ad for someone that knows SQL...

"We need someone that can look at SQL,  figure out what's wrong, and fix it".

That...

Please see the following article for how to capture the results for all databases.  What most people don't know is that most of the DBCC commands will allow for the...

Like has already been stated, it's pretty much impossible to help with performance issues just by looking at code. ...