Pinal Dave

Recent Blog Comments By Pinal Dave

• Datasource Names For All The Database Tags Within CFTRANSACTION Must Be The Same

  Posted on Feb 8, 2008 at 3:11 AM

  Great Post! The workaround for the problem of CFTRANSACTION with different data source we have used earlier was. Use the same datasource but prefix the table with desired database. Following solution is not good and many times gives unexpected results. Not RECOMMENDED. I am listing it here for ... read more »

• Thanks Adobe!

  Posted on Jan 21, 2008 at 1:43 AM

  Hey Ben, Wonderful wonderful. Actually your services to community are well noted by Adobe, you very well deserve this honor. Congratulations congratulations!!!... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Sep 5, 2007 at 10:51 AM

  Ben, I am sure my blog readers will find it useful. http://blog.sqlauthority.com/2007/09/05/sqlauthority-news-interesting-read-using-a-sql-join-in-a-sql-updatedelete-statement-ben-nadel/ Regards, Pinal... read more »

• Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)

  Posted on Sep 4, 2007 at 3:22 PM

  Ben, Thanks for posting this article. I glad that you find it useful. I think my blog reader will find this details very useful as I never wrote about this on my own blog. Tomorrow I will write down summary and point to this two wonderful (and well explained) post you have. I like your examples. ... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Sep 4, 2007 at 10:46 AM

  Ben, As general rule you can write all your UPDATE, DELETE query the same way you can write SELECT Query. They have same structure of syntax. You could also DELETE using JOIN as well. Try following query you will love it. DELETE tableName FROM tableName tn INNER JOIN JoinedTable jn ON jn.col = tn.... read more »

• Using CASE Statements In A SQL UPDATE Query

  Posted on Aug 30, 2007 at 7:26 PM

  SQL can do many magical stuff. I use SQL for all the business logic. I use ColdFusion for presentation. CASE statement can be effectively used in ORDER BY : http://blog.sqlauthority.com/2007/07/17/sql-server-case-statement-in-order-by-clause-order-by-using-variable/ People do create whole anoth... read more »

• Ask Ben: Protecting Database Table Names In ColdFusion CFQuery

  Posted on Jul 26, 2007 at 4:05 PM

  Ben, Good post. That is very true that if we specify explicit names of tables it is the safest. Let us see with real example that SQL can do the table exist check how application help database with the task. We are using application where we create lots of dynamically created tables, all are real... read more »

• Ask Ben: Getting the Previous Day In ColdFusion, Excluding Saturday And Sunday

  Posted on Jul 23, 2007 at 4:02 PM

  Hi Ben, Not as simple as your solution. However, I use the similar function in SQL. I dig it up after I read your blog. http://blog.sqlauthority.com/2007/07/23/sql-server-udf-function-to-get-previous-and-next-work-day-exclude-saturday-and-sunday/ Good post Ben! Pinal Dave... read more »

• I Just Felt The Awesome Power Of SQL Table Indexing (Thanks Nate Nelson!)

  Posted on Jul 13, 2007 at 2:57 AM

  I recommend http://blog.sqlauthority.com/2007/07/05/sql-server-2005-best-practices-analyzer-tutorial-sample-example Thanks Tony. Pinal Dave... read more »

• I Just Felt The Awesome Power Of SQL Table Indexing (Thanks Nate Nelson!)

  Posted on Jul 12, 2007 at 9:06 PM

  Hi Ben, First congratulations. Indexing is very important. In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key columns to the leaf level of the non-clustered index. Non-key columns, can help to create cover indexes.By including non-key columns, you can crea... read more »