Jeff Moden (3/26/2014)

---

I guess I wouldn't say such a thing... I worked in Oracle for...

yuvipoy (3/27/2014)

---

andrew gothard (3/27/2014)

Oh - and if you've made the mistake of update / delete cascade being set to on, do not delete from the parent table. Use an...

ScottPletcher (3/28/2014)

---

andrew gothard (3/27/2014)

---

ScottPletcher (3/27/2014)

---

andrew gothard (3/27/2014)

---

ScottPletcher (3/27/2014)

---

yuvipoy (3/27/2014)

---

Sean Lange (3/27/2014)

---

True. I have worked with this OP on several threads and the problem is performance because they have several related...

@SQLFRNDZ (3/27/2014)

---

andrew gothard (3/27/2014)

---

@SQLFRNDZ (3/27/2014)

---

Hi All,

I have a odd scenario, For example.

Say database is Full Recovery Model, No Log backups Configured , Then Obviously TLog grows till...

@SQLFRNDZ (3/27/2014)

---

Hi All,

I have a odd scenario, For example.

Say database is Full Recovery Model, No Log backups Configured , Then Obviously TLog grows till disk space. Here...

andrew gothard (3/27/2014)

---

ScottPletcher (3/27/2014)

---

andrew gothard (3/27/2014)

---

ScottPletcher (3/27/2014)

---

yuvipoy (3/27/2014)

---

Sean Lange (3/27/2014)

---

True. I have worked with this OP on several threads and the problem is performance because they have several related tables...

ScottPletcher (3/27/2014)

---

andrew gothard (3/27/2014)

---

ScottPletcher (3/27/2014)

---

yuvipoy (3/27/2014)

---

Sean Lange (3/27/2014)

---

True. I have worked with this OP on several threads and the problem is performance because they have several related tables and the...

ScottPletcher (3/27/2014)

---

yuvipoy (3/27/2014)

---

Sean Lange (3/27/2014)

---

True. I have worked with this OP on several threads and the problem is performance because they have several related tables and the primary key (and...

If they think THAT is a good idea, that's a "Thank...

Jeff Moden (11/11/2009)

---

Fatal Exception Error (11/11/2009)

---

Jeff Moden (11/9/2009)

---

Let me summarize my thoughts... every minute you spend testing during development will save an equal number of hours in post implementation debugging......

I'd still go for a DateDim / Calendar table. Firstly, it means you only have to run your calculations once, and the table is also unaffected by changes to...

I would suggest;

Get a coffee. Coffee's good.

Do your daily routine checks just in case there's actually something wrong. Rather than SQL Server doing exactly what it's supposed to...

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

---

Had an interesting question from my kid last night. He is studying for a GIS test and was confused about the phases of database design

-...

Luis Cazares (3/16/2014)

---

andrew gothard (3/16/2014)

---

GilaMonster (3/16/2014)

---

I have two clients where I'm writing up a performance report which includes an entire section on their use of NoLock. Going to be an...

SQLRNNR (3/17/2014)

---

andrew gothard (3/16/2014)

---

GilaMonster (3/16/2014)

---

I have two clients where I'm writing up a performance report which includes an entire section on their use of NoLock. Going to be an interesting...