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,222 reads
Blogs
Regression Testing SQL Saturday Naming
By Steve Jones
I started a poll today on the naming for future SQL Saturdays. You can...
Daily Coping 9 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Error creating Azure SQL Database
By Arun Sirpal
A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”, “message”: “Operation on server x and database y is in progress. Please wait a few minutes before trying again.” What...
Forums
Splitting a group up into multiple groups using a score....
Splitting a group up into multiple groups using a score for how many times...
Whether to leave a clustered index on a staging table
Hi Using dataflows to load data from one SQL table to another (seperate databases;...
Questions about Always On
Dear all, I have the following questions about SQL Server Always On: How does...
Ask SSC