Simple interest in SQL Server is principal times rate times years divided by 100, and a T-SQL function returns it in one line. This post shows how an int return type drops the cents and what SCHEMABINDING changes. It measures the cost of a scalar function on 500,000 rows and ends with compound interest.
SQL SERVER – Difference Between Count and Count_Big
The difference between Count and COUNT_BIG includes result range and indexed-view requirements. Their row-counting rules are the same.
Bitwise Puzzle – SQL in Sixty Seconds 160
Many did not believe in the real world and based on the request, I have made the recent video on the same topic of the bitwise puzzle.
Line Endings: CHAR(13), CHAR(10) and Files From Other Systems
Why does a value that looks perfect fail a compare? Because of a line ending you cannot see. Five small demos make it visible.
SQL Puzzle – Unsolved CASE Expression
This Unsolved CASE puzzle asks you to predict its result before execution. The preceding bitwise challenge drew more than 125 responses.
SQL SERVER – Change Password at the First Login
MUST_CHANGE requires a SQL-authenticated login to change password at its first connection. Policy options and the client workflow must support it.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Optimize for AdHoc Queries reduces the first-use plan-cache footprint of ad hoc batches. A customer variable-query workload prompted testing.