Viewing 15 posts - 1 through 15 (of 90 total)
This thread is a little old, so please bear with me.
SPNs and Kerberos work, but for a 2003 cluster, they are not created automatically. When using SQL in a...
February 6, 2010 at 6:44 pm
I guess the reason noone has responded is because there is no answer.
You design a solution to meet requirements. You have asked a pie in the sky question about...
June 10, 2009 at 8:16 am
To address more than 2GB of VAS on a 32bit server you will require the /3gb and /pae switches in your c:\boot.ini
Then enable AWE in your sql server instance.
June 6, 2009 at 10:48 pm
The "best" setup from a security standpoint is balanced between least privilege, the implementation, support overhead and understanding how it works.
I would say use a service account with the relevant...
June 3, 2009 at 7:14 am
Jeff Alexander has a link to a Microsoft IT article describing how they recently consolidated their SQL installations.
MS provide services via the Compute Unit and Storage Unit. With SQL...
May 23, 2009 at 5:49 am
Your application should be what is providing an output in a particular format, not SQL Server. SQL provides a data layer.
Previously to output MS Office documents you had to...
May 23, 2009 at 5:42 am
SQL Server will attempt to use all the memory available - if you let it. You should set the MIN_MEM and MAX_MEM options appropriately for your system. I...
May 23, 2009 at 5:35 am
A Full Backup backs up everything you point to
A Differential Backup backs up everything you point to that has changed since the last Full Backup
An Incremental Backup backs up everything...
May 19, 2009 at 9:21 pm
Thanks for your...
May 18, 2009 at 4:43 pm
Virtualisation is a great tool - however you still need to test your particular environment. Also, not all solutions meet the requirements of every problem - eg, depending on...
May 17, 2009 at 9:38 pm
I have never seen a database backup agent that didn't cause problems.
As a rule of thumb, never use database backup agents from backup software. It is much better and...
May 17, 2009 at 7:51 pm
Here are the details abt my env...
I am migrating db sql2k -->sql2k5 where sql2k5 is running on 2 node cluster. and to balance the node separating the...
May 16, 2009 at 7:14 pm
Thanks for the help.
By 'particular location' , do you mean clients expect WKS or SQL Server Browser service to be on port 1434 and they will not...
May 16, 2009 at 7:01 pm
SQL Browser provides a Well Known Service (WKS) and clients expect it to be in a particular location.
If you wish to remove the Browser service (please do, it's awful, cumbersome,...
May 15, 2009 at 10:37 pm
Some people use separate tables, some use separate databases.
This is where table partitioning can be of great benefit. In SQL 2008, you can now use the SWITCH...
May 15, 2009 at 10:34 pm