I gave it a try. I used a Solomon Accounting Database, I have some huge (10 gigs) and gave it a try. I used tables with a lot more complicated...

I just remembered where I saw something like this, I had a client that was assigning ip addresses from the web. Whenever the web went down, everything went down, hard....

Application Log, System Log, SQL Server Logs.

You can run a SQL Trace, from another machine to see if anything running a horribly written query and killing the machine. Doesn't...

I read it wrong then. I get that problem when attempting to repair.

Did you try spacing things in the plan further apart? It could be stepping on itself. But if...

I've seen this many times. It happens to me when it tries to correct indexes and someone is still logged in or they a login has stayed active to the...

Use rowcount to limit to as many as you want, make sure you set rowcount to 0 to turn if off after you are done.

Set RowCount 50

Select * from...

Indexes a must. Sometimes filtering data will speed things up and order of tables first. Col035 and phone should both be indexed. You can add a query hint with the index name...

My assumption would be that last name is everything after the last space in the name. first Name is everything before. I've done it pleanty of times and it has...

Dynamic SQL is the only working way. Try this, although no SQL statistics can be calculated on it:

declare @partition varchar (6)

, @enddate varchar (15)

 , @NoOfPar int

set quoted_identifier off...