SQLServerCentral.com Content tagged SQL Server 2008

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

SQL Server 2008 Build List

Wed, 30 Jan 2013 07:00:00 UT

The list of builds for SQL Server 2008 updated SP3.

Number of Rows

Fri, 18 Jan 2013 07:00:00 UT

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

2008 Index Rebuild using DMV

Thu, 09 Aug 2012 06:00:00 UT

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.

SQL Server 2008 Build List

Wed, 30 Jan 2013 07:00:00 UT

The list of builds for SQL Server 2008 updated SP3.

Transaction Replication Publisher failover to Mirror

Thu, 28 Jun 2012 06:00:00 UT

Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.

Change Tracking - 2008

Mon, 18 Jun 2012 06:00:00 UT

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.

SQL Server 2008 Build List

Wed, 30 Jan 2013 07:00:00 UT

The list of builds for SQL Server 2008 updated SP3.

CLR Integration in SQL

Thu, 05 Apr 2012 06:00:00 UT

Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.

SQL Server 2008 Build List

Wed, 30 Jan 2013 07:00:00 UT

The list of builds for SQL Server 2008 updated SP3.

Tips for Upgrading a Cluster to SQL 2008 - Part 2

Tue, 20 Mar 2012 06:00:00 UT

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008

Adding a log shipping monitor

Thu, 15 Mar 2012 06:00:00 UT

This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Fix SSRS Subscription Owners

Tue, 13 Mar 2012 06:00:00 UT

Stored procedure to update SSRS Subscription owners to avoid email errors.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Get Top Queries Taxing SQL Server CPUs

Sun, 11 Mar 2012 02:19:09 UT

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.

sp_JobSchedule_rpt for SQL 2005/8

Thu, 23 Feb 2012 07:00:00 UT

I just took the stored procedure documented here: http://www.sql-server-performance.com/2002/job-report/ ?? ...and made it work on 2005/2008.

SQL Server 2008 Build List

Wed, 30 Jan 2013 07:00:00 UT

The list of builds for SQL Server 2008 updated SP3.

A Guide to Installing SQL Server 2008 R2 Reporting Services

Tue, 14 Feb 2012 07:00:00 UT

This document shows how to install a Microsoft SQL Server 2008 R2 Reporting Services instance.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Wed, 13 Mar 2013 06:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

create jobs script for 2000 2005 or 2008

Wed, 18 Jan 2012 07:00:00 UT

will create jobs script for backup or DR purposes to install on another server.

Understanding and Using APPLY (Part 2)

Fri, 13 Jan 2012 07:00:00 UT

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.

Understanding and Using APPLY (Part 1)

Fri, 06 Jan 2012 07:00:00 UT

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

SQL Server Service Broker demystified

Thu, 15 Dec 2011 07:00:00 UT

Simplified explanation of whats and hows of Service Brokers

Tips for Upgrading a Cluster to SQL 2008 - Part 1

Mon, 14 Nov 2011 07:00:00 UT

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008

Using TOP To Rank Columns In a Table

Tue, 25 Oct 2011 06:00:00 UT

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.

Diagnosing and Resolving Spinlock Contention on SQL Server

Fri, 21 Oct 2011 06:00:00 UT

This paper describes how to identify and resolve spinlock contention issues observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.

SQL Server 2008 Build List

Wed, 30 Jan 2013 07:00:00 UT

The list of builds for SQL Server 2008 updated SP3.

Adding Custom Code to the Reporting Services 2008 R2

Thu, 15 Sep 2011 06:00:00 UT

There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article you will see how to add custom code to SSRS.

Detach All User Databases

Wed, 24 Aug 2011 06:00:00 UT

Detach all user databases on a SQL 2008 instance