K. Brian Kelley (8/12/2014)

---

patrickmcginnis59 10839 (8/12/2014)

---

I know I'm a little slow, but I'm having some difficulty identifying venoym's mistake, from what I've read he's actually talking about required and recommended...

K. Brian Kelley (8/11/2014)

---

venoym (8/11/2014)

---

I have to question the "myth" of the Air-Gap that is referenced. A proper Air-Gap or Data Diode for SCADA systems provides a level of...

I have to question the "myth" of the Air-Gap that is referenced. A proper Air-Gap or Data Diode for SCADA systems provides a level of protection that cannot be...

I would think that the below is simply to say "You can't reproduce it in an article or sell it as it is." If you read 4.2 closely the...

Without knowing a bit more, this is the best I can do to give you a starting place. This puts a "row number" on each special order, then joins...

GilaMonster (5/6/2014)

---

No, it was not me that pointed it out, because for a page split to occur, there must be an insert/update operation occurring. SQL doesn't randomly, when it's bored,...

Stefan Krzywicki (5/6/2014)

---

I thought I remembered a discussion here months ago about NOLOCK possibly returning bad data even when there's no changed to the table being queried, but now I...

Guess I'll be the first to say that the "twist" was not appropriate. The question was titled and about the TRY...CATCH structure in SQL Server, the string length was...

Not every property is retained though... Service Broker Enabled will always be false when restoring or attaching a database. Service Broker GUID will be retained though.

I'm going to be the lone guy here and go out on a limb. First, in a new database or even a developing database from a business perspective, yes...

I find the last case to be confusing... soemthing before 6/4/2009 or after 5/4/2014 gets the same 2008 trans date?

Anyway, you can add a table with a start and stop...

Revenant (1/21/2014)

---

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

---

Revenant (1/21/2014)

---

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

---

Ed Wagner (1/15/2014)

---

We've never met, but I understand where you're coming from with the inability to sit still....

Overall a good question.

The answer needs some work though. The declares used make the assumption that you will only have a single value for the @XXX, @YYY, @ZZZZ, etc....

L' Eomot Inversé (11/12/2013)

---

wolfkillj (11/12/2013)

---

My new blog post on appropriate data types for storing latitude and longitude coordinates is up.

Thanks for indulging me in a little bit of self-promotion....

Technically both the "correct" answer and the answer marked "No rows returned, conversion error on query 3" are correct. It depends on how the Query Analyzer and query engine...