To concatenate values together...

location = ''.join(['New','south','wales'])

"This will feel natural and elegant to the initiated."

and I thought readability was crucial.

Edit: The snide comments are more directed to the training course than...

Restore an earlier backup which isn't corrupt. You should know which is the latest clean backup, it'll be the one right before your scheduled checkDB started failing (you do have...

Do some research on latch timeouts.

It's not database corruption, it's a latch wait timing out (shouldn't happen). You may need to open a case with product support.

Koen Verbeeck (4/2/2014)

---

TheComedian (4/2/2014)

---

Isn't there a copy available on the Internet? I don't think taking the course is a possibility for me since I'll be hard pressed to convince...

paul.knibbs (4/2/2014)

---

Pah! Everyone knows...

Restore from a clean backup.

Ok......

Guideline for python code:

"Explicit is better than implicit"

I can agree with that, it's something I argue for when teaching T-SQL. Be explicit.

Then, from the style guide for python:

Bad form:

if attr...

Readability is crucial

Beautiful is better than ugly

Simple is better than complex

It's better because now you don't have all those unnecessary starting and ending characters, and you'll avoid the arguments about...

Yes, indeed. The indentation determines which...

A checkpoint is run. Not created. It's...

No.

Got below message from SQL error...

This may be of some help: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

Absolutely impossible to say.

Indexes are created to support the queries that run against that table. Hence the queries will determine which (if either) of those index options are appropriate.

SQL runs a consistency check on that table. If you stop the execution, it stops.

How about having the test software crash at the end of your MCM knowledge exam (5 hour exam from hell) and they can't tell you for more than an hour...