Let's continue to check out the "hooie" factor...

Since they don't provide any links in that article...

Did it include a request to move TRUNCATE TABLE from DML to DDL?

According to this post https://www.sqlservercentral.com/blogs/what-is-%e2%80%93-dml-ddl-dcl-and-tcl-in-tsql

SELECT is classified under DML.  However, when I check the SQL online documentation,

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements?view=sql-server-ver15

SELECT is not listed under DML.

<li style="list-style-type: none;">

1. So which language type...

Hi Guys ,

I have a very basic question regarding comparing 2 execution plans .

While comparing the execution plan i usually see Estimated sub tree cost of the left most...

@arvind.patil 98284,

Why are you asking the same basic question you asked on the other thread of yours?  The answer hasn't changed just because you changed the problem from 3000 tables...

I...

Paul, there's really no difference between "just a test server" and a production server.  They are both "in the domain" and should be treated equally... especially when it comes to...

Really REALLY BAD IDEA!  That also means that the "sa" user is still enabled...

Yes on keeping it on a separate assigned drive letter.  I find that it's important to keep TempDB associated with a different drive letter than all the rest so that...

Heh... I wonder if some of the information that the fitness watch is telling you isn't a part of the reason for some of the restless nights 😀

A part of the problem is doing the rounding inside the sum.  I recommend that the rounding be done on the sum rather than inside it for both reasons of...

You've got a wad of things wrong with your code.  Can you please tell us what the data types for the "observ_date" and "value"  and "@p_site_code' columns are?

We have something that works great!  We don't do continuous deployments to prod! 😀

Ummm... why does KSA come first in #1 results?

Just to set expectations, I never backup to the server I'm backing up from.  I backup to a NAS.  My 1TB database takes about 30 minutes and I'm not splitting...