Viewing 15 posts - 676 through 690 (of 2,497 total)
You need to do some capacity planning.
The areas you need to work out are: a) CPU requirement, b) Memory requirements, c) IO Requirement d) Total disk space requirement.
To...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 18, 2013 at 5:15 am
If people on the Internet are not able to help within the timescale you want, then the best thing is to open a Support Case with Microsoft. SQL people...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 18, 2013 at 3:47 am
SQL Server 2012 will not install on Windows 2003 or below, which includes XP.
You will need Vista or above to use SQL 2012 command line utilities.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 11, 2013 at 9:28 am
All of the SQL Server instances must be on SQL 2012 SP1 for this to work. You cannot mix SQL Server versions. However, you should be able to...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 6, 2013 at 10:01 am
Many backup products allow you to backup to multiple files using multiple threads. The bacukp gets striped across all the files and you need them all available for a...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 6, 2013 at 3:11 am
I have seen similar situations, particulary on my sandbox clusters.
There are a few ways to safely shut down a cluster, and a few that can cause problems.
Safe methods:
a) Shut down...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 6, 2013 at 2:59 am
You cannot share volumes between different Windows clusters. Each Windows cluster needs its own set of shared volumes.
You can add new nodes to an existing Windows cluster. It...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 5, 2013 at 3:41 am
You cannot use local disks if they are going to be used as shared drives by the cluster. You must use disks that can be shared between all nodes...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 5, 2013 at 3:30 am
When you install SQL on the passive node you do not need to access the shared drives. If you are using a command-line install, you should use ACTION=ADDNODE to...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 5, 2013 at 3:26 am
It is pervasive. It is a key driver of business growth and innovation.
Without IT most businesses could not function. Banks are now software houses that also...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 5, 2013 at 3:13 am
You can set up replication so that insert and update are replicated but delete is ignored. Books Online has some advice on this and Google can find you more.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 4, 2013 at 8:14 am
The considerations for char and varchar on SQL Server and DB2 are much the same.
Many (over 10) years ago DB2 moved to having an inheriently variable length row,...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 4, 2013 at 8:06 am
Address clensing and deduplication is a complicated process, particularly if you want to achieve the standard required for discounts on postage.
If you want a result that looks cheap and nasty,...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 29, 2013 at 4:10 am
What you want to do sounds similar to what we have done.
We use P2P but send all our updates to a single node, which is identified using a DNS vanity...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 28, 2013 at 6:18 am
Have you considered AWS? We moved our server estate to AWS last year and have found many benefits compared to our previous co-lo hosting.
Apart from better performance and saving...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 28, 2013 at 2:51 am
Viewing 15 posts - 676 through 690 (of 2,497 total)