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

Sql query

byRIAS
107
Hello,

Any suggestions on how to write this query
Spec:

There are two  columns
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

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

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

kill all other existing SQL server connection except the login started by current session

65
hi,

if I open a SSMS console session it will have a SPID itself, is there any other way to kill …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more