r.pe (6/4/2012)

---

There are many things that should be rewritten as the filteredviews are drastically slower than native table calls. There are support and contractual issues that are outside the realm...

To be honest, I would have the developers of this part of the application do this date conversion after the data has been retrieved. I would not be doing...

Well, all I can say is that this is a mess. There are function calls within the function that I cannot see the definition of. This huge thing is being...

This DDL does nothing for me as I cannot see data types or the function. Let's assume that it is the function, as the only difference between the 2...

And how do you know that it is the function and not some other aspect of the report? Can you please post the report definition or the query that...

How do you know it is causing blocking?

You could always upgrade to 2012 and use one of the new window functions 🙂

http://msdn.microsoft.com/en-us/library/hh231256.aspx

So, going back to my Great Plains days, I realize this is a sales table.

1. Why are you deleting data from a Great Plains table when you don't truely...

David Webb-200187 (6/1/2012)

---

how about:

delete sop10200 where sopnumbe = 'XXX1234' and (dex_row_id >= 001

...

isuckatsql (6/4/2012)

---

SQLKnowItAll (6/4/2012)

---

isuckatsql (6/4/2012)

---

I have four years of data that i would like to partition.

Would it be best to do four partitions on one year, or eight partitions on six...

Another thing that I would try is to update without the ISNULL function. So, you are updating with NULLS. Then... Do a second update on tableA and simply

UPDATE...

isuckatsql (6/4/2012)

---

I have four years of data that i would like to partition.

Would it be best to do four partitions on one year, or eight partitions on six months, and...

It looks like it is in the WHERE condition and the alias is...

isuckatsql (6/4/2012)

---

SQLKnowItAll (6/4/2012)

---

SELECT...

So you start with selecting the columns you want to group by, and finish with the column(s) you want to sum or aggregate. You should have a group by clause...