Getting TEXT, NTEXT and IMAGE columns in Database
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
2,909 reads
Converting values into Rows
Script describe one of the way to divide values into rows by using any specified dividing value.
2016-11-15 (first published: 2016-11-04)
834 reads
Getting top ranked employee detail for each department
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
779 reads
SQLCMD to export data in txt file
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
22,107 reads
Handling with currently running and blocking sessions
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
799 reads
2016-07-05 (first published: 2016-05-26)
4,885 reads
2016-07-01 (first published: 2016-05-24)
659 reads
Getting LEAD and LAG values manually
LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also
2016-06-28 (first published: 2016-05-18)
795 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,054 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers