Jason A. Long (1/27/2016)

---

Just my 2 cents... If you want to prove anything to anybody, do it with the code...

Write a 2nd version of the proc (the way you believe...

Maybe it is not always as straightforward as picking up new skills and mental models. Sometimes a person may have to 'unlearn' old approaches, such as a procedurally-trained programmer coming...

Could there be a tendency, over time and in a successful devops team, for individuals to learn new skills from the 'other' side, to the detriment of learning more advanced...

Luis Cazares (9/28/2015)

---

Tavis Reddick (9/28/2015)

---

Could you expand on this please? We consider the stored procedures...

I agree, but since each row matches a physical asset...

For an in-house system with just over 10,000 records in the main entity table, I created a set of stored procedures of the following pattern:

For each entity (table, each with...

Apart from the previous suggestions and professional XML editing tools, if you have Microsoft InfoPath as part...

TomThomson (9/22/2014)

---

I've never worked in an association that didn't change its own code, and I've always advocated getting the latest tools, the newest possible technology, that was justifiable in business...

TomThomson (9/22/2014)

---

Tavis Reddick (9/22/2014)

---

Anyway, whenever I hear a DBA saying something like "I see no compelling reason to upgrade" my eyes turn red, smoke issues from my nostrils and I...

Will nobody think of the developers? 🙂

Seriously, if humankind had adopted "If it ain't broke, don't fix it" we'd still be living in caves and drinking out of puddles. Requirements...

While some of the examples linked to surely work, their presentation is a bit messy.

I knocked up this example based on some kind of solution I half remembered:

DECLARE @sortfruit BIT,...

I am not sure about the report, but the SQL Server Management Studio issue seems to be that you are saving the results (possibly as text or CSV), not the...

I think you can do this with the value function using XPath in SQL Server 2005 and later, although here I've used a Common Table Expression from 2008 to convert...

Gary Varga (8/18/2014)

---

Fair points but I cannot see anything that cannot be resolved by a combination of data cleansing and judicious use of TRIM and ISNULL/COALESCE (although the code might...

Gary Varga (8/18/2014)

---

Tavis Reddick (8/18/2014)

---

I would like to see a (T-)SQL function like normalize-space() from XPath, which I believe is slightly more useful than just TRIM, as it deals with...