A CTE is a just a derived table. It's one with some unique properties in that you can refer to it more than once in the following query, but it's...

Evil Kraig F (4/6/2012)

---

I am all for the concept of versioning. However, after reading through this, I find noone's addressed a few key issues that I have with traditional...

TravisDBA (4/5/2012)

---

Any time you want to see the warts & all presentation, come watch mine. I don't hold back. We have a ton of advantages over Visual Studio. They have...

If your server is so busy that a well-structured server-side trace will bring it down, you have some serious issues. While extended events (introduced in SQL Server 2008) are much...

They are just calculations. Nothing more. They're based on statistics, so the more accurate your statistics are, the more accurate those numbers are likely to be. However, because some things...

Lynn Pettis (4/5/2012)

---

Grant Fritchey (4/5/2012)

---

Look at it as a complement. To many people, we're the SQL...

John Dempsey (4/5/2012)

---

Grant Fritchey (4/5/2012)

---

Any time you want to see the warts & all presentation, come watch mine. I don't hold back. We have a ton of advantages over Visual...

Steve Jones - SSC Editor (4/5/2012)

---

Eric M Russell (4/5/2012)

---

I use TFS, but up until about three years ago, I was still using Visual Source Safe 6.0. It was good enough...

Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty...

TravisDBA (4/5/2012)

---

Most shops that I have been in the past are already using Visual SourceSafe (VSS). So, this is kind of old news for me, but as someone already stated...

Steve Jones - SSC Editor (4/5/2012)

---

chrisn-585491 (4/5/2012)

---

Steve,

I could be cynical, but the number of source/version control editiorials and articles on SQLServerCentral and SimpleTalk has increased greatly since RedGate started making...

steve.hansen (4/5/2012)

---

This is an excellent (and timely) topic. We're pondering this same question right now, but we have a challenge that we haven't quite figured out how to overcome. Any...

Gary Varga (4/5/2012)

---

chrisn-585491 (4/5/2012)

---

Steve,

I could be cynical, but the number of source/version control editiorials and articles on SQLServerCentral and SimpleTalk has increased greatly since RedGate started making SQL Source Control....

chrisn-585491 (4/5/2012)

---

Steve,

I could be cynical, but the number of source/version control editiorials and articles on SQLServerCentral and SimpleTalk has increased greatly since RedGate started making SQL Source Control. The fact...

G Bryant McClellan (4/5/2012)

---

Spot-on, Grant, as usual. Working with earlier versions of SQL and VSS was a true pain...until VSS saved your a$$ because you could bring back a prior...