Thanks.  I found it.  Two questions.  When I want to remove the Explicit Permission is there a way to list only those objects where explicit permissions have been granted?  I'm...

To make matters worse they purchased 10k SAS drives instead of the 15k SAS drives I requested.  The server team thought 10k drives would be sufficient because they are SAS...

Thanks.  I'm researching the option to see what overhead it places on the server.  I'm guessing it shouldn't be much more then running an incremental every 3 minutes.

Dave

Thanks Gift.  I'll look into WITH CHANGE_TRACKING.  Running an incremental every 3 minutes places a lot of messages in the SQL log that get in the way of quickly identifying...

The SCSI disks will be 15k rpm in a RAID 10 and the controller will have as much cache as possible.  I've been told the SAN disks outperform the SCSI...

By local users and groups I am referring to the OS-level users and groups that are local to the physical server.  Sorry for the confusion.

Thanks,  Dave

At my last job we took the audit table approach to comply with Sarbanes-Oxley, but fortunately my current employer is not subject to SOX.  I would still consider audit tables,...

Thanks Tom.  I'll give it a try. 

Hi Tom,

Keep in mind this is the vendor's code so there is nothing I can do to the code.  The only way they would change the code is if I proved...

I looked at an old trace and found a couple of procedures causing problems on that specific day.  One procedure executed the following update statement.

This one contains a lot of...

The big delays are typically within one stored procedure, but that procedure invokes several other procs.  In regards to joins I thought that was a possibility, but I don't understand...

I understand IndexDefrag is not the same as DBReindex, but at least it reorganizes the leaf pages.  Better then nothing I guess. 

On one test I restored the production DB...

It's just the standard MS blocker script that the vendor customized a bit.  It almost looks like an older version of the script when compared with the MS version for...

The vendor just clarified their statement when they sent me the code changes.  They are referring to Microsoft's blocker script they asked me to run to detect blocking and waiting. ...

I'm aware of this, however the vendor insists on using the command with the argument being it will be a few years before the next version of SQL Server is...