First the general stuff:

Where I work we isolate SQL Server from other applications wherever possible but sometimes we don't get away with it either.

Capping the memory will ensure SQL...

If you had separate physical drives, you could create multiple .mdf files on each of the drives in order to reduce disk contention. That's the main reason for doing so.

As...

You can check the model of your SCSI array controller and see if it supports read/write caching. A controller with a write cache performs significantly better than one without if...

It may be due to the drivers/software which enables Windows 2K to think those shared storage arrays are physical disks. Are you up to date on the drivers/software/firmware?

Also, what does...

Microsoft's official response is SQLMail is not supported on cluster configurations because Outlook and MAPI don't have cluster support. However, we use SQLMail on our clusters here. Here is the...

I believe ODBC might have a default setting. One thing you might want to do is check the network libraries. If the application is connecting to the DB server over...

On your INSERT, you can use a DEFAULT constraint to put a value in the column if no value is specified.

If you need to handle in a trigger to cover...

From a performance standpoint, you may want to look at OPENQUERY() as it is a pass-through mechanism if you have a complex query or the table is fairly large. OPENQUERY...

Suck up the professional conferences if you can go. I used to help run the Air Force Information Technology Conference (open to US military and gov't only) and our attendees...

Sounds like a double-hop issue. Are you still under an NT 4 domain or has your organization gone to Active Directory with Kerberos?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

I've switched roles, but here's basically what I did when I was a full-time DBA:

1) Check logs for security issues

2) Check logs for errors thrown by SQL Server (for instance,...

You need to get the max ID for all the Status_ID = 40 rows. This requires a subquery.

Join that to back to the original table that has been parsed down...

It's partially on the MAC (or a psuedo MAC if there's no NIC) and also on the time, but I don't know to what slice... so while it wouldn't affect...

Try this:

CREATE TRIGGER Update_Foro_Member 

ON [dbo].[tblCliente]  

AFTER UPDATE

AS 



IF NOT UPDATE (Cl_Estado)

BEGIN

  RETURN

END



IF NOT EXISTS (SELECT F.MEMBER_ID 

      ...

Andy I agree with you, but am providing the standard warning. I've been burned on NICs with the same MAC address once upon a time, after...