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,720 reads
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
2,720 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)
751 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,190 reads
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
783 reads
2016-07-05 (first published: 2016-05-26)
4,337 reads
2016-07-01 (first published: 2016-05-24)
635 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 was experimenting with a local model (article) and as a part of this,...
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...
We have a publication with three subscribers; it's basically a part list with around...
Hi Experts, I have database about 300GB in size with ADR enabled but after...
What types of database operations does the Data API Builder support?
See possible answers