Viewing 15 posts - 451 through 465 (of 2,497 total)
If you are using Standard Edition there is not much to tempt you.
The Buffer Pool Extension feature will help performance if you have SSD storage and are memory-constrained,...
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
May 12, 2014 at 9:57 am
My main objective would be to reduce risk, so I would aim to build a new cluster. You are using SQL2012 so you can use an AG 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
May 12, 2014 at 3:42 am
I will try to test this but have very limited time over the next 2 weeks.
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
May 7, 2014 at 3:49 am
We went live with SQL2014 CTP2 for our BI servers. For the stuff that existed in SQL2008R2 we have not noticed any problems. We are deferring the use...
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
May 7, 2014 at 3:32 am
I have had situations in the past where SQL Serve reported a network problem but the Network people said nothing had gone wrong.
Eventually we wrote a simple script that did...
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
May 6, 2014 at 5:01 am
There is very little difference in the footprint of Express and Developer editions, provided that you install the same set of components.
The main advantages of installing Developer Edition are:
a) You...
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
April 29, 2014 at 2:48 am
If you copy the folders without also explicitly copying the permissions, then the problems you had would be expected. The SQL Server install sets a lot of folder permissions...
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
April 29, 2014 at 2:38 am
I have not seen this specific problem, but I have seen other situations where a SQL Service does not start within the timeout limit after applying a patch.
This can be...
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
April 29, 2014 at 2:28 am
If you want to do this just using the command line, see http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20SQL%20Books%20Online%20Update#BOL Update for SQL 2012
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
April 28, 2014 at 3:56 am
I always put a space before each / character, to allow the preceding parameter to be correctly terminated. OK so I've never tried not putting a space, but all...
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
April 22, 2014 at 2:35 am
Personally I would never uninstall SQL Server on what is destined to be a Production machine. Outside of Production I still prefer to not uninstall SQL Server.
It is not...
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
April 11, 2014 at 9:10 am
Buffer Pool Extension is a really useful feature of SQL2014 that can reduce most IO latency, but it does have a few foibles.
Implementing it is easy but you need 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
April 11, 2014 at 3:18 am
SQL Server in a Workgroup has some advantages if it is used in an automatic scale-out scenario, such as in a cloud environment.
Connecting a Windows box to a Domain takes...
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
April 11, 2014 at 2:55 am
The moral is that you need to work this out with your license reseller. Be up-front about what you plan to do, and get their agreement. If 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
April 9, 2014 at 9:08 am
Our discussions with Microsoft and its license resellers have shown that the following is accepted:
If you set processor affinity to match the number of cores you have licensed, then you...
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
April 9, 2014 at 8:57 am
Viewing 15 posts - 451 through 465 (of 2,497 total)