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,914 reads
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
1,914 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)
811 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)
676 reads
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
15,289 reads
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
753 reads
2016-07-05 (first published: 2016-05-26)
1,114 reads
2016-07-01 (first published: 2016-05-24)
599 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)
763 reads
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,002 reads
By Steve Jones
fensiveness – n. a knee-jerk territorial reaction when a friend displays a casual interest...
By James Serra
I get many of the same questions about Microsoft Purview, so I wanted to...
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers