H4K (10/30/2012)

---

I think "0.00" did provide some part of the solution but you need to look for NULL's and handle them which is giving you the error, i guess.

Use the...

I changed...

Tim Paulsen (10/17/2012)

---

I believe you are having a data type mismatch issue. The sales value is a decimal and specifying "0" is an integer. You should be able...

H4K (10/15/2012)

---

For 2nd table, what is the expression for showing year where error occurred ?

I mean there are 3 years from 2009 to 2011. So which of them are you...

codebyo (1/24/2012)

---

And a more simplified version of Example 2 below: :blush:

SELECT YEAR(SaleDate) AS Year,

SUM(CASE MONTH(SaleDate) WHEN 1 THEN SaleProfit ELSE 0 END) AS...

Christian Bahnsen (1/24/2012)

---

I find a calendar table with pre-defined columns for month, fiscal month, etc., and other columns like YYYY-MM is invaluable for aggregating and sorting data like this.

Joining the...

This is a great way to get a running total. I would caution people you are trying to use this to get sales for your company. Everyone I have ever...

Update:

I limited the total memory given to the SQL Server, enabled locked pages, applied the hotfixes, and limited the PF size. I gave the server a restart which basically cleared...

Schadenfreude-Mei (9/28/2011)

---

Heres a random suggestion........ Do away with PF altogether! we dont use PF on our prod servers as they are unpredictable.

If your server is a dedicated db server all...

Yes, it says it is not required, but it doesn't say that it wont help keep the memory from paging out. I am aware that the AWE allows 32 bit...

It is a dedicated SQL box, so nothing but SQL is running on it. The only other thing I can think of is once in a while the server gets...

This is what I am assuming. For some unknown reason the server decided to page out all of the memory. After this happens queries that normally run quick run slow....

Any idea why the page file is so large? I was wondering if I needed more memory because of the size of the page file.

I know that SQL takes memory and doesn't give it back to the OS. I have it set to use 14GB of the total 16GB.

I guess my biggest concern is...