Script to Find String in Database object
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
953 reads
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
953 reads
Use below query to find tables that need to be optimized based on number of forwarded records.
2016-06-16 (first published: 2016-05-05)
544 reads
2016-06-14 (first published: 2016-05-02)
1,782 reads
Generates code for INSERTs as well as generating data form tables for INSERT. Will also find and script all dependencies recursively, present all scripts in dependency order, and generate a reverse-dependency order set of conditional DELETE statements.
2016-06-13 (first published: 2015-06-04)
2,139 reads
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
2016-06-10 (first published: 2014-10-27)
4,174 reads
Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.
2016-06-09 (first published: 2016-05-05)
1,718 reads
2016-06-08 (first published: 2016-04-28)
903 reads
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,040 reads
Replication related script- quick way to determine the publication name, Article and column which are part of the different publications.
2016-06-06 (first published: 2016-05-09)
828 reads
Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names
2016-06-03 (first published: 2016-05-06)
338 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers