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,936 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)
849 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)
820 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,176 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)
814 reads
2016-07-05 (first published: 2016-05-26)
4,930 reads
2016-07-01 (first published: 2016-05-24)
672 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)
802 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,062 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers