Geeks With Blogs

News



AJ Warnock This Page Left intentionally Blank February 2006 Entries
Its a Disposable World...
While this is pretty old hat stuff, it appears that the statement “common sense is not always common practice” continues to hold true. Recently while researching some code, I found several instances where someone neglected to call the Dispose() method on a SqlCommand object. It appears that they believe that calling the Dispose() method on the connection actually called the method on the associated command. Some developers believe that the disposing of the associated connection will dispose ......

Posted On Tuesday, February 14, 2006 8:55 AM

Joining User-defined Functions in TSQL
The best made plans. Oh well, it is our busiest time of the year… FYI, you may want to be careful when using two user defined functions in TSQL that return tables and doing a join. You may think that they were going to be processed like any other join; however, in a recent assignment I tried to simplify and extend a complex query by creating a single table (from a complex join) within a UDF and joining it with another UDF (created from another complex join). What happened was quite concerning. ......

Posted On Friday, February 3, 2006 1:13 PM

Copyright © AJ Warnock | Powered by: GeeksWithBlogs.net