CELKO (12/2/2014)

---

I am thinking about printing the "SQL Smells" pdf that Phil Factor just posted for Red Gate as...

A couple of issues:

1. salary changes over time. At every least you'd have a to/from, and the relationship would be employee (1-->N) salary .

2. you'd probably want...

Given where you're having the deductions table, I am assuming those are actually the default deductions that might apply on a paycheck by paycheck basis.

Assuming that's true - I'd envision...

marcia.j.wilson (12/2/2014)

---

GeorgeCopeland (12/2/2014)

---

marcia.j.wilson (12/2/2014)

---

Like this e-mail that I got the day before Thanksgiving from someone who knew I was going to be off for a week in this time period:...

I think I'd answer the question with a question: by which standard are you measuring "best"?

My most effective project was arguably also one of the ugliest ones I was...

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/25/2014)

---

Ed Wagner (11/25/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Evil Kraig F (11/24/2014)

---

Jeff Moden (11/24/2014)

---

Eirikur Eiriksson (11/24/2014)

---

Just a quick question to "the thread", am I missing something or is...

You know - it would be REALLy nice if we...

As both a data professional and an MBA, I will park my other comments about broad inflammatory comments.

What I will add to the conversation is it: it...

Steve Jones - SSC Editor (11/24/2014)

---

Iwas Bornready (11/24/2014)

---

I'm a little confused. If you are talking about changes to production outside of a normal release, then this certainly is high risk,...

The error she's describing is the one stating that CREATE PROCEDURE needs to be the first in the batch.

WantedButter -

Votre error consiste de n'avoir pas separe the CREATE PROCEDURE...

ebowditch (11/21/2014)

---

thanks, that is the top level answer, but that doesn't explain why changing the underlying SQL data type from nvarchar(max) (which was overkill for a 2-character field)

to text, or...

ebowditch (11/20/2014)

---

Hi everyone - I realize this is probably more of an Access problem than a SQL Server problem, and have posted on Access forums , but wondered if anyone...

NJDave (11/20/2014)

---

There is a seperate dev & production area. The login is for an application using SQL Server authentication in a web.config file for the application to connect.

Thank you for...

Jeff Moden (11/20/2014)

---

Sounds mean but my suggestion is that anyone that doesn't...

Sean Lange (11/19/2014)

---

Jeff Moden (11/19/2014)

---

I don't believe "the kludge" allows you to pass parameters to a stored procedure in a function. To do that, I believe that you still...