Script to look at all articles in all publications in a DB to find replicated columns of certain data types. I used this to find BLOB columns that we wanted to remove from the articles.
2004-08-09 (first published: 2004-02-19)
447 reads
Based on moffan76's script to GRANT EXEC to all sprocs and UDFs (that EXEC) and GRANT SELECT to views and UDFs (that SELECT). This script uses that same general technique of selecting the object names from sysobjects, but does it in one step w/o using a cursor. It is also not wrapped in a sproc […]
2003-12-30
188 reads
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
By alevyinroc
I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....
Comments posted to this topic are about the item Execution Plan Operators
--for a given member if the startdate and endate is continous we need to...
I have two sources , one coming from datalake and another is file. we...
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers