Global Database Field Search
Search all text fields in a database for a literal string.Outputs SQL statements to query analyser window, which can then be run in a new window.
2004-02-10
186 reads
Search all text fields in a database for a literal string.Outputs SQL statements to query analyser window, which can then be run in a new window.
2004-02-10
186 reads
Stored procedure to search every field in the database for a string literal. Run the stored procedure in Query analyser, which will output sql statements to do the search. The output of these searches will be the update sql, which again should be pasted into a query analyser window. As the stored procedures do not […]
2004-02-10
249 reads
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
I am trying to use unpivot to extract some data, however, the results are...
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...