Double Counting and Sign Reversals
Make the ad-hoc analysis of identifying potentially double-counted or sign-reversed Accounting transactions simple and painless.
2013-01-07
4,009 reads
Bin packing
Bin Packing Problems: The SQL
The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world applications. It isn't that easy to come up with a practical, set oriented solution in SQL that gives a near-optimal result.
2012-04-06
2,537 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How Many Rows Remain?
Comments posted to this topic are about the item How Many Rows Remain?
Compatibility Level Confidence
Comments posted to this topic are about the item Compatibility Level Confidence
The backup set holds a backup of a database other than the existing 'MyDB'
I'm trying to restore a database from our production server to my local machine...
Ask SSC