2007-04-30 (first published: 2007-04-03)
1,666 reads
Checking the REMOTE site of a database-link
When gathering SQL server statistics on ALL our Active SQL servers the script was failing sometime when one of our servers was not reachable for one reason or another.This script is checking if the LINKED SERVER is up and running before executing the "gathering statistics" script for this particular server.
2006-12-25 (first published: 2006-09-29)
178 reads
Blogs
Do you have rarely used indexes that are hurting performance of writes?
By SQLPals
We know that indexes are necessary for query performance but comes with overhead during...
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...
Happy Hour at SQL in the City Austin
By Steve Jones
Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
sql server 2012 data column used for 7 different languages
In a sql server 2012 database, I want to store some messages in the...
Ask SSC