Viewing 15 posts - 841 through 855 (of 2,496 total)
If you are new to clustering, take a look at SQL FineBuild. This can install SQL Server as clustered or unclustered. For a cluster install it can also...
October 12, 2011 at 7:53 am
Be aware that revoking Public access to all objects may break SQL Server and take you outside of Microsoft support.
The DoD documentation makes it clear that you should not just...
October 12, 2011 at 7:45 am
Full text indexing has some built-in word breaking features that you cannot override. For example, the string 'BigImage+16:9+FP' is broken down into the tokens: bigimage, 16, nn16, 9, nn9,...
October 11, 2011 at 2:55 am
Where does your company want to spend its money? On isolating the impact of SharePoint in its own Windows instance or in the extra admin cost of running everything...
October 11, 2011 at 2:38 am
SQL Server uses what is called a 'shared nothing' approach to clustering. If you have Instance 1 running on node A then it has exclusive use of the databases...
October 4, 2011 at 4:31 am
If you aer getting a 'developed world' level salary, then probably the best GBP £200 you can spend is on a TechNet subscription. This provides you with all the...
October 4, 2011 at 4:13 am
The security permissions documented in the FineBuild reference manual will cover the OS side of your requirements. One of the principals used in FineBuild is that nothing should need...
September 28, 2011 at 3:38 am
If you have multiple instances of SQL Server, then you need a <ServerName> node that describes each instance. I am not sure the question makes this clear.
If you use...
September 28, 2011 at 3:17 am
I have found problems when I install a SQL 2008 R2 cluster followed by applying SP1. What I always do now is build a slipstreamed install media set containing...
September 27, 2011 at 4:50 am
It is now considered best practice on W2008 and W2008 R2 to have a separate instance of MSDTC for each node that will be active in a cluster. This...
September 26, 2011 at 6:57 am
The SQL Agent account is the first account checked by the SQL install process.
If there are any issues in performing authentication with Active Directory, then this will be...
September 26, 2011 at 6:20 am
All SQL instances will have their own master and resource databases. Both databases are updated when you apply a SP or CU, and need to be at the same...
September 26, 2011 at 5:33 am
My advice: Put Master back to its original location and leave it there.
There are no data integrity or performance advantages in moving master or modfel DBs. All you do...
September 26, 2011 at 5:17 am
My advice is take control of your career!
One tool that can help is a TechNet subscription from Microsoft. This allows you to use all the MS operating systems and...
September 12, 2011 at 4:30 am
What do you want to do when you get all this information?
It is very unusual to need to know the database size on a frequent basis. It...
September 12, 2011 at 3:06 am
Viewing 15 posts - 841 through 855 (of 2,496 total)