Jeff Moden (2/24/2015)

---

Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks...

Eirikur Eiriksson (2/16/2015)

---

TomThomson (2/16/2015)

---

ChrisM@Work (2/16/2015)

---

Stop digging, Tom! For goodness' sake, you're coming across as a cranky old fella with a short fuse. This is not what we are used...

Here in southern NH we've probably gotten over 40 inches of snow in the last 2.5-3 weeks with another 3-6 inches coming Thursday/Friday. Currently probably only about 36 inches...

I'm going to be maybe a bit contrary, but maybe not. Being a person of less than average height I tend to notice height when I go into a...

Brandie Tarvin (1/29/2015)

---

It's not just posted questions, as I found out yesterday. Questions around the water cooler (not this one) are also getting ... awkward.

Here's one for everyone. Does anyone...

Here in NH we have a little lull going on, but this is what my driveway looks like:

Unfortunately the truck with the plow attached isn't running safely, so I have...

That's awesome. Of course, last night I told my wife, "make sure you fill the gas tank and...

I use ID for surrogate keys using the Identity Property. If the column is not using the identity property I would be more likely to use Id. Since...

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200 parameters...

Yeah, that would work and is probably better.

In a Derived Column transformation you can do this:

LEN(Docket) < 5 ? REPLICATE("0",5 - LEN(Docket)) + Docket : Docket

This basically says, if the length of Docket is less than 5...

Steve Jones - SSC Editor (1/21/2015)

---

So....

What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday night party.

Need to get...

Good article Andy. My only nitpick, is that while you can't use foreign keys to enforce referential integrity when using an additional database, technically you could create triggers in...

Jeff Moden (1/19/2015)

---

Jack Corbett (1/19/2015)

---

Jeff Moden (1/18/2015)

---

Grant Fritchey (1/18/2015)

---

WayneS (1/18/2015)

---

I'm curious...

How many folks have a home lab set up with servers?

How many folks just use virtual machines...

Jeff Moden (1/18/2015)

---

Grant Fritchey (1/18/2015)

---

WayneS (1/18/2015)

---

I'm curious...

How many folks have a home lab set up with servers?

How many folks just use virtual machines on a computer (be it laptop,...