In terms of performance, also keep in mind that not all SAN's are created equal.  A former employer switched from one brand to another (Xiotech to EMC) and immediately we...

In terms of performance, also keep in mind that not all SAN's are created equal.  A former employer switched from one brand to another (Xiotech to EMC) and immediately we...

In terms of performance, also keep in mind that not all SAN's are created equal.  A former employer switched from one brand to another (Xiotech to EMC) and immediately we...

I'm always a bit hesitant to get too much into these kinds of discussions.  I don't know enough about the business requirements to make any detailed recommendations, but from what...

So basically the CompanySeasonTemplate overrides the CompanyEventTemplate?  In other words, normally Company A wants 45 days lead time for event 1, but in summer they want 30. 

Another way of...

Yes, and no.  The 8060 limit still applies to tables with fixed width columns, but if you have variable length data types in your table you can get around this...

All the time.  I've never met an AD admin that did like the idea of delegation, so this leaves you with SQL authentication.  However, you don't need to use sa...

You can use the net start <instanceName> to start SQL Server from within a batch file.  Then you could osql to attach the database and run some queries spooling the results...

For the purpose of future functionality I would use the ObjectProperty function with the CnstIsUpdateCascade or CnstIsDeleteCascade argument to determine cascade properties.

Generally, SQL does a good job of recovering after a sudden outage like that.  However, some IO systems can cause real problems.  Most modern IO systems contain significant amounts of...

If I understand your question correctly..., there are several ways to determine if SQL Server is running.

Check the Services to see if the MSSQL service is running.

You can register an...

The INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS  view supplies this information.

Specifically, a Latch is a lightweight lock, used by SQL Server as pages are read from disk into memory.

Check out Books Online for an article entitled "Displaying Locking Information"

I'd start out by verifying that the volume is available to that node.  Check with your SAN administrator to be sure that it was offered to that server, and then...