SQLServerCentral.com Articles tagged SQL Server 2005

Three Attack Vectors in SQL Server 2005

Wed, 07 Mar 2012 07:00:00 UT

This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.

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.

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.

Adding a Node to a SQL Server 2005 Failover Cluster

Wed, 12 Oct 2011 06:00:00 UT

Setting up multi-node clustered SQL instances from scratch is common practice for companies that want to implement high availability, but adding a new node to an existing clustered SQL instance that has been running for a while may have a few sticking points, especially for a SQL 2005 instance.

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

SQL Overview SSIS Package III - Full Package

Fri, 15 Jul 2011 06:00:00 UT

Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

Mon, 30 May 2011 06:00:00 UT

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008

SQL Server 2005 Build List

Thu, 24 Mar 2011 06:00:00 UT

Build List Updated with SP3 CU14 and SP4 CU3.

SQL Server 2005 Build List

Thu, 24 Mar 2011 06:00:00 UT

Build List Updated with SP3 CU14 and SP4 CU3.

Deleting Large Number of Records

Fri, 18 Feb 2011 07:00:00 UT

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005

SQL Server 2005 SP4 Has Been Released

Mon, 20 Dec 2010 07:00:00 UT

Microsoft completed SQL Server 2005 Service Pack 4 recently and made it available at the end of last week.

SQL Server 2005 Build List

Thu, 24 Mar 2011 06:00:00 UT

Build List Updated with SP3 CU14 and SP4 CU3.

SQL Server 2005 Performance Dashboard Using SSRS

Fri, 03 Dec 2010 07:00:00 UT

A first look at the Performance Dashboard in SQL Server 2005 by new author Robert Griffin.

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Thu, 28 Oct 2010 06:00:00 UT

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...

SQL Server 2005 Build List

Thu, 24 Mar 2011 06:00:00 UT

Build List Updated with SP3 CU14 and SP4 CU3.

Inside the Optimizer: Constructing a Plan - Part 4

Thu, 16 Sep 2010 06:00:00 UT

The final part in a series by Paul White exploring the internals of query optimization. Learn how

Inside the Optimizer: Constructing a Plan - Part 3

Tue, 14 Sep 2010 06:00:00 UT

Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Inside the Optimizer: Constructing a Plan - Part 2

Thu, 09 Sep 2010 06:00:00 UT

How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.

Inside the Optimizer: Constructing a Plan - Part 1

Tue, 07 Sep 2010 06:00:00 UT

Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

Tue, 17 Aug 2010 06:00:00 UT

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.

Finding Unique Non-Repeating Random Numbers

Thu, 12 Aug 2010 06:00:00 UT

Learn three methods of creating random numbers that do not repeat in this article from Brandie Tarvin.

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.

Missing Indexes in SQL Server 2005

Fri, 23 Jul 2010 06:00:00 UT

Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

Fri, 23 Jul 2010 06:00:00 UT

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

SSIS Package to Script All SQL Server Jobs to Individual Files

Tue, 06 Jul 2010 06:00:00 UT

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.

Default trace - A Beginner's Guide

Fri, 11 Jun 2010 06:00:00 UT

This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.

Built-In SQL Server Agent Performance Reports in SQL Server 2005

Wed, 02 Jun 2010 06:00:00 UT

SQL Server 2005 includes a number of built-in reports to assist you in troubleshooting and measuring performance. In this tip I will cover the Built in SQL Server Performance Reports related to SQL Server Agent within SQL Server 2005.

Repair Corruption Using the Mirror Database in SQL 2005

Mon, 10 May 2010 06:00:00 UT

Explanation of how to repair a database in SQL 2005 Enterprise which is mirrored.

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.

A little restriction that prevent changing tables in SQL Server 2008

Wed, 24 Mar 2010 06:00:00 UT

In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...