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
bruhaspathy@hotmail.com
- Interests: SQL Server, watching and playing tennis, reading books
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
Using Customer Docker Compose File Names
By Steve Jones
As I use containers more and more to run various things, I decided I...
SQL Server Failover Cluster Instances
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Forums
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
Handling Engagement Rings & Wedding Band
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers