InfiniteError (9/26/2011)

---

thanks guys for all the answers.

Sorry if my example is not that clear. My example assume that all are the same (same number of records, indexes, where clause). Honeslty...

jared-709193 (9/26/2011)

---

Maybe a better way for me to phrase the question is this: "Is the ORDER BY clause ignored in the ORDER of the result set of a view and...

You are exactly right about the details, but you're drawing a conclusing that they don't support.

If you query the View without an Order By in the query calling the View,...

As per the documentation on SQL Browser, is it possible that your VPN configuration, or one or more routers, are blocking the UDP packets that SQL Browser uses? If...

I guess I'm not clear on what you're asking.

A view is just a pre-written Select statement. It doesn't store any data except the query. When you query a...

While I agree with the cynical bits about never getting agreement from the exact people who are the biggest block in getting the job done, I also think Tony's request...

The usual way to do that in 2000/2005 is to join to the target table in your Select From and set up that query to exclude any rows that already...

Won't happen if you use stored procedures in the database. It's because of inline SQL. Not much SQL Server can do about that.

AWE is meaningless on a 64-bit system. Won't turn on, even if you tell it to, because it's just a way to get 32-bit systems to access more RAM.

If...

IceDread (9/22/2011)

---

I do...

I didn't realize it would do that.

I tested on a multi-million row table, and I get a scan of the right index, instead of a seek, but it is a...

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

---

djackson 22568 (9/21/2011)

---

...

And you want us to worry about things like whether a business is closed?

...

We are fighting against significant odds of success. I...

djackson 22568 (9/21/2011)

---

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

---

djackson 22568 (9/21/2011)

---

...

And you want us to worry about things like whether a business is closed?

...

We are fighting against significant odds of success....

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

---

GSquared (9/21/2011)

---

On the point of Linux "not taking over the world", keep in mind that iOS and Android are both *nix-based systems, as is OS...

Stefan Krzywicki (9/23/2011)

---

GSquared (9/23/2011)

---

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

---

Grant Fritchey (9/23/2011)

---

GSquared (9/23/2011)

---

Grant Fritchey (9/23/2011)

---

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

---

Now I feel like an idiot and a little naive for using...