Lynn Pettis (11/16/2015)

---

Why go to all that trouble. Dynamically create the entire SQL query in the application and call this proc:

create procedure dbo.QueryDB (

@SQLCmd nvarchar(max)

)

as

set...

WayneS (11/16/2015)

---

My scary story when working with the gov't.

Software contract awarded, specified that all data access has to go through stored procedures.

They sent to...

Jeff Moden (11/14/2015)

---

To explain some of my extreme frustration in the "developers" that I've been interviewing over the last decade, the following blog post is a great example of the...

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the same table aliases...

Well, people calling themselves "software engineers" or "computer engineers" are mostly (a least in the UK - those are not protected titles in the UK) completely unqualified -...

skeleton567 (11/11/2015)

---

I'm fairly sure the city has traffic engineers with advanced degrees analyzing data and designing these projects and spending this money with disastrous results because they have all the...

djj (11/11/2015)

---

Gates

Phil Factor (11/10/2015)

---

@TomThomson

Is this the SQL Code Smells ebook you're referring to? I wasn't sure, since there were 120 SQL Code Smells itemised, not 27. If it is mine, I'll...

Got it shan't ask any more question, take this to mean support questions too, so will try google in future! Thought this was a supportive community. apparently not! Sorry it...

IanSinclair (11/9/2015)

---

From a purely ENGLISH Rugby Union perspective - what the H£!! is a 'TRY'.

Everyone knows that the correct way to play the game is to muck about in...

Eirikur Eiriksson (11/6/2015)

---

On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?

Three options given

1) To get the current time (wrong)

2) You don't (correct)

3) Time for...

SQLRNNR (11/6/2015)

---

Luis Cazares (11/6/2015)

---

Once I interviewed someone that claimed to have experience on Oracle but not much on SQL Server. I told that person to answer based on Oracle (which...

I guess that depends on what you mean by (a) "double negation" and (b) "current standard...

Hugo Kornelis (11/3/2015)[hrSteve, if you see this - any chance that you can get this fixed? I don't think it will cause people to miss the question, but it does...

Another excellent question. Will there be a third in the series?