Are the statistics updated?

you will have to validate your data being inserted before inserting.

Can u give us the table structures and sample data and explain your issue according to that?

check whthr this works

SELECT

ID AS ID,

Location AS Location,

SUM(Quantit) AS TotalQuantity,

SUM(Cost) AS TotalCoast,

D.MaxSaleDate

FROM

OrderData O LEFT OUTER JOIN

(SELECT ID, MAX(DATE) as MaxSaleDate FROM OrderData WHERE type =...

GilaMonster (10/31/2008)

---

Exactly the same. The...

Sorry cant give u the whole query...

Why dont you use a derived query that just selects the max dates and the ID and then join it with the query that...

GilaMonster (10/31/2008)

---

Chirag (10/31/2008)

---

Say there is a big data modification (update statement) going on and not all pages affected by the update stmt are in the buffer/memory. Will the pages not...

Hi Gail

Nice article... presented in very easy to understand manner

One question may not be entirely related to this topic

Say there is a big data modification (update statement) going on...

my 2 cents

Since u can access only thru SSMS ...

Create a parameter table that stores the list of parameter values.

Create a parent procedure that fetches the parameter values from the...

A "different" topic to write a article on.

XML is not my strong point, but if you provide more details regarding your data and table structure maybe we cud try.

We need more details BUT....

Select sum (Premium)

From MyTable

Group...

You could write the alert related code in a stored procedure if you are using a stored proc to insert data. BTW what sort of alert did you have in...

Any specific feature you plan to use in SQL 2008. If your application is running fine on SQL Server 2005 and you are'nt going to use SQL 2008 feature(s) then...

identity column is the way to go. you can also look to increment it programatically.