I saw your recent tip on Calculating Mathematical Values in SQL Server and have some related issues as I try to round values in my application. My users and me have a difference of opinion on some of the calculations in our reporting applications. All of the code is in T-SQL, but I think the reporting issues are related to data types and rounding down or rounding up rules. Do you have any insight into these issues? I would like to see some examples with a variety of coding options.

Statistical Protection

by Steve Jones

SQLServerCentral.com

Editorial

Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.

Partitioning in SQL Server - Part 2

by Additional Articles

Database Journal

Paritioning

Arshad Ali examines the different concepts of partitioning in SQL Server 2012 and provides a step-by-step guide on creating a partition table/index.

Double Counting and Sign Reversals

by Dwain Camps

SQLServerCentral.com

Bin packing

Make the ad-hoc analysis of identifying potentially double-counted or sign-reversed Accounting transactions simple and painless.

The $50,000 Laptop

by Steve Jones

SQLServerCentral.com

Editorial

The average value of a lost laptop has been found to be much more than you might expect. Steve Jones talks about a recent study.

What Counts for a DBA: Amnesia

by drsql@hotmail.com

SQLServerCentral.com

Editorial

Louis Davidson explains why DBAs often need a healthy dose of selective, enforced amnesia about the pain of previous failures.

How Come the Hourglass? Why Database Applications Slow Down

by Additional Articles

SimpleTalk

Performance Tuning

It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It could be, but there are other suspects that should be considered. Feodor Georgiev describes where, in the long route, to and fro', that a data request makes before returning, that things can get snarled up.

DR Prep

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones asks how you might handle DR preparation or process differently in the new year.

Row Sorting in SQL

by Additional Articles

SimpleTalk

Row sorting

It should be easy to model a game of poker in SQL. The problem is, however, that you need to model a permutation from a set of elements. Joe Celko argues that using a group of columns to do this isn't necessarily a violation of 1NF, since a permutation is atomic. Then comes the second problem: how would you sort such a column-base permutation in order? Sorting columns in SQL?

All Flash

by Steve Jones

SQLServerCentral.com

Editorial

Should you think about using SSD storage in your SQL Server databases? Steve Jones thinks this might be something you should consider.

SQL Server Rounding Functions - Round, Ceiling and Floor

Statistical Protection

Partitioning in SQL Server - Part 2

Double Counting and Sign Reversals

The $50,000 Laptop

What Counts for a DBA: Amnesia

How Come the Hourglass? Why Database Applications Slow Down

DR Prep

Row Sorting in SQL

All Flash

Blogs

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

A Fabric solution can be very cost effective

Track SQL Server Configuration Changes Using the Error Log

Forums

Designing SQL Server ETL Pipelines That Don't Break at Scale

Detecting Deadlocks Quickly

SQL Server Showing Out of Space But Plenty of Drive Space

Question of the Day

Detecting Deadlocks Quickly