- Independent ConsultantSoftware Engineer, 1990 - present
- Florida Institute of TechnologyPhysics, 1984 - 1986
- University of Minnesota / Institute of TechnologyComputer Science, 1986 - 1990
Avoid SQL Server functions in the WHERE clause for Performance
SQL Server offers many handy functions that can be used either in your SELECT clause or in your WHERE clause. For the most part these functi
GROUPING SETS in SQL Server 2008 - Craig Freedman's SQL Server Blog - Si...
In my last two posts, I gave examples of aggregation WITH ROLLUP and CUBE. SQL Server 2008 continues to support this syntax, but also introd