Steve isn't suggesting running the traces via the GUI. He's suggesting using the GUI to create a server-side trace script and then running that. It's easier than trying to write...

Start with the latest error log and any relevant-looking messages from the Windows event log, system and application logs.

No, that has nothing to do with the OS's memory.

Can you post the error log?

Start up failure. Check the latest error log and see why the start up is failing.

Ok...

"The language is expressive, easily readable and values explicitness. Abbreviations and corrupted spelling should be avoided in variable names"

and the string data type is 'str'

Looks like the instance isn't running. Check that the appropriate service is running

I'm watching an introductory course (on Pluralsight) on a new language, and the introduction is almost enough to make me ditch the language and never look at it again.

"... the...

So run the original, run the changed and make sure that behaviours are the same. Basic unit testing.

Probably not...

Bear in mind that identity has never been guaranteed to not have gaps. It's an ever-increasing number, that's all. It's not gap-free and it's not even guaranteed unique (you can...

Actually, yes we do.

Sure, there are some groups which give them all a bad...

No. Never said that.

I said, if you change the initial size it will start smaller. That's it. Counter-productive, as SQL now has to grow the files, but if you want...

Or, as something a tad easier:

exec sp_MSforeachDB 'USE [?]; IF ''?'' NOT in (''master'',''model'',''msdb'',''tempDB'') DBCC ShrinkFile(2,10)'

Untested, so may have syntax errors. Test before use.

Shrinkfile takes either the file...

Work as in start smaller, probably. Work as in not get full and throw errors, probably not.

That would be very nice.

I have before been asked if I'm at the wrong interview,...