June 12, 2007 - SQL Authority with Pinal Dave

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes

June 12, 2007

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

While searching WIKI I came across this oracle WIKI. I found this very funny. I have taken few quotes from this site. There are lot more stuff there. The degree of normality in a database is inversely proportional to that of its DBA. Program complexity grows until it exceeds the…

SQL SERVER – LEN and DATALENGTH of NULL Simple Example

June 12, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Function, SQL NULL, SQL Scripts

Simple but interesting – In recent survey I found that many developers making this generic mistake. I have seen following code in periodic code review. (The code below is not actual code, it is simple sample code) DECLARE @MyVar VARCHAR(10) SET @MyVar = NULL IF (LEN(@MyVar) = 0) … I…