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
173 reads
Global String Search & Replace In All DB Fields
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
243 reads
Blogs
Using Azure Data Factory Mapping Data Flows to populate Data Vault
By Rayis Imayev
(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure...
New Azure “SQL Server settings” blade in the Azure Portal
I just noticed today that there is a new blade in the Azure portal...
Mass Backup All Sessions
Migrating Extended Event Sessions from one server to another should be a simple task....
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Need help with query where i need to aggregate an aggregate
Hi all, I have an inherited system which I can't do much with so...
Buffer Pool calculation
Hello Colleagues. Could you tell me about how MS SQL Server 2016 SE determines...
Ask SSC