Dear Joe,

in order for the OS to see more than 4 GB or RAM you need to give it eyes . this is PAE .Once you add /PAE virtual memory...

assumptions :

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

-> you have 2 folders .One which SQL Server is using currently .Two where your database copy is residing

Steps :

----------

Step 1 :

sp_detach_db 'test' or drop database test

Step2...

Parallelism will help you for sure but not always ...it depends upon the balance between the resource consumption and time to execute .. you need to test and find how...

I have not seen your enviornment but i can certainly guide here .

RequireKerberos is the Dword registry value that ensures whether you are using kerberos authentication or not for a...

I am doing exactly what you are doing on SQL Server 2008 SP1

Not sure what is the issue ..Just try without using @sql and write the complete query

Alter proc...

we use Kerberos for better security .otherwise the default is NTLM .Not sure where the issue is .

Can you share the complete error message please ..that will be helpful .

If...

Just to add , it will be with full scan i.e. 100% sampling ..:-)

From BOL (see the bottom)

http://msdn.microsoft.com/en-us/library/bb677167.aspx

Updated content

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

Removed the incorrect statement that automatic page repair is limited to SQL Server 2008 Enterprise. SQL Server 2008 Standard also supports...

I am writing a topic on it and will show you how i resolved this issue .

THe gurus can guide after looking the scripts .To me it looks like a...