You should be able to grant users & roles access to the Schema.

True. I guess you could use RANK for ties.

GilaMonster (1/15/2009)

---

Neither do we. I have a couple books and I'm seeing if I can figure some things out. It's hard. The coordination of the two is very difficult.

I'd love...

Ramesh (1/15/2009)

---

Since you are using SQL 2005, you have the windowed functions and the OVER clause....

Here is that query

SELECT *

FROM (

...

RichardB (1/15/2009)

---

Thanks jeff.

Well, the file might be 200gb. Not sure what the ordering is going to be like, but the original table is clustered differently to the final...

Deterministic just means that given the same inputs(parameters) a function will always return the same value.

Now technically this should make any use of data tables or current-state functions (like GetDate())...

I cannot think of any statement that is valid in a function that in and of itself would make a function non-deterministic. You would probably have to call something...

Jeff Moden (1/15/2009)

---

That's another good one. And, I've never seen it where they need to return an out of scope identity produced by @@IDENTITY... anyone ever actually do that?...

GilaMonster (1/15/2009)

---

Jeff Moden (1/15/2009)

---

I've been fortunate, recently... I've convinced folks to mostly NOT buy 3rd party software and, when we do, I get to grill both the software and the...

Chris Morris (1/15/2009)

---

GSquared (1/15/2009)

---

Grant Fritchey (1/15/2009)

---

Oh...

Jeff Moden (1/15/2009)

---

DavidB (1/15/2009)

---

See what happens when you leave people up in cold weather for too long. And you thought it was unsafe to go in the rural spots down...

Michael Earl (1/15/2009)

---

Chris Morris (1/15/2009)

---

Jeff Moden (1/14/2009)

---

Actually... I built a "cannon" to fire the potato part of the pork chop dinner. 5 foot barrel with a 5 foot extension...

Right, follow vikas's order of objects. The real problem comes in getting the Views ordered right (when they refer to each other) and the sProcs in the right order...

Also, in the future, please post your SQL 2000 questions in the SQL 2000 forums.

Follow Ramesh's link to Jeff Moden's article. Jeff is the "Sultan of Speed", and you are unlikely to find anything faster.