Much better would have been to create an SSMS server group(s) with all the relevant servers in it(them), then fire off the script for a given server group(s) whenever needed. ...

I agree.   I'd strongly urge to concentrate on the core aspects of SQL Server first, then learn about PowerShell later if you still want to.  There's enough to learn in...

For new db(s), the support team can "notify itself".  It's easy enough to check every day to see if a new db has been created, whether a user tells you...

SQL Server must pre-format log files (setting each page's non-control data to binary zeros, I think).  That will take quite a while for 95GB (apparently 3 hours on your system...

Get the best SQL administration book for whichever version of SQL you are on.  The "Inside SQL Server"/Internals books with Kalen Delaney are excellent.

For learning T-SQL, get books by Itzik...

To clarify, you can compress non-clus indexes, and should often do so, but you must compress each one separately.

Also, 80% is a very low number overall, are you sure you...

Be sure also to make sure the "cost threshold for parallelism" is not too low.  Hint: the default is too low, if you haven't changed it,  you should.

5. Avoid using reserved words as column names (PERIOD)

PERIOD is not a reserved word in SQL Server. (Nor is it reserved in ODBC, also not on the list of future...

Sorry, I had some difficulty figuring out specifically what you meant.

SELECT CustID, COALESCE(CASE WHEN ValidLand = 0 THEN NULL ELSE LandPhone END,

CASE WHEN ValidMobile = 0 THEN NULL ELSE MobilePhone END,

CASE WHEN ValidOffice = 0 THEN NULL ELSE OfficePhone END)...

SELECT CustID, COALESCE(LandPhone, MobilePhone, OfficePhone) AS Phone

FROM PHONENOS

Such insanely bloated calendar tables have actually become much closer to the norm.

It's terrible.  Create a nonwork days table with only the dates in it (you could also add a...

So like I asked before... what would...

While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" is...

While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" is always a...