Comparing values across many columns is a common chore. Here is how the MySQL LEAST and GREATEST comparison operators find the smallest and largest value.
SELECT One by Two – Why Does SELECT 1/2 Returns 0 – Interview Question of the Week #067
Why does SELECT 1/2 return 0 in SQL Server and not 0.5? Beginners often think it is a bug. Here is the SELECT One by Two answer, explained simply.
SQL SERVER – Identifying Page Types
During a consulting session on SQL Server building blocks, a DBA asked me about pages. Here is how to identify Page Types in your database, back to basics.
MySQL – FOUND_ROWS() Function for Total Number of Rows Affected
In SQL Server you get the number of rows affected with @@ROWCOUNT. In MySQL, you can find the total number of rows with FOUND_ROWS().
SQL SERVER – InMemory OLTP Migration Assistant Powershell Script
Is your application ready for In-Memory tables? A client upgrading from SQL Server 2005 asked me, so here is the InMemory OLTP Migration Assistant script.
SQL SERVER – Identifying Database Default Locations for Data and Logs
Going back to basics can still teach you something new. Here are ways to identify the Database Default Locations for data and log files in SQL Server.






