The stored proc FindObjByColumn_sp, while simple, is extremely useful when making database changes or for any reason that you need to find any tables and stored procedures that contain a particular column. It searches the system tables of a database to find the object containing the column. In addition, the procedure automatically adds a wildcard […]
2002-10-31
415 reads
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Comments posted to this topic are about the item Building Your Brand
Comments posted to this topic are about the item A Little Paranoia is Good
Comments posted to this topic are about the item Auto Rounding
Ask SSC