Sean Lange (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

With "the one", do you think it time to tell him the following?

1. Get out a blank piece of paper.

2. Put your name and today's date...

it would probably be best to continue the discussion in the old thread.

http://www.sqlservercentral.com/Forums/Topic1283875-392-1.aspx

SQLKnowItAll (4/16/2012)

---

My guess is that data is not actually there. How do you know it got refreshed? Can you use a SELECT * and verify that the data...

Lynn Pettis (4/16/2012)

---

GilaMonster (4/16/2012)

---

This is one area where I and many others disagree with Book Online. Set the max server memory always. See chapter 4 of the book I linked...

im looking at a table with close to 300 million records with proper indexes and have no problems. the key as people have stated is the proper clustered and...

when posting code i always put the semi colon infront of the...

you have a very vague question. can you post more detail and maby table deffinitions and sample data.

Phil Parkin (4/15/2012)

---

edvard 19773 (4/15/2012)

---

Still thanks for having solved my immideate problem!

I am aware of, that your solution is much faster than a row by row solution, and in this...

vinu512 (4/13/2012)

---

Seems like ETL to me. The various branches can accumulate the data in XML form or in the form of Excel sheets. This data can then be mailed to...

i would hazard to guess your user is not authorized to the login to the server. in which case you would need to contact the system administrator.

are you editing out your user name or are you not providing a user name?

we have no code to help you with, you have...

that creates all of your counts. you will need to modify the queries to get your wheres back in since i saw you included only one OrderHeader_ID

ok here we go here is the code:

;WITH finding AS (select oa.id, oa.Risk_Rating, COUNT (orf.Prnt_ID) findingcount

...

Duplicate post all replies here http://www.sqlservercentral.com/Forums/Topic1282601-392-1.aspx