2008-02-25 (first published: 2008-01-15)
913 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,226 reads
Blogs
Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Forums
Thiết kế nội thất phong cách organic
Phong cách thiết kế nội thất organic lấy cảm hứng từ nét đẹp của...
subscriber part of ALWAYSON
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
SQL Server Licensing Question
I'm in the process of replacing a sql server 2012 with 2019. How do...
Ask SSC