If you are on SQL 2005 then you can look at the default trace to see who created the login.

J-F,

If this is an OLTP system, I would go with your proposal with the FK in the InvoiceDetail table. The only thing that you would need to ensure that the...

Look for the largest table / clustered index. I figured that my largest table is 22GB and has a clustered index so in order to rebuild it each week, the...

Looked for it under

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib

for the default instance

Are you using Windows Authentication? You could try to connect using both domain / sql authentication. If domain auth, make sure the accounts aren't locked out.

Is this instance in...

Even though Windows 2008 lends itself to stretch clustering, it isn't as straightforward for SQL Server 2005 and even SQL 2008. Like Jerry mentioned, you will need to setup a...

I second the search engine reco...

I did a search for "New DBA" on this site and got back quite a few articles etc...

Have you tried using query hints (nolock)?

Here's my 2c on cluster install. Another good Microsoft resource is

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en

Pre-requisite

1.Hardware and Software Components are certified under the Windows Server Logo Program for Windows 2008 – necessary for...

You could also use dynamic sql to do this.

Glen,

Are you using instant file initialization?

If not, how long does it take for SQL Server to restart or in case of a cluster to failover? Actually, the failover is instantaneous,...

Since this is the first cluster, I'm still testing this setup. 8 minutes is definitely excessive.

This is Microsoft's recommendation, but what are other DBA's doing out there?

I haven't enabled instant...

tempdb is re-created each time SQL Server is started. I wouldn't create such large files since SQL Server will take a long time to restart since tempdb needs to be...

You could also ping the Client IP address and find out who owns the machine on the network. Its probably an old job that was setup and forgotten about.

You could run Perf Mon to identify whether disk IO is an issue.