If you want no-fuss upgrades to the latest service pack and bug fixes, then perhaps SQL Azure is the way to go.

-- query allocated temp tables with record count and size.

use tempdb;

select o.type_desc

, substring(o.name,1,charindex('__',o.name)+1)+right(o.name,12) table_shortname

, si.name index_name

, case si.index_id when 0 then 'HEAP' when 1 then 'CLUSTERED' else 'NONCLUSTERED' end index_type

,...

We've already seen SQL Server move to a pace that releases new versions every two years and bimonthly patches to fix issues. Imagine that we could get patches even more...

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...