I'm wondering just what the benefit is to filegroups when your data is stored on a SAN or NetApp appliance? I believe I read something about a benefit when...

Not sure this makes sense, but I received the "incorrectly formatted" error after I backed up databases with the same names on a different instance to the same location.

Have you found a solution to this issue?

GilaMonster (5/26/2010)

---

don.schaeffer (5/25/2010)

---

I've just been testing fragmentation on a table that has a clustered index on a guid (ouch!), not my design. But I've found that with an appropriate...

I've just been testing fragmentation on a table that has a clustered index on a guid (ouch!), not my design. But I've found that with an appropriate fill factor,...

If there are transactions involved locks may be retained on tables from previous statements. Even though the second spid might be selecting from table b it may still have...

This script might get what you want:

select

WaitTime = cast( textdata as xml ).value( '/blocked-process-report[1]/blocked-process[1]/process[1]/@waittime','varchar(20)' ),

BlockingQuery = cast( textdata as xml ).value( '(/blocked-process-report/blocking-process/process/inputbuf)[1]','varchar(200)'),

BlockingSpid = cast( textdata as xml ).value( '/blocked-process-report[1]/blocking-process[1]/process[1]/@spid','varchar(20)'...

You can use powershell to execute a script on multiple servers. This article shows how to do this, populating an excel worksheet with information on failed jobs:

Table with self references seem to cause an infinite loop in this script. I added "where S1.name SO.Name" to the table population query to avoid this.

The last line of the where clause reads:

AND ((a.user_seeks + a.user_scans + a.user_lookups) = 0 OR a.user_updates = 0)

I think "OR a.user_updates = 0" should be removed. For example,...

I'm curious how many people verify their backups. I found that step can take twice as long as performing the backup itself.

You could replace the insert statement with this one to get the correct table schemas and avoid those errors. We too use multiple schemas, for organizational purposes.

INSERT INTO @FKTable...

Jonathan, thanks for looking at this. No, I haven't resolved it.

Client_Id is an integer column; there's an index on it:

CREATE NONCLUSTERED INDEX [Employees_Client_id] ON [dbo].[Employees]

(

[Client_ID] ASC,

[DivID]...

Sorry, I edited my post. My xml was getting eaten when I posted so I replace the close ">" with right bracket "]"

I don't know whether to always believe the blocked process report. At times I see lots of purported blocking like this, where one select statement is supposedly blocking another....