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,797 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)
823 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)
762 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)
21,586 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)
785 reads
2016-07-05 (first published: 2016-05-26)
4,563 reads
2016-07-01 (first published: 2016-05-24)
641 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)
781 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,041 reads
Blogs
SQL Saturday NYC Recap 2025
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
Why Data Silos Hurt Your Business Performance
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Forums
SSPI handshake failed error code 0x80090311
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Need query help - MAX record
Hello - I have attached a Word document here with details about my issue....
Need query help - MAX record
I am having trouble writing linking the MAX query that I created back to...
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers