Scripting database objects in SQL Server 2008
In this article, we would go through the
steps to script the objects in a database using SQL Server 2008....
2010-03-18
2,663 reads
Performing SSAS Database Backup
In this post, we will look the steps to backup a SQL Server Analysis Server Database.
After logging to the Analysis Services,
in...
2010-02-08
1,703 reads
Concatenating Strings to NULL values
We recently ran into this situation of reports containing nothing but blank spaces. When investigated the reason was that the String...
2010-02-01
2,483 reads
Perform a Striped Backup
The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...
2009-12-16
2,636 reads
Blogs
What Agent Jobs are Running??
By gbargsley
Do you run SQL Agent Jobs in your environment? Do you know what is...
Unboxing SQL Clone 2020 for a PoC
By Steve Jones
When I got a new machine, I had SQL Clone on my old machine,...
Daily Coping 4 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Extended Events
I have set up an extended event to capture the queries users may be...
Script logins and all permissions: no longer supported in SSMS generate script?
Okay, maybe I've just gone crazy but I was certain it used to be...
Recursive Select runs slow
Hello, I have a recursive Select that runs ultra slow. My test table has...
Ask SSC