Matt Miller (9/22/2008)

---

Agreed. Still - my biggest objection to it is the separation of duties issue. Since we're back to putting what essentially boils down to dynamic SQL...

cs_troyk (9/22/2008)

---

In addition to the automatic parameterization issues mentioned earlier, I have seen cases where the SQL emitted by a LINQ expression contains a cartesian product (CROSS JOIN) where it's...

I actually didn't mention numeric types in the feedback item on purpose, because there are some deeper issues there and the fix isn't quite as straightforward. My suggested fix...

Yes, EASY. And not at all suboptimal, either. Sorry, but I don't buy "if it were easy they already would have done it." I suspect the truth...

developmentalmadness (9/19/2008)

---

The only shortcoming here with LINQ is they didn't go quite far enough, because the don't properly parameterize strings and numeric (decimal etc) types which have a size and...

PKs and UNIQUE constraints are backed by indexes, so you can create indexes, as long as they're unique. Need a non-unique index? Add an identity column and use...

Jeff Moden (7/18/2008)

---

Why? Correlated subqueries are a form of RBAR and can actually be...

Viswanath S. Dhara (7/17/2008)

---

Thanks for the Article Roi. There is one more thing you forgot to mention. You can't write a correlated subquery on a table varable where as you...

A couple of small corrections:

A) INSERT EXEC actually does work on table variables in 2005 and 2008.

B) You can create nonclustered indexes on table variables, in the form of...

One big difference not mentioned in the article, but which influences the choice of when to use which, is that autostats do not apply to table variables, but do apply...

You add it to the SqlFunctionAttribute in the C# code:

public partial class CTSStoredProcs

{

[Microsoft.SqlServer.Server.SqlFunction(IsDeterministic=true, IsPrecise=true)]

public static SqlBoolean RegExValidate(

SqlString expressionToValidate, SqlString regularExpression)

{

...

Looks good, but you might want to apply the IsDeterministic and IsPrecise options on the SqlFunctionAttribute so that you can use your function in a wider variety of scenarios (such...

billross (6/22/2008)

---

I realize that the Sql Server Project Template is only available in the Professional edition of VS but wouldn't it be possible to create a CLR proc by just...

Absolutely! And may I also suggest...

"Pro SQL Server 2005"

by Tom Rizzo,...

don_goodman (1/25/2008)

---

What is not understood about interpreted code be it T-SQL, CLR, JAVA or VB3 code? When you add 2 layers of interpretation to a piece of code, it will...