Unused Procedure lists - Easiest way
This function is used to get the unused stored procedure list for which doesn't used for given noofdays.
2016-09-01 (first published: 2014-12-03)
3,312 reads
This function is used to get the unused stored procedure list for which doesn't used for given noofdays.
2016-09-01 (first published: 2014-12-03)
3,312 reads
Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.
2016-08-31 (first published: 2014-12-10)
3,546 reads
Short little script to get the columns in a table in order into a CSV format.
Can be useful for select or insert statements.
2016-08-30 (first published: 2015-03-23)
3,315 reads
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
4,785 reads
A brief introduction to the sparse option and script to help decide when to use it
2016-08-25 (first published: 2015-04-10)
1,696 reads
2016-08-23 (first published: 2015-05-01)
1,287 reads
I comment CATCH section for removing dependence to log procedures.
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpTableUnload.sql
2016-08-22 (first published: 2015-05-07)
1,958 reads
2016-08-19 (first published: 2015-05-13)
1,980 reads
Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.
2016-08-16 (first published: 2015-01-29)
4,701 reads
Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes
2016-08-12 (first published: 2012-05-17)
1,726 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers