Our reporting team uses the rs.exe executable from the Reporting Services engine to generate our Corporate reports (using a combination of the RDL files and the sprocs), while this runs...

We recently stopped the reports that were running using the linked servers and then started some of them again in a manual process...

I reran the query you provided me with:

wait_typewait_time_spctrunning_pct

PREEMPTIVE_OS_PIPEOPS180980.4739.3139.31

RESOURCE_SEMAPHORE110668.6424.0463.35

OLEDB53578.7611.6474.99

BROKER_EVENTHANDLER31106.336.7681.75

ASYNC_NETWORK_IO27699.906.0287.76

BROKER_RECEIVE_WAITFOR27556.465.9993.75

PAGEIOLATCH_SH9932.822.1695.91

MSQL_DQ2078.420.4596.36

ASYNC_IO_COMPLETION2061.090.4596.81

BACKUPBUFFER2026.660.4497.25

PREEMPTIVE_COM_QUERYINTERFACE1934.660.4297.67

IO_COMPLETION1564.050.3498.01

LCK_M_IX1155.240.2598.26

BACKUPIO1079.190.2398.49

PREEMPTIVE_OS_WAITFORSINGLEOBJECT1068.900.2398.72

BACKUPTHREAD1062.430.2398.95

CXPACKET1000.400.2299.17

I...

... are your three top ones. Note, that's not 49 seconds of memory waits. That's already divided into seconds. That's 13 and a half (roughly) hours worth of waits...

Cant find that option under memory (this is SQL 2003 EE x64 server) if that matters to the options...

All DB's are up and operational.

Not sure how to paste in an...

Which performance object is that in? Not really sure on how to check and see if the servers swapping files...

FYI - checked the RAM and yes it is what...

First you need to create a linked server. This is easiest to do through the GUI but you can also use sp_addlinkedserver (you may want to check "Data Access"...

It is identical, just remove the "_Archive"

Thanks for your help, attached is tsql to create the table and 1000 rows of test data in CSV format

THANKS IN ADVANCE!

Only thing that sticks out to me is security. I'm assuming you use mixed mode authentication and you're logged into the SQL Server using your windows account...my only suggestion...

Are you certain you're running it on the correct server? As I'm sure you're already aware, this returns all DB's that are "online", no matter where you run it:

SELECT...

This won't help with the Restore issue you're experiencing but to aid what Gail mentioned, you could use it to replace those rebuild/reorg steps in your Maintenance plan

You can use...

Okay...tried this, not much success...

(Actually I've tried it both ways now and still get errors)

HERE'S THE BCP QUERY OUT COMMAND USING "-c":

bcp " SELECT * FROM COREACQUIRE.dbo.Auth_Primary WITH(READUNCOMMITTED) WHERE PostTime...

If I remove -c then I have to supply the datatype individually for every column...which in the case of this table is well over 950 columns!!! Is there an...

The question should have started with "In SQL Server 2005..." as Powershell is NOT an option in 2005.

You could try this:

Usage:

SELECT dbo.fx_SplitColumnText('rptclientrifvdistrictgrantstatuschangelog_MillmanR_9dfb3dfa-081b-48d1-8bbf-81361bbd9cb9', '_', 1)

Returns:

rptclientrifvdistrictgrantstatuschangelog

TSQL:

(You'll have to format this yourself)

USE [F1Settings]

GO

/****** Object: UserDefinedFunction [dbo].[fx_SplitColumnText] Script Date: 03/23/2011 13:40:45 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/*...