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)
1,389 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)
796 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)
619 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)
9,761 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)
702 reads
2016-07-05 (first published: 2016-05-26)
725 reads
2016-07-01 (first published: 2016-05-24)
591 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)
755 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
978 reads
Blogs
Goal Progress–November 2020
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
Azure Synapse Analytics is GA!
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
5 Things You Should Know About Azure SQL
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
Forums
SSRS\PowerBI Information
I'm looking for a powershell script to gather the following information from my server...
SQL agent job failed
I recently upgrade and migrate a SQL server 2017 to 2019 new instance. Moved...
Database, RAM and processor Information
Hi, I need to find the size of all db's and server's processor and...
Ask SSC