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,345 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,345 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)
4,021 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)
4,614 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)
5,209 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,736 reads
2016-08-23 (first published: 2015-05-01)
1,483 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)
2,220 reads
2016-08-19 (first published: 2015-05-13)
2,074 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)
7,037 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,745 reads
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
I’ve been thinking a lot lately about what it actually takes to make an...
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Comments posted to this topic are about the item Everything I Needed to Know...
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers