Andrew G (1/19/2015)

---

High buffer I/O just means high logical IO which is probably just missing indexes or poor performing queries due to the amount of data being processed.

For example, you...

Thanks. The high waits are CXPacket from report queries which I want to advise them to offload to a secondary copy but need the evidence that this would be an...

I notice on the activity monitor, I regularly see high wait times on Buffer I/O however there is substantial amount of memory for this server....

ALZDBA (1/9/2015)

---

burfos (1/9/2015)

---

I haven't on this particular server as...

Jeff Moden (1/11/2015)

---

Lowell (1/11/2015)

---

don't be ridiculous. you can run it on production. it's doing what your server is already doing; in this case it creates a four gig file and...

It is a production 24/7 system. I wont be able to run that tool on there.

peterausger (1/9/2015)

---

thank you very much, but one small change if search C or any value between ,,its not returning anything.

for example if i search c i should get a-b-c

if i...

There is probably a more elegant and efficient way of doing it (see what the gurus reply with) but this works (see attachment as it wont let me post the...

I haven't on this particular server as the database...

Thanks all for the replies. Very helpful. I am definitely running set single user and then immediately running the restore command so nothing in between. There should be no...

Could a database audit specification be another solution?

I believe that restores are indeed recorded in to the backupset table.

A good blog on this is http://shaunjstuart.com/archive/2010/12/msdb-backupset-table-peculiarity/

Backupset it seems, simply holds the details of a backup whether it...

Yes very very good point. Apologies for not pointing that out. Just answering the problem that was asked. There is a previous thread with the actual original question of what...

xp_cmdshell is used to run command shell commands like batch files, executables etc which is probably not what you want. You should simply call

EXEC (@sql)

You need to concat your variable in to your string...

ALTER procedure [dbo].[totalinstallations]

@installations nvarchar(1000)

AS

BEGIN

declare @sql nvarchar(1000)

SET @sql = 'SELECT softwaremanufacturer,productname,productversion,

sum(distinct case when isnumeric(' +