2007-04-30 (first published: 2007-04-03)
1,675 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
ASF 030: Benni De Jagere interview
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best...
Forums
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Now Is a Good Time for Choices
Comments posted to this topic are about the item Now Is a Good Time...
Design ideas for hostoric data & trending
Hi everyone, I have a use case (below) for which I am considering multiple...
Ask SSC