PiMané (9/21/2012)

---

Roland Alexander STL (9/21/2012)

---

Which is the point of using local variables, since it will force a new plan each time the query is run. Of course, this is also...

PiMané (9/21/2012)

---

So it depends mostly on the data in the tables.

Being a "generic" software spread across the country we can have databases with customers mainly from one state (where...

That depends on any number of factors. Parameter sniffing only presents a problem if there are multiple possible execution plans, some of which may be suboptimal for the parameter value...

You can also use local variables for intermediaries. Assign your incoming parameters to local variables, then use the local variables in the predicates.

tsmall 52653 (8/16/2012)

---

Code reviews are interesting. In my experience, people that are defensive can often be "turned around" in their thinking if they can be made to realise that the...

One of the hardest things to learn is to separate your ideas from yourself, and to understand that criticizing your ideas is not the same as criticizing you personally. I...

An overflow error indicates that the number you're trying to stuff into a column or variable is too large for the column or variable's data type. For example:

DECLARE @tiny tinyint;

SET...

There's no reason you can't combine DISTINCT and SUM. I can't recommend specifics, since you didn't post your SQL, but there is no reason the two shouldn't work together. Post...

Trick questions accomplish little other than to show off the cleverness of the author. How many of us would write legitimate code where we assign variables like this? I am...

As a database developer for an online trading firm, I went through a total of four technical interviews, but took no test. The technical interviews - which were conducted...