April 2010

Microsoft continued their support of PHP by releasing a Community Technology Preview for the SQL Server Driver for PHP 2.0.  With this release PHP developer can use PHP Data Objects with the SQL Server driver!  This will serve to reduce the complexity of targeting multiple databases on the back end.  As I’ve noticed before, Business…

Read More Microsoft Continues to Support PHP

I’d like to introduce you to the idea that you can replace an equal sub query with an exists sub query. Doing this can change a seek operation to a scan operation. This usually results in a faster query, with fewer resources used. Check out this example using the adventureworks database. USE AdventureWorks GO –…

Read More Equals Sub Queries Versus Exists Sub Queries