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,737 reads
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
2,737 reads
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
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)
754 reads
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
21,268 reads
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
784 reads
2016-07-05 (first published: 2016-05-26)
4,401 reads
2016-07-01 (first published: 2016-05-24)
637 reads
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
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,041 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Smashy Road provides numerous intriguing and distinctive experiences that are rarely found in other...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers