Dana, Thomas, Revenant, Koen, pchirags -

You are welcome!

Diana

Tom – Thank you for taking your time to reply. I understand what you are saying about storing rows from memory into CPU cache.

For more detailed information, try these:

Tom - What is the "hardware cache line length"? Do you know of a reference I can read about that?

Thanks

Diana

IgorMi and Steve - You are welcome!

Diana

Ron - I am happy that you learned something.

Diana

I teach online at Kaplan University. There are serious disciplinary actions taken if students plagiarize.

Here is some code I wrote to illustrate GROUP BY. First, the table is...

When the question says "I then execute (second SELECT statement) that implies to me that you execute ONLY that SELECt statement, which would give an error, as the variable is...

In past versions of SQL Server, the SQL Server Agent service account needed Windows Administrator rights on the local computer in order to successfully restart the service when it stops...

Indexes on computed columns will not be used - is also true.

From Books Online article "SET (Transact-SQL)"

"When you are creating and manipulating indexes on computed columns or indexed views, the...

I apologize for not being able to give this forum the attention you all deserve.

My Mother is in the hospital and gets out today. I must bring her to...

The wording in Books Online is quite misleading.

First of all, here is the URL for CREATE LOGIN (Transact-SQL) that has the information you quoted: http://technet.microsoft.com/en-us/library/ms189751.aspx

Here is the...

You can create a login with both CHECK_POLICY off and CHECK_EXPIRATION off.

My impression is that if you then (ALTER LOGIN) set CHECK_POLICY ON, that will not automatically set CHECK_EXPIRATION on.

):-D

Books Online never said which policies were associated with which login option. That's why I performed the experiment.

):-D

Is your URL source different from and later than that posted by Chad Crawford? His dates from February 2005.

):-D

Thank you for the reference. I had not been able to find any articles that were so definitive about which password policies went with which login option.

):-D