Sree,

Simplest and most straightforward way is to create a new filegroup on the new drive, script all your current indexes, drop the indexes and recreate them on the new...

Regarding the post that talked about mainframe file dumps that used column width as the delimiter vs csv, pipes, tabs etc. I run across this a lot because the folks...

Can we take it a step further, i.e., an article that explains what to do with the results obtained - from both a query rewrite and a hardware POV?

I ran...

As a quick check, move the file(s) to the default location

\SERVER1\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\SERVER1_MBDB_MBDB_PUBLICATION\

and try it again.

Slower check, run through the properties and set it up so the...

this will return only the nb_email as the result set (I can't test) :

ALTER  PROCEDURE MYPROC(@idSite int, @Type varchar(4)) AS

DECLARE @strReq varchar(1000)

SET @strReq = 'SELECT COUNT(*) AS nb_email

     FROM...

Talat,

   Are you doing 'real' merge or dynamic snapshots? Dynamic snapshots can improve performance.

If that doesn't help try  this from BOL :

You can limit the number of merge processes running simultaneously by...

Perico,

  I don't know what this part of the select is supposed to do:

, @nb-2 = COUNT(*)

but it certainly isn't going to get you an output...

Dan,

This:

case when ([service date] = 0) then...

Try LogPI - it's advertised on the SqlCentral web site all over the place, does this and more.

Indexing aside - and I suspect indexing is not the point here as you did not discuss any WHERE clauses  -

Casey had it right in his reply; it is...

Could you be clearer when you say table size - do you mean amount of storage space, or rows in the table?

If storage space, I have found that even bulk...

Another good thing to keep in mind is that if you are using the string to exec anything that has a sysname's or table names etc.. then make variable that...

Then it's not a simple solution, you'll need to go to xml to format the results sets that cleanly since you will not know how many rows you are getting....

have you looked at  'with rollup' or 'with cube'? When you say each page you mean each paper page, or each subsection/grouping of the report?

In the job (each one) add a new step "Insert into reportdb.dbo.FailedJobHistory (Job, DayFailed, etc..) values 'JobName', getdate(), etc..   (of course use you own db name, table, columns etc, you...