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

/*...

Under the advanced tab in Job Step properties, can't you set the On Faiilure Action to "Go to the Next Step?" The last step of course needs to be...

Oliii, the bcp process finally completed and here was the "running results"

Current server - bcp for 20,547,681 records, 812.57 mins @422 rows/sec.

I tested it on the new server I'm eventually...

Thanks Brandie, but I didn't go with that method, I actually opted for bcp....like so:

bcp " select * from dw_load.dbo.DW_Fleet_Load_Progress with(readuncommitted) where [pos-date] >= DATEADD(mm, -12, GETDATE()) " queryout...

Yes, I wish I had honed in on using the /b flag before I ran this last night...now everything's running as one giant transaction and God on ly knows how...

I ran out of space yesterday evening when all the rebuilding was running so it failed and went into a lovely 3 hour rollback process. When I first ran...

"If you have enough space on another drive (or another server) do a bcp queryout (only the rows you need to keep), truncate your table and bcp in. No need...

I have very little experience with partitioning...could you provide me with some good links on either instructional videos or good articles so I can learn about it more quickly?

Thanks for the tips! I have exceeded my maintenance window for tonight but will try this tomorrow afternoon once corporate reporting has finished for the day

How about an actual...

Oops, great questions...sorry I forgot to include more relevant information

* How long is "FOREVER"?

- 33 minutes to delete about 290,000 records (a long way to 13+ million)

* Is...

This appears to be the closest thing I can find:

SELECT IndexName = name,

IndexSizeMB = CEILING(1.0 * dpages / 128),

...

Easiest thing is doing what Gail mentioned.

I give Full Bkp's a .zip ext, Diff's .bak, Log's .trn, and don't use filegroup but am pretty certain any 3-char extension would work...

Maechismo_8514, I have a question about your comment "the pages would be loaded to the memory anyway"

I typically REORG fragmented indexes that are > 50 pages or more because in...