SQL Server will manage it's own memory, so from the OS all you'll see is that SQL Server is using X, in this case 5gb. You can limit the amount...

First, I'd strongly suggest switching to ANSI 92 syntax

SELECT...

FROM a

JOIN B

ON a.id = b.id

Second, you don't have any kind of filtering, so the query is going scan all the...

It's also possible that you're getting statistics updated, but the standard statistics update is sampled. You might need to update the statistics through a full scan, which does happen as...

The best straight T-SQL book out there, in my opinion, is Itzik Ben-Gan's Inside T-SQL Querying. Fantastic. It should do most of what you need.

Layne-812700 (10/15/2009)

---

whatever size or type of data I use, they present the same result. You might disagree, but the first one is only a shortcut in my opinion.

Also, had a...

Unless there's just...

GilaMonster (10/15/2009)

---

Excellent. This looks about as...

Me neither.

There isn't a single value that I can tell you to give to that. It really depends on your system. You might have some huge report that pulls together thousands...

No. We're hitting issues with the tool that generates our geographic shapes not properly closing all the polygons it generates (and occasionally generating polygons with lines that cross...). We can't...

I'm sorry, I'm still stuck on what it is that you're trying to do.

Also, because I'm just not going to try to type your code into my system, if...

P Jones (10/15/2009)

---

It isn't the badly phrased, minimal information questions which make me see red but the posters who, given a line of research or something to try, just say...

More excellent answers.

And yes, Darwin had a heck of a beard. Maybe it's time to grow mine again.

Bob Hovious 24601 (10/14/2009)

---

What next?

"You'll have to get the rest of your question answered by someone else... they're about to close the casket, and nobody bothered to put extra batteries...

jcrawf02 (10/14/2009)

---

Grant Fritchey (10/14/2009)

---

GilaMonster (10/14/2009)

---

I haz two tables and no question

http://www.sqlservercentral.com/Forums/Topic803081-338-1.aspx

Some else can have the pleasure of this one. I'm going to spend an hour trying to conquer the galaxy,...