These probably shouldn't be "scripts".  They should be stored procedures (possibly in a permanent "utility" database) and then you can do what Scott has suggested to keep things safe.

Having trouble with the below formula. Technically I want to display it by a percentage with two decimal points but when I run the below I get it with...

MS has actually provided complex formulas for years.  But it's so difficult to come up with accurate numbers to go into the formulas, and the result is only as...

My example was one of many.  My point is instead of using exact points to try to hit an inclusive BETWEEN, use ranges that have an exact start and a...

As to reorganization, I believe it's still best practice to use reorg for columnstore tables (I'm on SQL 2016).   Full rowgroups won't be affected at all by this process,...

Actually, for non partitioned rowstore indexes, there is (it takes...

Ok... now that I agree with.  Thanks for your time, Rune.

So why not make it truly easy on yourself and use a "Open/Closed" bit of code and setup.  For example, instead of say something like 2.01 to 3.oo as a...

Do you have a short example or suggestion of when data profiling...

So, Paul... what are you going to do if a value comes in at, say, 2.005?  That won't be caught by any range you've defined.  Are you absolutely sure that...

Heh... there actually is a way. 😉  I've presented the method to just a couple of PASS chapters and I'm working on some proposed articles for a "Stairway".

You say that you're "REBUILDing" indexes.  Do you really mean that or are you including REORGANIZE, which I refer to as "Death by defragmentation"?

Obviously, I recommend NOT using REORGANIZE.  It's...

It's amazing to me that people will tolerate a built-in 2% error for just about anything.  It's just not that difficult to maintain an active total for "big data".

Details on what?  Don't expect folks to read every post on this thread to figure out what you're talking about.  Be specific or quote the...

I'm actually a bit concerned about the original query because it basically returns EVERYTHING from the beginning of the table up to a point in time.  That could be a...