2008-02-25 (first published: 2008-01-15)
911 reads
Scripting extended properties
I use these to manage the addition and removal of extended properties on all tables and columns in my company's dbs.Rather than writing complicated joins or calling functions every time, I use views on sysobjects and INFORMATION_SCHEMA tables. I tried to make these scripts as flexible as possible so you can reuse them in procedures, […]
2006-01-05 (first published: 2005-11-11)
1,219 reads
Blogs
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Daily Coping 25 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
VMworld 2020 – Top 10 Database Sessions (Part 1)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
Stored Procedure Performance Woes... How to get around CURSORS for html gen.
Hi everyone, Working with a stored procedure that is used in an application of...
Any guides for sizing Azure managed instances.
Hi All, Has anyone got any tips for sizing a move from VM running...
How to check if NextDay is Holiday (exclude Saturday and Sunday)?
Hi: We maintain a calendar table with these columns. We have a process which...
Ask SSC