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
SQL Server DBA & Architect, EE Solution Guide

I'm a SQL Server Architect experienced in Design, Development, Administration, Performance Tuning.. Exploring BI, SSIS & Data Science Arena!

Troubleshooting Solution

How to recommend the correct clustered index --- for all tables.

bydbaSQL
81

This is a new one for me...  SQL Server v2016 sp2.  A customer says they have a script that needs to

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

Sql query

byRIAS
107
Hello,

Any suggestions on how to write this query
Spec:

There are two  columns
Troubleshooting Solution

Column calculations and inserting into table

95
Hello,

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

There can be multiple …
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 …
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…
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

Encryption - Decryption in SQL Server 2008 and backup database with encrypted data and restore it somewhere else.

7
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  …
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

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

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

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

SARGable functions in SQL Server

3
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, …
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)

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more