I see. Thanks for the explanation.

Something like this?

DECLARE @Example TABLE

(

id INTEGER NOT NULL,

amount ...

daveriya (9/16/2011)

---

i have one column in which i need to do sum for every id and then i need to do total of that sum.is ther any function in sql...

Better still, write a set-based T-SQL query instead of trying to use...

Happy to report that I am first to get this right.

I don't enjoy this sort of question though - I am a human, not a T-SQL parser.

The question could have...

Exactly. I can only imagine the author did test the code before submitting this question, but made a late change to...

I agree with pretty much everything else you have said in this thread - but this statement is a bit harsh.

DTA does a pretty...

Any subquery expression will do. This simpler (no join) form does not qualify for trivial plan:

SELECT t1.ID,...

The question of fragmentation is an interesting one. Assuming we don't use a GUID as the clustering key, what's the issue here? It is in the nature of...

Steve Jones - SSC Editor (9/14/2011)

---

The stats I saw in late 2008 showed Enterprise selling about 25% of Standard. So most DBAs never get the chance to use EE or...

HowardW (9/14/2011)

---

Being a bit pedantic, but I've read that article before and some of the arguments against also apply to the default READ COMMITTED isolation level. In either case you...

Statistics is really not my thing, but I thought I would mention a post by Rob Farley recently:

http://sqlblog.com/blogs/rob_farley/archive/2011/08/23/t-sql-thoughts-about-the-95th-percentile.aspx

Might be of interest.

zapouk (9/13/2011)

---

I need to somehow find the last non-null running total and it can't be right to use a cursor to go through all 1 million rows just to find...

There are many ways to express this requirement in SQL (some would say too many - and not one that is a straightforward as the natural language form of the...

Evil Kraig F (9/13/2011)

---

And the difference between a Level III and a Level II on staff is thus clearly indicated. 😎

While everyone should strive to this level of understanding,...