From what I've seen, restraunts with multiple TV sets (ie: sports bars) tend to have a higher calorie fried menu, and even folks who normally eat healthy will occasionally go...

BWFC (10/10/2014)

---

...

But it's in the Daily Mail, it must be true. Are you suggesting that what they publish may not be entirely accurate. My whole belief system and...

Speaking of research studies with questionable cause and effect, I see this type of thing all the time on the morning news shows. Below is a good example.

How where you...

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?