Explore SQL Server 2008 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2008Microsoft SQL Server 2008

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

Read more
  • 50K Content
  • 7.1K Contributors

Expert Spotlight
IT Specialist

I am an accomplished Software Engineer specializing in Software Programming and Analysis.

Troubleshooting Solution

Self-Join a table to report which column value(s) have changed

bydbaSQL
28

I have a 'ServerAudit' table that is populated when server definition change events occur.  The

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
Post

This is a basic sp but it returns a 1 properly but will not …

bybiotec
This is a basic sp but it returns a 1 properly but will not return anything when the statement is …
Troubleshooting Solution

Sql query

byRIAS
107
Hello,

Any suggestions on how to write this query
Spec:

There are two  columns
Troubleshooting Solution

SQL 2012 Intermittance

97
I have PHP web page that calls a stored procedure in SQL 2012 as UserA. The procedure does not …
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

Query for null inner joins

byAleks
72
I have table "cases" and table "Activities"

The tables join on cases.id = activities.caseid where…
Troubleshooting Solution

Must optimize this procedure, need an assist

bydbaSQL
80
This is v2008 R2.  A customer asked me to optimize a script.  Typically not a problem, but I've …
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

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

How to Make T-SQL Queries "Run Faster"

75
Hello:

Below is my code that is essentially a combination of two CTE queries, plus a separate …
Troubleshooting Solution

SQL Grouping Issue

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

VBscript SQL query hangs script

65
Hi,

I have a vbscript that querys a SQL database and put the records in to a text file. (CSV)
Troubleshooting Solution

Counting values based on different range values

65
Hi experts

I got help with code before which I have attached below

Basically the code below …
Troubleshooting Solution

Truncate vs Delete

63
Hi, I have a Datawarehouse  SQL job . Basically the job will populate our Datawarehouse overnight. …
Troubleshooting Solution

Index fragmentation

61
We have a table with a number of indexes inc a primary key (int). The table rows are being update a …
Troubleshooting Solution

Partitioning by GUID+ SQL Server 2012

66
Hi ALL:

I have a table which has a Uniqueidentifier Column. I would like to Partition this table …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more