Thanks. I think your tag sums it up well...

"If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT...

In other words, that query possibly might help?

Thanks (again). Based on what you said, is there any queries etc that would clean up the indexes?, that was kind of what I was hoping to do...make it...

Yes, I meant the procedure, not dbo...I got the command from another website (http://codetempest.blogspot.com/2010/08/ola-hallengens-maintenance-stored.html). I'm trying to defrag the index on the database. I had a query...

Thanks GilaMonster,

so I ran the command you posted, and it turns out that dbo doesn't in fact exist in that database...so now I'm wondering, how can I optimize the database...

I'm running the query in the same DB that I parse. I tried adding in the db name, again, I get 'completed successfully' when I parse, and get the...

Thanks again to you both, I guess that I'm stuck w/4gb till I upgrade one way or another.

Thanks Michael and Shawn,

Michael, isn't the point of the AWE switch in SQL to allow it to access memory beyond 4gb when the OS is restricted to 4gb?

Shawn,...