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 …
Troubleshooting Solution

Mining for data by breaking up a stored procedure

9
I have a vast database to search for certain specific values in nested relational tables, which will …
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 …
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

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

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

SQL 2008R2 Cursor (in Function) Very Slow

76
Good day, team

 I am working on a severe latency issue revolving around a function …
Troubleshooting Solution

What is the difference between where and exists statement

68
What is the difference between where and exists statement

Please don't post any links , i need a …
Troubleshooting Solution

SQL Grouping Issue

69
Query
SELECT Clinum,superclient,Superkey, sum(column1) AS Fees, sum(column2) AS Unallocated,
    …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more