first thoughts - DO NOT CLICK ON THE LINK

You could create a table (b_tree) to store your numeric data in a single column.  Then assign additional columns based on common attributes of the numbers.

column1: your numbers

column2: applies...

Anthony is 100% correct - if you are sysadmin then you can just ignore the proc and go and do anything you want.

the proc is a waste of time unless...

if you use a SP for shrinking ,  but your DBA group have sysadmin then they can still run DBCC shrinkfile.

maybe education is the way forward

have you considered just reducing permissions?

I'm not sure if this is possible

you might be able to use a database trigger, but I've not seen it done before

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

not even sure that altering a file size is...

My prediction is that for the first five years or so, the software driving driver-less cars will play it safe and come to a complete stop when confronted with...

i'm going to try all the suggestions and see what works (when my hands get warm it's still snowing here)

Hahaha, had an upgrade weekend myself. Things went fairly smoothly, other than timing being WAY off from estimated and me validating tables in the back of a bowling alley...

Legitimate question, this book was written for 2008 and 2008 R2, how much of the information in there is still relevant, even in the introduction to the book...

would that be a company that labels...

yeah - data splits on 1000 potential fields, bad use of loops or functions. at least with a TVP you can just do an inner join on syscolumns before you...

and don't ask why we want to choose the columns in sql - I suggested doing a "select as many as you need" and use a show/hide property in the...

It honestly terrifies me how...

going back to the original topic - are the questions getting stupider

i got asked if this represents a sql injection risk 🙁

shall we ask if bob can...