May I suggest that you start running scheduled T-LOG backups? This will help manage the size of the transaction log and make database recovery a bit easier.

Our AV program is set to exclude the data drives and only scans out-bound files. Haven't had any performance issues.

I'm confused. Please provide the DDL (CREATE TABLE statement(s)) for the table(s) involved, sample data (as a series of INSERT INTO statements) for each table (data should not be...

Problem, we can't see what you see from where we sit. We don't know how your data is stored, nor do we know the structure of the table involved....

Can't help with the crashes, but I did want to respond about the SP 2 comment.

In the information returned by @ @VERSION, SP 2 refers to the OS, not SQL...

Nevermind, Gail responded before I could find the reference below.

You might, might, be able to attempt a tail log backup of the database. Check this out: http://msdn.microsoft.com/en-us/library/ms179314.aspx.

Other than that,...

GilaMonster (6/11/2010)

---

I hope...

Try this:

select

ma.*

from

#Model_Aggregate ma

left outer join #Toman_Aggregate ta

on (ma.AggID = ta.AggID

...

You are only showing us part of the problem. Please provide the entire query, and if it is a stored procedure, the actual procedure.

Some people really need to RTFM, or in this case, BOL.

davidshephard (6/11/2010)

---

Thank you sir,I have been working on this for three weeks,but I added the year parameter and get an error message:

USE [Galactic]

GO

DECLARE @return_value int

EXEC @return_value =...

CirquedeSQLeil (6/10/2010)

---

Lynn Pettis (6/10/2010)

---

I'm not going to try and answer many of the questions, comments, or concerns regarding soccer (football everywhere else in the world).

Here, however, is my two-cents.

Soccer is...

1) Each nvarchar column takes twice as much space as the cooresponding varchar/text column.

2) Due to increased record size, fewer records per page.

3) Any indexes on the nvarchar columns or...

As others have...

I'm not going to try and answer many of the questions, comments, or concerns regarding soccer (football everywhere else in the world).

Here, however, is my two-cents.

Soccer is a simple game...