e3h4 (10/12/2010)

---

People often assume you need to use GUIDs for unique values across databases and for replication. However, there is an easy way to get around that using an...

SanDroid (10/12/2010)

---

David Walker-278941 (10/12/2010)

---

I originally didn't like GUIDs because I thought they used too much "space". They really don't. Disk space is cheap, and GUIDs are only 16...

The drivers here don't seem to tend towards car-on-car merging, but they do follow the universal law of tailgaiting: The faster the traffic, the closer you're supposed to be to...

Yes.

But that would...

Paul White NZ (10/18/2010)

---

Kit G (10/18/2010)

---

Heh. I dislike the whole "Green" thing. And that stems from my total disgust at the whole Global Warming/Climate Change "science" that isn't...

Steve Jones - SSC Editor (10/18/2010)

---

Alvin Ramard (10/18/2010)

---

Jeff Moden (10/17/2010)

---

Steve Jones - SSC Editor (10/14/2010)

---

The green value, if there is one, comes not from you getting ebooks, but from 1000s...

mss.prince (10/18/2010)

---

Hai,

I have Two tables.

1) Table name :A(Column name is Month_id)

2)table name :B(Column name is Month_id)

max of month id in a table A Should be more than...

mss.prince (10/18/2010)

---

I have two databases and i want fetch the Month id from the one data base(like database a) based on below condition until get the record.

if max(month_id...

I'm not clear on what exact problem you are trying to resolve.

Yes, you should use either a stored procedure or a parameterized SQL command. But all that was originally...

Ninja's_RGR'us (10/18/2010)

---

mike.hartman (10/18/2010)

---

There is a proper time and procedure for every matter, though a man's misery weighs heavily on him (Ecclesiates). Each of the options listed in the original...

I wouldn't bother with a temp column of that sort. If you want to keep the old values, create a table specifically for that.

GilaMonster (10/18/2010)

---

GSquared (10/18/2010)

---

Take a look at the Create Database syntax in Books Online (or on MSDN). It has an option for re-creating a log file when you create a...

It'll have the same results.

Ninja's_RGR'us (10/18/2010)

---

GSquared (10/18/2010)

---

These scenarios don't sound like disasters to me. They sound like challenges that would be fun at best and interesting at worst.

Games have a goal (or multiple...