Thanks, I did reduce the max memory in SQL 2008R2sp1, and the current memory still grew back to 17GB. It appears that no matter what I put in for the...

Yes, i have the situation where the current memory is 17.8GB and the total mem is 16.6GB.

How do i correct this situation?

Question 2# on your screen shot, the page...

Thank for taking the time OLD HAND. I'm not sure why we are getting different results. I'm using SQL 2008R2 with no service pack applied. I guess it is either...

funny, the website took out all of the spaces or tabs from the results I just posted...

funny, I guess your website took out all of the spaces or tabs from the results I just posted....

I set ANSI PADDING to FALSE on the database. I also tried with it set to TRUE, same results... Why isn't SUBSTRING working???

Here are the queries and the results.... The...

No errors, just trying to get rid of the trail of spaces... SUBSTRING should work with the LEN() function but it isn't???

I unchecked the ANSI PADDING in the tools menu but the query still returns the padded spaces unless I manually type in the length of the text in that field...

Yes, you are correct the rtrim is not needed since I'm using substring function.

use master;

declare @x int

select @x=len(physical_name) from sys.database_files

/****

The above select statement returns (in my case) 90. But when we

put @x in the substring function, it returns the full size...

Dave, excellent job with the post! Very informative and good example to demo the technology.

Big Question: Where can I find the AdventureWorks2008R2 database?

I was running it against the AdventureWorks database...

Dave, excellent job with the post! Very informative and good example to demo the technology.

Big Question: Where can I find the AdventureWorks2008R2 database?

I was running it against the AdventureWorks database...