Koen Verbeeck (6/13/2014)

People come up with the nonsense because other people - like Kimball - tell them to.

Kimball advocates that every surrogate key should be a meaninglessinteger (which is a...

Andrew Kernodle (6/12/2014)

---

Yep, we're in the same boat as far as compatibility and versions go. We're technically not supposed to be using 2008R2 by the vendor's contract (2008 is...

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This person also had the idea...

Jeff Moden (6/12/2014)

---

andrew gothard (6/12/2014)

---

Jeff Moden (6/6/2014)

---

A recent post just reminded me of one of my greatest pet peeves... people that who correct your English, spelling, or punctuation on forum...

Andrew Kernodle (6/9/2014)

---

andrew gothard (6/9/2014)

---

Andrew Kernodle (6/5/2014)

---

Argh. I too suffer under the burden of working with code littered with NOLOCK :(.

The vendor software we use at my current company...

Jeff Moden (6/6/2014)

---

A recent post just reminded me of one of my greatest pet peeves... people that who correct your English, spelling, or punctuation on forum posts. I've also...

Andrew Kernodle (6/5/2014)

---

Argh. I too suffer under the burden of working with code littered with NOLOCK :(.

The vendor software we use at my current company has NOLOCK all over...

I'd put SQL Profiler on it, briefly. See what's being thrown at SQL Server. See if you have a load of n+1 (and/or other antipatterns) implemented by a...

TomThomson (5/19/2014)

---

Steve Jones - SSC Editor (5/19/2014)

---

David Burrows (5/19/2014)

---

As...

Is there actually a performance issue here, or is this drive by management? Are you monitoring your PLE for example?

I think 98 is high, but I expect...

I'm not quite sure whether this is a cunning plan or just a bit arsey for a newbie. Push to get them a Pluralsight account on the company, put...

What blogs, forums, dev websites do you follow

Personally for things like this, I prefer a DateDim / Calendar table - apart from the fact this makes the SQL CLeaner, and you only have to do the calcs...

RobertC1 (5/3/2014)

---

I actually need more stuff like this. I have had a very hard time finding just basic information relating to DB/DW. My first assignment for a data warehousing class...

Jeremy Brown (5/1/2014)

---

Jack Corbett (4/3/2014)

---

Andrew,

Here's my explanation for pluralization. Because the table doesn't contain a car it contains cars. The row is a car the table...