Lowell (9/20/2011)

---

One of our developers started down that same road, because we had so many users familiar with Excel, but we ended up switching to a web page instead;

we...

1. When I sat up this is this going to slow down production enviroment?

Like with a lot of things - it depends. You can do synchronous or asynchronous mirroring which...

In my experience SQL Server is installed on each node's C drive and the user database data/log files are on the SAN.

jamessdba (6/25/2010)

---

Thanks you for reply

1)See what was running at the time: sys_dm_exec_requests

2) Check free disk space at run-time

3) Check log growth

Please let me Know how to check above...

GilaMonster (6/25/2010)

---

None...

See what was running at the time: sys_dm_exec_requests

Check free disk space at run-time

Check log growth

Check what the autogrowth of the data and log file is set at

John Rowan (6/15/2010)

---

FFS? Please explain.

This is clearly not an urgent matter for the OP. If you look back at previous posts from the OP, the other post was...

WayneS (6/14/2010)

---

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it would have made things...

John Rowan (6/14/2010)

---

If you let your homework go too long, it will become urgent. We are all volunteers here on this site so it would help us if you...

So the column type is varbinary?

It's up to you if you want your archive table to grow over time. Only you can make the decision based upon disk space and query/index efficiency etc. Theoretically your...

Do you mean you've put a table on Filegroup B of a database and the rest of the tables are on Filegroup A of the database?

You could create seperate filegroups for current and archive data and place tables on the respective filegroups that contain current/archive data. Then do filegroup backups.

You'd probably need to create a...

http://msdn.microsoft.com/en-us/library/ms187510.aspx

http://msdn.microsoft.com/en-us/library/ms186865.aspx

Yeah you were right. Not long after I made the post I changed the stored procedure to:

ALTER PROCEDURE [dbo].[UspRepCpu]

@ServerName VARCHAR(100),

@StartDateDATETIME,

@EndDateDATETIME

AS

DECLARE

@Query VARCHAR(4000)

Set @ServerName = @ServerName + 'PerfMonData'

SET @Query =

'

SELECT

...