[font="Courier New"]select floor(13.890)[/font] returns [font="Courier New"]13[/font], but just for fun, here are the results for a couple of variations in SQL 2000 (one difference from SQL 2005 is shown):

[font="Courier New"]select...

Thanks for the great editorial, Steve,

Just for fun, I tried to figure out just how full the glass pictured in your editorial is.

Given the shape of the glass, I used...

EdVassie (4/11/2008)

---

In 32-bit mode, SQL Server 2005 SE can use AWE along with Windows /PAE switch to use memory above the 4 GB line.

Only the buffer cache can use memory...

GilaMonster (4/10/2008)

---

laker_42 (4/10/2008)

---

As Gilamonstor stated, if you are only using 4gb, you don't need to use AWE or the switches. Just set your min & max memory levels for...

Steven Cameron (4/9/2008)

---

I appreciate the difficulty in creating questions that can withstand the pounding on these forums. I do find it ironic when posters slam the question for being wrong...

Hugo Kornelis (4/9/2008)

---

Hi all,

I think this is a great question, though thwarted by an incorrect answer, unfortunately.

The question is great because hardly anyone knows exactly how this works. That is...

Thanks for the article, Steve. This is definitely one of those "easier said than done" jobs.

webrunner

Jack Corbett (4/7/2008)

---

I just have a couple of questions for all who have posted about this issue, did you respond to the QOD survey that was released recently? Also...

arvindravish (4/6/2008)

---

I am pretty upset about the fact that the questions posted doesn't seem to be appropraitely matching with the options specified in the list of answers.

I don't seem to...

OK, thanks!

webrunner

OK, thanks! Database A (the one at the 80 level) is a SQL 2000 database that was restored onto SQL 2005, so I am inclined to leave it that way...

SQLServerLifer (3/20/2008)

---

As the database begins filling up pages, yes, your PLE will drop. That is not a bad thing, Going below 300 is. One thing to look for are distributed...

I don't know anything about Oracle RAC, but I can bet that there are tens of thousands of DBAs who are looking for some kind of technology that would allow...

Thanks again to everyone for their help. This information will take me a little while to review, and I have already begun reading it.

One thing I would like to be...

Thanks for the replies!

I will read the link provided. Also, to Gail: We are running SQL 2005 Standard Edition. We have Lock Pages in Memory set for the SQL Server...