Viewing 15 posts - 391 through 405 (of 2,497 total)
You will also have to configure a port number for MSDTC via the ServerTcpPort registry key, as it does not have a default port. Google can find a 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
September 29, 2014 at 3:44 am
Don't forget that SQL Server imposes the limit that a given table can only have one clustered index, but this limitation does not exist in all DBMSs. So when...
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
September 8, 2014 at 7:55 am
Are you able to say more about what you wanted to do with MSDTC and AGs. Can you say what the exact problem was, and how you had configured...
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
September 8, 2014 at 5:09 am
As Lynn says, two adjacent quotes should do the trick.
Have you looked into Domain Managed Accounts. These cannot be used in all situations, but where they can be used...
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
August 22, 2014 at 6:19 am
If you really need to restart your SQL Server clustered instance, you need to use the cluster commands to put the SQL cluster group offline, then put it back online.
If...
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
August 19, 2014 at 3:55 am
Jeff is right about the capabilities of SQL Server, there are very few workloads that it can't handle.
If you are looking at building a new system for a new 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
August 19, 2014 at 2:27 am
Sorry for the tone of my previous response...
It can be hard to remove all traces of a SQL install, that is why I was suggesting a scratchpad machine if 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
August 19, 2014 at 2:19 am
If you are running on W2003 you may well be running on old hardware. Look on this upgrade as an opportunity to get the latest hardware - it will...
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
August 18, 2014 at 6:54 am
If you want to treat your windows instance as a scratchpad, installing and uninstalling software multiple times, then do not be surprised if you get unexpected side effects.
If you want...
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
August 18, 2014 at 6:47 am
If you feel you need the level of performance that such a configuration can give you, you need to look at DB2.
DB2 has had a shared disk architecture for mainframe...
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
August 18, 2014 at 6:29 am
Build yourself a virtual test cluster and test this yourself easily
This advice is good. You can learn a lot from books and forums, but these will not let 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
August 6, 2014 at 7:38 am
Things to add to Perry's list...
You no longer need to specify the ADMINPASSWORD parameter. This is because each node is processed independently.
MSDTC no longer needs to be clustered 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
August 6, 2014 at 7:30 am
As well as SPADE, you might want to look at FineBuild, also on Codeplex.
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
July 30, 2014 at 2:54 am
This is something we have looked at a few times since we moved to AWS EC2 in 2012. So far we have not seen a way to make 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
July 28, 2014 at 4:28 am
How are you tuning your BPE and server Max Memory? A BPE can turn poor performance to acceptable if you are starved of memory, but it is not 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
July 28, 2014 at 4:04 am
Viewing 15 posts - 391 through 405 (of 2,497 total)