There may be a better way to do this but the below query works.

select o.ID,o.Ordernumber,o.Total,ot.OrderTotal

from #orders o

inner join (select sum(total) as OrderTotal,ordernumber from #orders group by ordernumber) ot on o.ordernumber...

No, if you try deleting the server login the mapped database users will not be deleted as well. You'll have an orphaned user(s). You'll get a warning message...

Can you import the data into a staging table, do your data cleanup, and then insert the data into your intended target table?

That's what I've always done when inserting data...

I would wait too...I haven't had a chance to play around with Denali too much but it sounds like it has some cool new features.

Which brings the next...

ulteriorm (12/20/2011)

---

@bwolfe : yes the...

Have you verified that though? Did you do a select without the column_name to see what was returned?

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS c

WHERE TABLE_NAME = 'Stores'

GilaMonster (12/20/2011)

---

bwoulfe (12/20/2011)

---

GilaMonster (12/20/2011)

---

bwoulfe (12/20/2011)

---

If you want to measure the impact of an index you could also set statistics io on and look at the differences in scan count, logical...

GilaMonster (12/20/2011)

---

bwoulfe (12/20/2011)

---

If you want to measure the impact of an index you could also set statistics io on and look at the differences in scan count, logical reads, physical...

To add to what Ninja said the clustered index scan is just a table scan. If you want to measure the impact of an index you could also set...

Gianluca, your script looks very similar to what I've been using the last couple of months. It works awesomely....

http://www.heydba.net/2011/05/get-dbcc-checkdb-output-tool-for-sql-server-2005/

I am using this book to study for the exam. It is just OK. Glazes over all the exam content but doesn't go into too much depth on...

If I'm reading your post right, you need to know how many DepartmentID's you have for the given filter criteria? Would a distinct count of DepartmentID's work?

SELECT COUNT(DISTINCT DepartmenID)

FROM...

Whatever configuration you decide on...test the crap out of it if possible. From my experience, once your hardware is setup and running it's next to impossible to get someone...

I've used option A before with pretty good success. But my situation looked a little different. I had a search parameter for a stored procedure that the developers...

LOL...didn't even realize this was from 2010.