Using the TOP operator in T-SQL procedures is a common practice among developers. It’s often employed to limit the number of records, either to fetch the first value […]
NULLs in MS SQL Server
NULLs are a frequently misunderstood concept within databases. This confusion often arises because NULL is mistakenly considered equivalent to empty or mathematically equal to zero, which is not […]
Profile columns for indexes
Every once in a while, as part of a consulting project I need to investigate all the different columns and datatypes used within the tables. Often in order […]
Monty Hall Simulation using T-SQL
The first time I heard about the Monty Hall problem was while watching TV. The host of the TV show had presented the problem as you typically see. […]
Query to quickly profile a column
Every once in a while, there is a need to quickly profile columns in a table. typically as part of a redesign, the below query help quickly profile […]
Part 2:- Learning T SQL for beginners – Datatypes
In the previous post I talked about what Microsoft SQL Server programming language (T-SQL) is about. I also explained what a table is and what basic information is requires. In this […]
Part 1:- Learning T SQL for beginners- SQL, Tables and Nulls
Learning SQL is easy when you have a good understanding of the basics. Everything else is based on the basics and it’s been the same since RDBMS (relational […]
A simple script to decapitalize Column names
The below script can take column names for all tables in the database and provide the rename script to only capitalize the first letter. Sometimes we just want […]
Simple Function to capitalize a string
Recently I was required to write a function that would capitalize the 1st letter in every word. This is a fairly common requirement and I felt that there […]