So .... what do you expect and want to happen if the resulting number cant fit into the storage space ?

Are you sure you want / need a decimal(18,17).

Thats an 18 digit number with a precision of 17 decimal places.

ie

1.12345678901234567

Try this for deadlock analysis

http://www.sqlservercentral.com/articles/deadlock/65614/

Try these for slow-downs

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Try this link for solutions

http://www.sommarskog.se/arrays-in-sql-2005.html

Ross McMicken (10/12/2009)

---

Would replacing the UDF's with tables containing the necessary data improve performance? I am thinking of the UDF that returns a 1 if the transaction is a peak...

Something like this ?...

select * from yourtable tab1 join yourtable tab2

on tab1.rowid <> tab2.rowid

...

Assuming that the codes are unique

insert into related(ParentId,Code2)

Select Parent.Id,

Code2

from Parent,

#TmpOther

where Parent.Code1 = #TmpOther.Code1

Else...

check out BOL for transaction isolation levels , you'll want READ UNCOMMITTED

BUT

here's a good example of that being a very bad idea

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

There's a few methods,

try this link

http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

Try this

SELECT *

FROM CUSTINVOICEJOUR

LEFT OUTER JOIN SALESLINE ON SALESLINE.SALESID = dbo.CUSTINVOICEJOUR.SALESID

...

Whatever , but as already pointed out , its not a moral argument , its a legal argument.

It you...

Must of skipped over that chapter in your book.

Try this

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

and this

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

My standard line is "I could try shouting at the server, but im not sure that will help".

I did have one particularly stressed...

Can anyone wave their magic sql wand ?

http://www.sqlservercentral.com/Forums/Topic799860-149-1.aspx

EDIT :

Maybe its ItalianOlgi's first day on the job