Alvin Ramard (11/12/2009)

Lynn Pettis (11/12/2009)

Alvin Ramard (11/12/2009)

AVG is not interchangeable with SUM. Was that written on the day the coffee pot ran dry?

AVG*COUNT might be interchangeable with SUM,...

UPDATE MyTable

SET [MyField] = SUBSTRING([MyField], CHARINDEX('/', [MyField])+1, 15)

Well, the windows error log is available using the event viewer. Start -> All Programs -> Administrative Tools -> Event Viewer.

The SQL Server error logs can be found in...

I should have noticed this at first look. The slow plan has created a plan using parallelism which actually could be the source of the problem. In a...

Since you are dumping this data into a report table, why not do the grouping on a smaller level say weekly or monthly and store that data? Then you...

Yes, SQL Server does base it's execution plans on the data, not the schema. SQL Server keeps statistics for the distribution of data in the tables and uses the...

Nabha has the right idea. You need to have a Use DB2 GO in order to change the database context.

I think you need your @COuntSQLQUery to be this: "Select @recordcount = count(*) from dbo.table1"

The question now becomes, why are you using dynamic sql for this?

Is it just the SQL Server service that is restarting or is the entire server rebooting?

I'm not sure what you are asking. Do you want to find the time you took the tail log backup or do you want to add a timestamp to...

Since you posted in a 2000 forum I'm going to suggest that you use 2 steps to solve the problem.

Step 1 - using a table variable or temp table load...

I would just remove SalesRep from the DesignLogo table and create an intersection table (I like to call them glue tables) with DesignNumber and SalesRepNumber, unless you have more information...

Sure the owner of the job does not exist on the new server.

You can't always trust all that DTA suggests. I'd be careful. If you are creating indexes and you have no complaints about performance I'd stay with what you've...

I'd still consider doing a server-side trace limited to that database. I think that it will have less impact than a trigger.