Viewing 15 posts - 751 through 765 (of 2,496 total)
The memory counter SQL Server Target Memory shows SQL's assessment of what would be the ideal setting for Max Memory for the given workload.
If the target memory is higher than...
March 26, 2012 at 6:32 am
As already said, read the links in the posts. Also check this link http://blogs.technet.com/b/askcore/archive/2009/02/18/how-to-configure-multiple-instances-of-distributed-transaction-coordinator-dtc-on-a-windows-server-failover-cluster-2008.aspx
SQL FineBuild can take a bare metal Windows cluster and install a SQL cluster. It...
March 26, 2012 at 4:11 am
you cant spread out the writes
Not strictly true. You can spread out the writes:
1 By very careful setup and operation of P2P. You need to assign ranges of...
March 26, 2012 at 3:56 am
Budget is the best reason
If your site has Service Assurance, then after your next SA review all your SQL instances will 'benefit' from the SQL 2012 licensing model. It...
March 19, 2012 at 8:54 am
I cannot remember which of these is SQL 2005 and which is SQL 2008...
You can get a record of P2P conflicts to be directed to a table. You can...
March 19, 2012 at 8:50 am
A few things about AWE...
The memory allocated as show in Task Manager always relates to memory used beklow the 4GB line. It is not aware of any memory allocated...
March 19, 2012 at 7:07 am
Changing a server name after SQL is installed takes time and money. Changing a SQL instance name also takes time and money. If you have already deployed this...
March 19, 2012 at 5:15 am
Having been involved in the SQL 2012 TAP program and tested numerous private and public releases, I am happy that SQL 2012 RTM is ready for Production use.
We...
March 19, 2012 at 5:00 am
You should also consider P2P replication.
P2P replication as advertised has a number of restrictions, but these can be overcome by having operational standards.
The main problem highlighted with P2P is...
March 19, 2012 at 4:13 am
SQL FineBuild can help you build your SQL Cluster.
As you are new to both FineBuild and clustering, I strongly recommend you get a virtual machine and practice installing SQL non-clustered...
March 14, 2012 at 5:01 am
I agree with opc.three.
We have gone through this in the past with Microsoft, and they are happy to consider our Dev cluster as only needing a Dev Edition...
March 14, 2012 at 4:32 am
You definitely do not need to give any of the SQL Server service accounts Windows local administrator privilege in order to run SQL Server.
The priviliges you have given the Agent...
March 14, 2012 at 4:29 am
You need to set up a Proxy account in order for someone without SQL Sysadmin privileges to use xp_cmdshell. BOL can tell you where this is configured.
All commands run...
March 14, 2012 at 4:15 am
Upgrading from SQL 2005 to SQL 2008 R2 is fairly painless but you must test all your applications with SQL 2008 R2 before upgrading your production system.
Ther are...
March 13, 2012 at 4:06 am
You must have a column group to use sparklines.
If you want to report on multiple periods, then design your data so that the periods can form the column group....
March 12, 2012 at 4:59 am
Viewing 15 posts - 751 through 765 (of 2,496 total)