If anyone else was wondering - nah. no difference

Ed Wagner (2/2/2015)

---

Brandie Tarvin (2/2/2015)

---

TomThomson (1/31/2015)

---

GilaMonster (1/29/2015)

---

Brandie Tarvin (1/29/2015)

---

Here's one for everyone. Does anyone have an environment where Enterprise is the production edition and Standard is the Dev / Test...

Jeff Moden (2/1/2015)

---

Michael Valentine Jones (2/1/2015)

---

I worked at a place where consultants came up with a design for a high volume OLTP application that would completely replace SQL Server with...

I've heard that suggested, and received enthusiastically. In all seriousness. ... "Over *your* dead...

Kimberly Tripp suggests in this blog that by default all files zero out a file allocation request's allocated space for all files, it's not a SQL Server thing per-se; http://www.sqlskills.com/blogs/kimberly/instant-initialization-what-why-and-how/...

Eric M Russell (1/21/2015)

---

ProductID, ProductId, and product_id are all respectable options, so long as it's done consistently.

However, I would take issue with ID by itself, on every table. Anytime...

Ed Wagner (1/22/2015)

---

I hope it wasn't good coffee that you spilled. Oh yeah, and that your keyboard is okay. 😀 ...

Sioban Krzywicki (1/21/2015)

---

Brandie Tarvin (1/21/2015)

---

Sioban Krzywicki (1/21/2015)

---

Brandie Tarvin (1/21/2015)

---

Unfortunately...

Koen Verbeeck (1/21/2015)

---

Stefan Krzywicki (1/21/2015)

---

I see how to change my name on my account and I'll go do that here in a minute. I'm just not sure it'll cascade to...

One tool I would recommend running against your instances to quickly highlight a number of key issues is sp_Blitz http://www.brentozar.com/blitz/

This highlights issues such as backups not taken recently, incorrect configuration...

Stefan Krzywicki (12/22/2014)

---

Steve Thompson-454462 (12/22/2014)

---

Stefan Krzywicki (12/22/2014)

---

Steve Thompson-454462 (12/22/2014)

---

---

Brandie Tarvin (12/16/2014)

---

But still... To my mind, since I'm already fixing one part of the package, why shouldn't I proactively fix the...

Ed Wagner (12/18/2014)

---

Greg Edwards-268690 (12/18/2014)

---

Brandie Tarvin (12/18/2014)

---

So, I'm curious. Anyone have any major projects that people want before the end of the year?

We have a business user that keeps asking...

lshanahan (12/15/2014)

---

SSMS for 2005 doesn't support it directly, but it's near-trivial to set up source control using...

Good god yes. Working with TFS and SSMS is just hideous beyond belief

Brandie Tarvin (12/17/2014)

---

Brandie Tarvin (12/16/2014)

---

WHOO! #HappySnoopyDance

I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12...