It took more than a decade for SQL Server to gain across-the-board credibility in the enterprise relational database management system (RDBMS) market. It's taken much less time for SQL Server to achieve a leading position in the OLAP space. The...
COMPUTE and COMPUTE BY: an excellent alternative for detailed reporting
A by-the-book solution to a query-misfire mystery
I'm looking for shareware or an inexpensive tool that will let me maintain a SQL Server data dictionary. I've used sophisticated data-modeling tools that provide this functionality. However, I'm now in an organization that has many SQL Server...
Try these unorthodox but effective best practices on your next project