Ah-ha, let's take a bit further (note I never used DATENAME before so forgot it was there and that it returns a character string as opposed to an interger).

DATENAME( yyyy, datecol)  +...

Does make it smaller code wise but in memory it has to do extra work setting up the format from the convert (note also does a table read in master to...

I am not 100% sure but I believe you are referring to schema in Oracle not namespace. And use tables can have dirrent schema owners (object owner) so you can...

Are you saying you are selling? Reason I ask is Learn Key has a whole but of SQL Stuff on Ebay.

Ok, did you get a list of all services and active applications at the time?

Suggest use msinfo32 to get a snapshot fo the box when that starts and compare each...

sp_cursor_list

From BOL

"Reports the attributes of server cursors currently open for the connection."

Note only returns local cursors for the current connection it is ran on or any Global cursors. I can't...

Second answer is correct.

However if you need to seperate the instances and the server master, errorlog and log checks out then see if you have duplicates of the databases in...

Just wanted to point it out. Has no real major barring on the code as a whole except more compact. There is probably even better ways I have seen or...

Quite alright. Enjoy posting frequenetly as needed and see if you can help others solve their issues also, best way to learn anything is to find a problem.

Use will work and is considered better syntax than convert. Same thing basically thou.

CAST((value / 10.0) AS NUMERIC(10,2))

This would be better

CAST(DATEPART(yyyy, @dt) AS CHAR(4)) + '-' + RIGHT('0' + CAST(DATEPART(m,@dt) AS VARCHAR(2)),2)

Is field1 indexed? And is it used often? Finally run it once normal but run

SET SHOWPLAN_TEXT ON

GO

Before it and post the execution plan here so we can take a look.

I agree that is a possibility but I would be curious as to why and if restarting SQL Agent still has the jobs run. If does then has to be...

Based on the error it is barking about this

  Insert Into EmployeeTerritories1

  Select *

  From Inserted i

   left Join EmployeeTerritories1 ET

   On i.EmployeeID = ET.EmployeeID

  Where ET.EmployeeID Is Null

Do both...

Depending on the data size it can get intensive. But to add to the temp table idea you can also do this to conserve a bit.

INSERT INTO #Top

(chCustomer, chLocation)

SELECT TOP...