Searching and Finding a String Value in all Columns in a SQL Server Table
Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.
2020-09-25
Scripts
Run SQL/T-SQL scripts on folder
What to do when you have several sql scripts to run in your DB? Put all in a folder and use this...
2018-02-09 (first published: 2018-01-24)
1,302 reads
Part 1 -- Restore a database to another instance...
A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.
2016-03-14 (first published: 2016-02-25)
755 reads
Universal foreach aka sp_uforeach
This script is a universal foreach stored procedure. You can loop through everything with the help of if.
2013-09-24 (first published: 2013-09-10)
1,758 reads
Do you regularly run queries and scripts in SSMS?
SQL Server Management Studio is where most SQL scripts and queries are run, and although it does a decent job, it doesn't provide much help storing, sharing and managing the scripts particularly in the context of a team. Red Gate is considering building functionality into SSMS to help its users consume and share queries and scripts. Please help us by completing this short survey to help us define the requirements.
2013-04-12
3,832 reads
Grouped Failover, a 2008R2 version of Availability Groups
One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.
2013-01-24 (first published: 2013-01-16)
555 reads
Blogs
Basic JSON Queries–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Daily Coping 30 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes
A project I’ve been meaning to work on for a while has been to...
Forums
Performance and usage of system stored procedure sp_columns_100
Hello experts, I'm researching different ways to monitor SQL Server CPU usage by query....
Operand type clash: text is incompatible with datetime2
Dear Group: I am not sure what is causing this, and having a terrible...
Can I clone a database across servers?
Hi all, I have a database that resides on server A and I need...
Ask SSC