Paint me cynical, but I've never yet seen anyone but a database professional build a database, or the code to access it, in such a way that it didn't end...

Do you learn most easily from books, from hands-on, or from mentoring through examples? Different people learn differently, so that will matter. (Some can mix-and-match, too, of course.)

If...

GilaMonster (8/10/2012)

---

Late, and I have not...

Steve Thompson-454462 (8/10/2012)

---

GSquared (8/9/2012)

---

On the point of "don't lose sight of the big picture", I'll just say that this is one of the biggest mistakes people make, assuming they can't...

Shadab Shah (8/12/2012)

---

Jeff Moden (8/10/2012)

---

Shadab Shah (8/9/2012)

---

Hi all,

I have come across various section on this website where it is mention that SQL Server is a set based programming language.

My...

I primarily use Read_Committed_Snapshot on most transactional databases these days. Not so useful on staging/bulk-import databases, but on OLTP systems it can be great.

Unless you routinely have large numbers...

I think you can set the formatting for a column by setting a property on it. I know I've done what you're asking about before, but it's been a...

jasona.work (8/10/2012)

---

Wi nøt trei a høliday in Sweden this yer?

See the løveli lakes

The wonderful telephøne system

And mani interesting furry animals

Including the majestic møøse

A Møøse once bit my sister ...

No...

What I've found most useful when designing set-based vs row-based coding, is a few tips:

1. Assume rows don't have an order to them. So you can't do "row...

< snark > yeah, right! < /snark >

Robert Davis (8/8/2012)

---

The reason you use multiple data files for tempdb is not for disk bandwidth. It is to avoid contention on the allocation pages. Saying that there is no...

Fly Girl (8/9/2012)

---

Next time it's hung I will try dbcc freeproccache just to see if that resolves the problem. Seems like an easy way to see if that is the...

adrian.facio (8/9/2012)

---

Maybe we could use the google geocoding web service with a clr object to normalize an address.

https://developers.google.com/maps/documentation/geocoding/#Geocoding

According to this link, we can sent an address and get the coordinates....

FunkyDexter (8/9/2012)

---

Wierdest interview I ever has was only about my second job after finishing my degree. The boss turned up an hour late and the only thing he seemed...

Brandie Tarvin (8/9/2012)

---

GSquared (8/8/2012)

---

Evil Kraig F (8/8/2012)

---

-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a...