Explore SQL Server 2005 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2005Microsoft SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.C...

Read more
  • 71K Content
  • 9.8K Contributors

Expert Spotlight
Senior DBA (Microsoft MVP)

Senior DBA, SQL Server, specialising in tuning / performance.

Troubleshooting Solution

Adding different values from a table to find a specific sum value

251
There are times when I need to find a certain value out of a number of records. For example, assume …
Article

Dynamic Pivot Procedure for SQL Server

15
by Mark Wills

PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Video
Article

Managing the Transaction Log for the Accidental DBA

8
by Mark Wills

Attending one of Rob Farley's seminars the other day, I heard the phrase "The …
Article

Fun with MS SQL spt_values for delimited strings and virtual calendars

4
By Mark Wills

Not so long ago, there was a fairly tricky question on Experts Exchange to do with …
Article

Managing Fragmentation for the Accidental DBA

4
By Mark Wills

We often hear about Fragmentation, and generally have an idea that it is about …
Troubleshooting Solution

Sql query

byRIAS
107
Hello,

Any suggestions on how to write this query
Spec:

There are two  columns
Article

Delete Duplicate Rows Without a Primary Key in Microsoft SQL 2005

12
I've encountered valid database schemas that do not have a primary key.  For example, I use …
Article

Dynamic Pivot Procedure without the Pivot function

3
by Mark Wills

PIVOT is a great facility. Well that was the opening line in my previous similarly …
Troubleshooting Solution

Column calculations and inserting into table

95
Hello,

I have the following format:
Date,Signal,SystemIdent,Delta

There can be multiple …
Video
Article

Delimited String Parsing in SQL Server 2005 and later

5
This article will describe one method to parse a delimited string into a table of data.  

Why …
Troubleshooting Solution

SQL Express 2005 upgrade to 2008 R2

77
I have a server that was using SQL EXPRESS 2005.  I need to upgrade it to 2008 R2 to support our new…
Troubleshooting Solution

Tricky T-SQL query

78
This relates to this question: …
Troubleshooting Solution

Basic package 101 - using evalution of data

78
I am brand new to this. I would like a package to do the following. In the DataFlow task, I would …
Troubleshooting Solution

HELP!!!  Cannot install SCOM 2012 R2 Reporting Server on my SQL server 2012 stand alone server

79
Hi, I am trying to finalize my SCOM 2012 R2 production install/setup, but when I go through the …
Article

Making Sense of Index DMV's in SQL Server

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005.


The two in

Article

How to Reset a Lost SA Password in Microsoft SQL Server

5
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Troubleshooting Solution

Cannot launch SSRS Report Manager

bydbaSQL
78
SSRS v2012, I am the admin.  I installed and configured SSRS in native mode successfully.  I had …
Troubleshooting Solution

Update Expired CC information

79
Hello experts.
I have a DB that has a table with CCExpDate as credit card expiration. It is …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more