Viewing 15 posts - 526 through 540 (of 2,497 total)
All I can say is on a busy server any SQL install, but especially a cluster install, can take a long time.
The SQL cluster install process does a lot of...
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 3, 2014 at 3:01 am
The SQL Server install will always add about 3.5GB of files to the system drive. Most of these go into the GAC, which can only exist on the system...
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
December 30, 2013 at 7:17 am
End users will continue to do whatever they’d already decided before they saw the numbers.
Undoubtedly the most accurate prediction of the lot!
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
December 30, 2013 at 4:39 am
The main thing that slows down index-related performance is fragmentation. You should do some research around this issue to understand more about fragmentation and what an index rebuild does.
The...
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
December 30, 2013 at 4:23 am
The main benefit of doing an unattended installation is you can guarantee repeatability.
It is too easy with a manual install to forget to select a given option or...
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
December 30, 2013 at 4:06 am
There are a few tools that can help with unattended installs.
You have the basic config file edit that comes with SQL Server, and you can wrap this up in 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
December 30, 2013 at 3:56 am
If you are setting up a lot of SQL Express instances it may be worth looking at SQL FineBuild.
The latest 3.2.0 release detects if Express Edition is being installed and...
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
December 18, 2013 at 5:10 am
My preferred approach is to install SQL Server on each node separately.
It is possible to run the SQL install and get it to install the database engine and...
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
December 18, 2013 at 5:02 am
By default the Domain Admins group is part of the local Administrators group. This is the normal security model and you should not change this unless you have an...
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
December 16, 2013 at 5:29 am
In your position I would also not want to re-install SQL Server.
I would want to reformat the system drive and re-install Windows.
Removing and re-installing .Net is a bit like doing...
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
December 16, 2013 at 4:31 am
If you start talking about SQL Server Service Packs, Cumulative Updates and Hotfixes, then you need authorities in both Windows and SQL Server. This also applies to Security Updates...
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
December 16, 2013 at 4:25 am
Your organisation should have a Group Policy Object (GPO) in place to force correct clock synchronisation and frequency of synchronisation. This is something you can raise with your Windows...
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
December 16, 2013 at 4:18 am
The most obvious cause is that both instances are sharing a resource that should not be shared. The advice about using File Monitor and Process Monitor to help detect...
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
December 16, 2013 at 4:06 am
Elliott has a good point. Regardless of the 'expiry date' on your current license, it is always worth putting some pressure on Microsoft, via your license reseller, to get...
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
December 9, 2013 at 9:12 am
This might depend on the legal jurisdiction that currently applies in the country where the licences were purchased.
Within the EU, my understanding is that if you have purchased a perpetual...
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
December 9, 2013 at 7:09 am
Viewing 15 posts - 526 through 540 (of 2,497 total)