Gazareth (4/9/2014)

---

Assuming it's 4 octocore processors, take out 2 of them.

Edit: Sorry, that's a bit abrupt but it's the quickest way I can think of 🙂

Alternatively create a VM on...

Reboot?

Does sp_AddRemoteLogin '<Server>','<user>' solve the problem?

80?! On a 32 Gb box? Given how long it's taken your memory use to get up...

Welsh Corgi (4/4/2014)

---

I do not like triggers either. Since it only fired when an abject was created, Dropped or modified it was not firing off that much. But now I...

Sean Lange (4/4/2014)

---

OCTom (4/4/2014)

---

This is my take on LINQ to SQL. I have found that it does not handle large data sets well. It can be slow. And, because...

My 70+ severs and 800+ databases doesn't seem as bad now, even if it is only me, some servers over 15 years old and I still don't believe I know...

Oh, I just don't like triggers for that kind of thing, I'd even prefer a server side trace or Xe's EE's once I learn to use thamproperly (depending on version)...

Steve Jones - SSC Editor (3/31/2014)

---

... There are entirely too many jerks in this business that still think women aren't as competent, and don't deserve the same opportunities, regardless of...

I don't get pluralisation, certainly US based folk seem to be all for it, Brits less so. Perhaps it's due to a difference in the teaching of sets?

Here, I...

webrunner (3/31/2014)

---

Just want to say, your tag line is truly inspirational:

Simple but really, truer words were never...

ScottPletcher (3/30/2014)

---

andrew gothard (3/29/2014)

---

Simple arithmetic, if you have 8k pages, one row per page (and we know that it's going to be bigger than that), 12500 rows. Table Lock...

ChrisM@Work (3/28/2014)

---

WayneS (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these pieces of sh code and...

Grant Fritchey (3/27/2014)

---

jcrawf02 (3/27/2014)

---

We have a written test we use to weed out people who don't know the first thing about SQL (report writing position, not DBA stuff), it's pretty...

Luis Cazares (3/27/2014)

---

Welcome to another fun story sponsored by our "DBAs?".

Last night, about 1:30am someone decided it was a good time to disable xp_cmdshell. I'm sure that person read somewhere...