I suspect its because the DB is 100GB in size. And they may only need some not all of the tables in the database.

harsimranjeetsinghwasson (9/4/2013)

I would like to export data of warehouse from Production to dev for special reasons, what are best possible

ways for the same.

We normally have a job that runs in...

You cannot shrink the files to smaller than when they were initially created. Shrinking the files will only shrink down to the inital creation sizes if there is space...

Have you read this?

http://support.microsoft.com/kb/309392

Although I cant provide you with the code, the easiest way would be to trace your server whilst running the report and you will be able to capture the code...

Technically you can run anything simulataneously as long as they are not conflicting commands (which in your example are not). But be wary as I mentioned about resources.

It may be easier to replicate the data of the tables you need using transactional replication from one database to the other. You would then not need to use...

Possibly. As each operation will take up resources such as DISK I\O, CPU cycles etc etc.

You may run into resource issues when running them at the same time. ...

You can use the free RML utilities by microsoft to perfom this very action

http://support.microsoft.com/kb/944837

Not the easiest apps to use but very effective.

This may be what you are looking for:

USE TEMPDB

GO

IF EXISTS (SELECT TOP 1 1 FROM sys.tables WHERE name = 'test_prices')

DROP TABLE Test_Prices

GO

CREATE TABLE Test_prices (

[Date] date,

Product nvarchar(100),

Price decimal (10,2))

GO

INSERT INTO...

Your requirements are a little sparse in your description. Can you elaborate? replication may be an option but without more details I cant advise any better.

I should point out that the organisation I work for has quite habitual use, so taking the trace for 10 minutes per day covers 99% of all procedure calls made,...

Well, for example how do you know if a procedure is taking up any more resources or taking any longer than usual without having a baseline figure?

As I mentioned before...

*Check for wait types

Ans - SELECT * FROM sysprocesses WHERE SPID > 50 and WaitTime > 0

*Identify fragmentation % (and then do an index reorg or rebuild accordingly)

I Know to...

Everyones approach is different but personally I find performance monitor is only realy helpful if you have a baseline of values for counters for when the system is performing as...