The /3GB is optional in your case. Like I said, since in the virtual memory space it forces the kernel into the last 1 GB (giving 3 GB contiguous to...

We're doing a side-by-side as well. In our case we're going to script the changes as we're also looking to clean-up a bit the security model wherever we can. It'll...

What is the total maximum size of a row (record) given the 6900 bytes?

3) Reliability/Availability. Do you want an application bug to blue screen your domain controller, thereby resulting in a denial of service for your DC?

The technique goes something like this:

declare @values varchar(100)

-- note the change with the addition of commas

set @values = ',1,2,3,4,'

select *

from table

where charindex(',' + col1 + ',', @values) >...

Where to start? How about an editorial that appeared yesterday!

Editorial: Keep 'em Separated (Bill Boswell)

Or this:

Perform a Secure SQL Server installation

The quote...

You don't have to have the /3GB to access the additional memory, but that switch does cause the OS to use only up to 1 GB in the virtual address...

There are several ways to go about this. You can do so via a linked server connection using the ADSI provider or you can use the ADSI objects in a...

We've seen this situation with a "loopback" linked server, which is what your setup is. The following Microsoft article contais a different 7391 error than what you've posted, but we...

There is an advantage to using dbo in the create object scripts. You might have a cause where you are logged in as a user that has the ability to...

Generally, if you don't need something you should not allow the behavior. This blocks non-sysadmin level access to adhoc queries. Keep in mind that it doesn't stop adhoc queries executed...

Not without making them the actual database owner or aliasing them as dbo. An alternative might be to run a script periodically that finds all objects not owned by dbo,...

Yes. Specify the owner with a two-part name. The user execting the script must either be a member of the db_owner or db_ddladmin database role. For instance:

CREATE PROC dbo.usp_MyProc

AS

SELECT 1

The...

An application by default will only use a maximum of 2 GB of memory. This is a limitation imposed by the operating system. If you want SQL Server to be...

We've offloaded some server monitoring and print management responsibilities to a couple of network engineers (with OJT) because they're workload has been light and ours has been pretty heavy. Perhaps...