Categories / sql-server-2008
Understanding Isolation Levels and Row Visibility in SQL Server: Avoiding Unexpected Behavior with SELECT COUNT(*) Statements
Understanding the Problem and Exploring Solutions: Tracking SQL Script Execution on SQL Server
Resolving Date Conversion Issues in Stored Procedures: Best Practices for Accurate Comparisons
Simulating Microsoft Excel's NETWORKDAYS Function: A Comprehensive Approach to Handling Weekends and Holidays