halifaxdal (9/5/2014)

---

Nice article and nice experiment, but unfortunately from security perspective I am not able to even give the needed SQL# a try simply because SQL# has lots highly restricted...

OLD School (compliments of Stack Overflow forum) for less fortunate users who do not allow to have a CLR-enabled SQL Server:

http://stackoverflow.com/questions/15523789/sql-email-verification-function-using-regex

Solution is based on legacy COM VBScript...

Deprecated SET FMTONLY statement did the trick

http://msdn.microsoft.com/en-us/library/ms173839.aspx

@tom - You answered your question: "if triggers are properly written".

I had to deal with nested loops instead of set-oriented implementation in triggers 🙂

Agree for 100% in terms of stored procedure - that is ultimately "last line of defense" 🙂

You would not scare me with Access linked tables to SQL Server -apparently this...

If I am not mistaken, it works only when View built on top of a SINGLE table and includes table's PK column(s)?

Greg, thank you for article.

Could you please refrain from providing SELECT * FROM table example - it's a proverbial ticking "time bomb".

Changes in table schema like creating new or...

Despite all of my protests I have to implement EAV in my current project because some genius :alien: "discovered" this anti-pattern. I do not need to do any aggregation and...

Thanks Luis, I hate to bring another dimension to performance test but I am using TABLE variable, not temporary table. 😉

Thanks Jeff - I did CROSSTAB implementation before SQL 2005.

For my current project I stick with PIVOT (I have less than 10K rows). 😉

Luis, if we talking about performance difference did you try to benchmark your approach vs PIVOT?

IFAIK PIVOT became part of built-in SQL Server functionality since SQL Server 2005. 😉

I hope that everybody knows what RBAR stands for.

Our off-shore team managed to invent CBAC: column behind agonizing column; Well not quite - for a record with n columns...

There were couple of books about SQL Database refactoring.

Anybody interested in anti-patterns, i.e. what to avoid by all means 🙂

FYI QUOTENAME function Return Types nvarchar(258), so be aware

Microsoft stopped support of SQL Server 2008R2 this month.

So the only survived versions are SQL 2012 and SQL 2014 😎