Cool question, thanks Steve!

I also use "utility" databases for such purposes. You'd better go with such one, but if you insist on master or msdb, then look to keep it small and simple.

Why don't you want to go with ola's scripts? Maybe you should read more about its usage.
What about http://minionware.net/reindex/ ?
If still not interested, then you have the...

Does it depend on the Role?
Go to Tools->Options and under Transact-SQL chose IntelliSense. Check if it's enabled and the other settings.
In an opened "New query" hit CTRL+Shift+R or...

ldf is Log data file, i.e. the Transaction Log of a database in SQL Server.
It logs the transactions and data modifications in the database.
Right click on the...

Uniform extent: Its 8 pages are reserved and used by only one object
Mixed extent: Its pages are shared by multiple objects (data, indexes). The maximum number of objects that...

Replace the order of EXISTING and NONEMPTY and you should see an improvement.
The appliance of the NONEMPTY will eliminate the NULLs and then the EXISTING will have to check...

First, you may not have TEXT columns in your database.
Second, your query is not correct.
Try this

SELECT t.name,c.name,tp.name,tp.max_length,
'ALTER TABLE '+QUOTENAME(SCHEMA_NAME(t.schema_id))+'.'+QUOTENAME(t.name)+' ALTER COLUMN '+c.name+'...

Check these scripts for example 
http://www.sqlservercentral.com/scripts/Database/133740/
http://www.sqlservercentral.com/scripts/Backups/110733/

I chose CTRL+Shift, thinking that ALT+Shift was intended instead of. 
ALT+Shift is functioning in all SSMSs (including ssms 2016) I use, and unfortunately just ALT doesn't work.

You can rename an instance name, why not? It's simply supported. The name of an installed sql server instance is just an alias for the unique id the instance is...

It's early for that now. For one year you'll be about half of the current disk size, so then you'll have to think about the space. My answer is one...