Try this:

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

Where I'm currently working we have a coffe machine, but we're not even allowed to get a coffee and drink it there, we have to go back to the office...

Paul White (3/12/2010)

---

Tell me about it. How can summer be over already? 🙁

Freak storm over here this afternoon - roofs ripped off, trees knocked...

Totally different topic: who's going to the European PASS Conference[/url]?

It's too long, too far and too expensive for me, but it would be interesting to know how the bookings are...

Congratulations, Jeff!!:exclamationmark::exclamationmark::exclamationmark:

I have both running on my laptop, with no problem.

I'm sorry, I don't understand what problem you are facing. Can you explain it in other words?

Very nice article, Jason! Added to my briefcase.

I'm with Steve, no sarcasm here in my opinion.

Alvin Ramard (3/10/2010)

---

I just remember something from a few years back.

Person answer an internal posting for Data Warehouse Adminstrator. The person did not have any valid experience, but her...

Roy Ernest (3/10/2010)

---

NFL is more like a sport that is part of Gladiator games...:-) Too violent for my liking.. 😉 With such a strong body like mine, I should definitely...

NFL... AH! Now I remember! It must be "American Football", that wimp...

You could also benefit from a strange behaviour that I found trying to generate a Tally table with no IO: using UNPIVOT seems to be slightly faster than multiple UNIONS...

You can rewrite

SUBSTRING(@str, @start, @len)

as

RIGHT(LEFT(@str, @start + @len - 1), @len)

but I don't think it will help much. I tried your code with that substitution, but it still threw errors,...

Jack Corbett (3/5/2010)

---

For those not on Twitter, I passed the 70-432 Implementing and Maintaining SQL Server 2008 exam yesterday. Easier than I thought it would be. If...