Hi Ammad,

There is a tool that looks at a server and compares it against generally agreed upon best practices for SQL Server 2005.  It's called best practice analyzer (ver. 2.0). ...

Hey David,

From my experience with Veritas and with large databases, I have a couple comments to make, as well.  First off, I would recommend checking out LightSpeed, a DB backup...

Hi Parthipan,

There seems to be some confusion over 32-bit vs. 64-bit architectures.  You do not want to do either 3gb or PAE.  There is not a 4 GB virtual memory...

Hi Matt,

I've had a lot of these problems before as well.  This is probably one of the more frustrating I've had.  As a little background, you are having pressure in...

Hi David,

I would recommend moving logins first.  The sp_revlogin script in the link Sugesh provided is a wonderful way of doing that.  Also, you can check that the SIDs, passwords, etc....

There are ways to cause problems with each based on really bad column names, but [] may be less likely to have this problem.

Ex. 1, Breaking Single quotes

1) select 1...

Hi David,

As for your latest question, a custom plan might help, but it most likely won't.  I see a 3 table join some where clause filtering, group and ordering.  Here...

Hi Bert,

I have to admint I know the SQL 2000 optimizer a lot better than '50, but here's a couple thoughts.  First off, I generally recommend to keep from...

I agree.  Actually the SQL Servers for our internet facing applications are in such a zone with those protections.  The additional protection comes with the fact that there is no...

Thanks for the feedback.  Security and performance are my major concerns as well.  Considering the nature of our database applications, there are few single servers that would have the amount...

Hi Henrik.  I think you may be confused as to what roll back means.  When you restore a full database backup, it has an exact copy of the database in...

Hello Gary.  To your questions:

>>  1.) Is it possible to create an index on a networked drive?

I don't believe so.

>> 2.) Excluding the possibility, is it advisable?

If it were, it...

Hi.  Your best bet is to use the "sp_helpprotect" system stored procedure.  Here is the syntax (from Books Online):

sp_helprotect [ [ @name = ] 'object_statement' ]

    [ , [ @username...

If you look at the last part of your select, you have a comma after the last column you select:

"Select

...

failure_address = 'shiprec@jhwright.com',

FROM         CommerceCenter..."

The last column in a select list...

Although the security log may be your best bet for catching this process, I may be able to provide some insight as to the cause of this error.  When a...