A couple good quotes here!

"We just need to be careful of using the crankiness appropriately so we're not seen as blockers, but enablers." - Grant

I love this thought!  Words to...

Ha!  I was exactly the same as a child!  This article rings true on every point.  I have such a hard time NOT fixing things that could use improvement.  I...

I SO AGREE with the learning aspect.
I have experienced so many software/hardware issues that were out of my control, and when it was fixed, I never heard back what...

I agree about the issue being datatype precedence.  Here's a useful list:
https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-type-precedence-transact-sql?view=sql-server-2017

Geology! I was an exploration geologist way back (before the price of oil dropped below $12/barrel!!!!!)

Since then, they have gone digital. I'd love to work with all that...

Ed Wagner (10/22/2014)

---

Toreador (10/22/2014)

---

Sean Lange (10/21/2014)

---

A cte does NOT require it to start with a semicolon. The semicolon is statement terminator not a statement beginninator (nod to Lynn Pettis for...

Very good question. Thank you!

I like this...

a.guillaume (3/25/2014)

---

I'm ok with Darren

To understand, I tried this 3 SQL in a lot and obtain this results

set statistics io on

----- SQL1 ------

SELECT .[ID],.[Item], .[Price], .[OrderDate], .[Units], .[ShipmentDate]

FROM [Source]...

Thank you for demonstrating a simple solution to a common problem.

Luis Cazares (8/6/2013)

---

The forums part is mainly useless for the purpose that is presented (Database Pros Who Need Your Help!) because most topics are already solved.

There could be some kind...

I also subscribe to a web designer newsletter. I totally disagree with articles that propose updating logos, icons, etc. just to make them more "modern".

Responsive design includes recognizing the...

BarneyL (6/28/2013)

---

While I wouldn't trust the results without checking them by eye (or expect all cases to be found) DIFFERENCE can be used as a quick and dirty way of...

nycdotnet (6/18/2013)

---

Interesting article. Regarding the paradox of semicolons on CTEs - the rule is "the statement before the CTE has to end with a semicolon". The reason is...

Loved the fun question! Thanks!

Carlo:

Carlo Romagnano (5/27/2013)

---

+1

In 80's, on mainfraim I placed the prompt with:

"ADVANCED COBOL '85. COMPILING...