A couple of things to check:

Check in the SQL Server Configuration Manager > Network Protocols > Protocols

Verify that Hide instance is set to no

In SQL Server Surface Configuration Manager, make...

To reiterate what Steve said, you will be able to re-use the log space when doing log backups. In full recovery mode, you should be performing t-log backups at...

Nice article Gail.

statistics courses and google search that landed the answer on the first return

Thx Bob for the insight.

I too missed the extra comma but saw the intent of the question. Despite that, it is nice to have learned something about the extra comma in table creates.

I liked the question - and the previous spatial questions on QotD. Makes you think back a little bit to geography and geometry - woot!

This was a good question. I would have initially ticked the truncate table option but ran some testing and research first. Though accurate, I am not sure I...

The question must have been corrected by the time I answered it. The sql errors with the tags did not exist when I answered this question so it was...

Keep in mind the question asked for highest and lowest respectively. If construed differently than the highest possible and then the lowest possible datatypes; we would still have to...

This question was good in that it pointed out something really simple, yet way to easy to overlook when troubleshooting or code-reviewing in the first place.

Agreed on the spelling issue. I pause for a moment on questions with mis-spellings to make sure there is no trick involved. The flipside though is that it...

I found many of the items in this article (as already divulged by Gail), to be somewhat inaccurately founded. That said, with proper documentation and good peer review, this...

Great stuff/thread. Wish i could have made it to that Pass session.

nice to have a clear explanation.

Good question