TheSQLGuru (10/7/2014)

---

Try your XML method under stress and see how it holds up. Or with lots of rows.

There are some very nice threads here on SSC.com about...

😉

Evil Kraig F (10/7/2014)

---

djj (10/7/2014)

---

Finally someone listened. We had a meeting today and we are looking to revamp the entire phone number storage.

Not because I suggested it, but a...

The following approach assumes the same list of IDs as a comma seperated set. It does not involve a temp table or dynamic sql, and should keep a fixed execution...

I've got the genious DNA... right here! :kiss:

Luis Cazares (10/7/2014)

---

Eric M Russell (10/7/2014)

---

Yes, a genious should be able to create their own job, but a high IQ doesn't guarantee that the person is also a self-starter; it...

The system table sys.sql_logins contains a column called [password_hash] and sys.sysoledbusers contains a...

Gary Varga (10/7/2014)

---

Eric M Russell (10/7/2014)

---

Luis Cazares (10/6/2014)

---

Miles Neale (10/6/2014)

---

There will be no need for school. We will alter the DNA prebirth so that no one is born without the...

Luis Cazares (10/6/2014)

---

Miles Neale (10/6/2014)

---

There will be no need for school. We will alter the DNA prebirth so that no one is born without the initial abilities of Albert E....

Do they have the exact same SQL Server version and service pack level?

sqldriver (10/6/2014)

---

Eric M Russell (10/6/2014)

---

sqldriver (10/6/2014)

---

At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp tables, 47 stored...

sqldriver (10/6/2014)

---

At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp tables, 47 stored procs of varying length,...

sqldriver (10/6/2014)

---

If you're tasked with debugging/troubleshooting?

Specifically:

Assigning workable values to parameters/finding out where they're passed from or stored

Heavy use of temp tables/table variables/real tables that get truncated

Verifying results

Bonus points if it's...

Steve, perhaps you meant to say: "Azure first gave us (SQL...

webrunner (10/1/2014)

---

Interesting idea, thanks for the post.

I think human memory plus a written journal of some kind could handle a lot of the "non-quant" parts of life.

And about the quant...

Who knows, maybe your employer is already recording your every...