I'd throw in my vote for not loading up stored procs with business rules. Full disclosure: I have personally loaded up SPs with business logic many, many times and always...

Eirikur Eiriksson (11/20/2016)

---

Quick questions, can you use Table Variable Parameter? How wide are the largest values passed? How many values at...

Hard to improve on the great advice Grant and Brandie have provided but I thought I'd add some thoughts based on my experience getting my firm's databases under source control:

This...

Alright! Hope it worked out.

Phil Parkin (8/26/2016)

---

My go to is Wo Hop at 17 Mott Street (the downstairs...

Grant Fritchey (8/25/2016)

---

The Metropolitan Museum...

My organization just deployed a major release that contained changes to multiple databases. Since we considered this a risky release due to its scope we drilled not just the deploy...

Steve Jones - SSC Editor (6/10/2016)

This sounds like a data warehouse, which could be the best way to handle things, if the ad hoc querying is met well by indexing...

Brandie Tarvin (6/10/2016)

Thanks for the reply.

I wonder... Our reporting team has a database where they essentially flatten all our data into giant tables so their reports read quicker. Would this...

Brandie Tarvin (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize that there...