How often is the data modified (INSERT, UPDATE, DELETE) compared to how often is the data queried?

I had to install Management Studio on the server, because it has a server tool asinstancerename.exe bundled in it to rename an Analysis Services instance.  When they stripped SSMS from...

Sometimes they've decoupled too much.  For example, I recently had to rename an Analysis Services instance for SQL Server 2016.  It's actually a fairly easy thing to do, but unfortunately...

This is LocalDB, not exactly SQL Server Express.  If it was Express the connection string would look similar to what your production one needs to be.  LocalDB works more like...

I'd never considered this approach, not sure how successful it would be.  I can understand your reluctance to rely on magnetic media or flash memory for long term storage but...

Sorry I didn't explain well enough what that script was showing.  As Steve and Lynn stated, that query shows you if there are any SQL Agent jobs that already are...

you can check the SQL Agent metadata to check if it's a SQL script in a job.  Run this in MSDB database:
SELECT j.job_id, j.name, js.step_id, js.step_name, js.command

Yes, nice and easy one for a Friday.  I have one silly question though... if you have a table value constructor that explicitly already has the unique numbers 1 to...