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,602 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)
822 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)
728 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)
20,606 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)
781 reads
2016-07-05 (first published: 2016-05-26)
3,964 reads
2016-07-01 (first published: 2016-05-24)
628 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)
777 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,038 reads
Blogs
T-SQL Tuesday #178–A Recent Technical Problem
By Steve Jones
This month we have a good invitation from Deepthi Goguri, where she asks us...
Redgate Clone Graduating Images
By Steve Jones
I wanted my own custom image in our internal Redgate Clone cluster, so I...
SQL Saturday Syracuse 2024 Recap
By alevyinroc
First Things First Thanks to every who came to my session, Asnwering the Auditor’s...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Tablock to avoid deadlock
Hi, We have 4 stps. the flow of the stored procedure (stp) is as...
Question of the Day
Adding Features During a SQL Server 2022 Upgrade
I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade?
See possible answers