Thanks very much people. Just that from some people's posts on the Internet I was beginning to get the impression that I should see this value reflected in the startup.

Fine,...

Hi,

I am using the /PAE switch NOT the /3GB.

The results of the query are below:

physical_memory_in_GB-----------------------------16

VAS_GB------------------------------------------------2

buffer_pool_committed_memory_in_GB-----------1.62

buffer_pool_target_memory_in_GB----------------9.77

Min Server Memory (GB)---------------------------- 0

Max Server Memory (GB)----------------------------9.77

The OS is enterprise edition sp2 and has 16 GB RAM installed and visible to the OS.

Thank you so much Zach.

Thanks so much Zach.

Finally (hopefully :-)), did you use separate disks for your partitions? How bad can putting all your file group on the same disk/spindle be? (due to cost...

Thanks very much Zack.

You mean SWITCH really works that fast? That will be great.

The table I am refering to is mostly used for reporting anyway, we just need to manage...

Hi,

Can I get notification of the latest patches spcifically for SQL Server 205/2008. I subscribed to Microsoft Security Bulletin but most of the information is on the OS.

Thanks

An additional eye-opener for the intended Hardening in our environment.

Thank you. 🙂

Nice article Zach. I think this will work for me. I have a very large table in my production database. The consultant has exonerated himself from any adverse outcome...

Yeah thanks. That makes sense.:-)

Has anyone worked on dealing with the schema changes made by replication (adding a rowguid column).

I am getting loads of errors... any help please:

------------------------------------------------------

The term 'else' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelli

ng of...

Hi All,

I also had this error in my environment. I would like to know how it is related to this one (assuming anyone has a quick answer):

A significant part of...