sotn (12/27/2012)

---

On our production server SQL 2008 R2 10.50.4000 our ERP system runs this query (nothing we can do about the cursors)

declare @p1 int

set @p1=NULL

declare @p3 int

set @p3=16

declare @p4 int

set...

ramyours2003 (12/27/2012)

---

we are unable to open SSMS from the windows box ,however we are connecting to the server from the other server, we checked in the event viewr...

How about disabling security software like antivirus and test it..?

Check this activity monitor script[/url] and it can find you the root blocker and you know how to tweek it to get the query running by root blocker.

Hope it helps...

Jeff Moden (12/26/2012)

---

Not really. "It Depends". SAN-based replication is nearly instantaneous and puts no load on the...

wannalearn (12/26/2012)

---

In our office we run jobs to keep these environment in sync. We get data from outside source and run the job overnight to load data on Prod. It's...

you could use osql utility and run the script under a sql agent job and send the results to a txt file using dbmail.

Also, Check this customized powershell script...

This is what I got so far and I need help with looping script to add files to number of...

I knew it is bad practise for tempdb but want to see how we can write a query to dynamically add files based on a condition.

Yes, I need only the script..Appreciate your help!

Look into Tools>Options>SQL server Object explorer>scripting

How often you run the job for the re-org and re-index maintainance ?

Scan density <100% means to frangmentaion existance.

If you trying script the system view, you cannot in SQL 2008R2 and if it is user view then you should be able to see the option for script to..

Can you tell me where is the difference in your 2 outputs above ?

That # differs type of backup. if you use compression it dispalys diffrent number of pages. So actually it is teh number of pages in the backup made but not...