Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
2008-01-31
17,874 reads
Jeff Moden
- Interests: SQL. When Im not having fun with that, then SQL. ;-)
Performance Tuning: Concatenation Functions and Some Tuning Myths
Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.
2008-01-01
22,419 reads
Calculating Work Days
How many times have you wished that there was a parameter for DATEPART to allow you to check for workdays? While many of us may get stuck working 6 or 7 days a week, most of the world revolves on a 5 day work week. Monday through Friday. New author Jeff Moden brings us a method of easily calculating the number of workdays between any two dates.
2007-10-02 (first published: 2005-01-10)
74,147 reads
Difference between dates with thousands separators
This function calculates the time difference between 2 datetimes and displays the results in the following format:H,HHH,HHH:MM:SSThe return is a 15 character field that is left padded with spaces so that the field becomes right justified. This makes the colons line up for easy reading. Commas are automatically added as thousands separators as needed by […]
2004-03-14
430 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Gatot Subroto Hub.0813•7887•595
BCA KCP Gatot Subroto Hub.0813•7887•595.Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit...
BCA KCP Ruko Jababeka Call CSO; (+62 821°3111°179
Persimpangan Ruko Permata, Jl. Jababeka Raya Blok A2-3, Cikarang, Cikarang Sel., Kabupaten Bekasi, DKI...
BCA KCP Taman Sari Telpon/WA:.0851•8812•0691
BCA KCP Taman Sari Telpon/WA:.0851•8812•0691 Jl. Taman Sari Raya 47-47A, Taman Sari, Kec. Taman...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers