I hadn't considered the SQL Injection aspect of this question. Thanks for pointing that out.

Toreador (1/28/2010)

---

"if a number larger than one is used, it is converted to one."

I thought the actual explanation was that anything other than 0 (false) is treated as true and...

Thanks for the question! I did not know you could do that (but apparently I am in the minority). :hehe:

I hail from Ozark, Missouri by way of St. Louis and Cedar Falls, Iowa. And hailing is something we see more often than most areas.

I noticed that also. I think it was written by Steven Wright. "I had a premonition of a flashback."

Richard Sisk (1/13/2010)

---

I'm confused. The question asks about the severity below 10, yet the link to documentation address the severity level of 10.

So is there a special meaning to severity...

Ernie Schlangen (1/12/2010)

---

Can someone verify for me that this is different in SQL 2008 vs SQL 2005? I get a different result using 2005 (I don't have access to...

Nice question, took some thought. Thanks.

Robert Frasca (1/11/2010)

---

Cliff Jones (1/11/2010)

---

Again, in order to use these APIs, you must have the 'lock pages in memory' privilege set. This is why for 64bit systems, you don't...

Yes I did. Apparently I do not interpret it the same way that you do. I took the following to mean that you did not need to...

Robert Frasca (1/11/2010)

---

The answer is incorrect. AWE can be used in 64-bit and some people recommend that it should be set because it helps SQL Server manage memory by...

Glenn Berry has a good article on the subject on this site.

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

foxxo (1/7/2010)

---

I selected "nothing" however I've had issues in the past with the default "max server memory" setting being set at 2147483647 MB on 64 bit systems. Setting the...

I agree.

This is a good question. I was able to get it right without having the Northwind database however I had to assume that there was 1 and only 1...