Viewing 15 posts - 1,471 through 1,485 (of 2,497 total)
If you have a document showing what options were used in the original install, or scripts that did the install, that is the best choice.
If you have to start from...
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 20, 2009 at 8:41 am
You need to talk to SAP. They will have LOTS of experience on how big the database should be with your workload, and how to tune it. SAP...
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, 2009 at 3:31 am
If you want to move tempdb while SQL is running, you can use ALTER DATABASE to add new files to tempdb. You can then use SHRINKFILE with EMPTYFILE 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, 2009 at 3:22 am
You cannot have a dedicated buffer pool for tempdb. All databases share the same buffer pool.
In a large system there would be performance benefits to be gained 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
February 18, 2009 at 3:18 am
PS If it works on one node of the cluster and not on the other, this is telling you there are differences in permissions between the two 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 18, 2009 at 3:10 am
Try some testing where the proxy account is not a local admin and where it is a local admin.
If it fails when the proxy is not a local admin 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
February 18, 2009 at 3:09 am
It is important to set the maximum memory limit for 64-bit SQL Server. The memory reported as available to SQL Server includes the page file size, so 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
February 17, 2009 at 4:08 am
it was fine until a manger told System engineering to stop it
I think you need to discuss this with your manager. If anyone who thinks they have some authority...
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 17, 2009 at 4:02 am
I think you have a couple of options...
1) Try the latest CU update for SP4. See http://support.microsoft.com/kb/894905/ for details. The problem you have may be fixed 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
February 17, 2009 at 3:54 am
Does the log file for the hotfix install give any clues? Assuming the hotfix is a .msi you can add a parameter /LOG "C:\hotfixlog.txt" If you have 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 16, 2009 at 6:13 am
On SQL 2000 the space used figures are not maintained very well. You should plan to do a DBCC UpdateUsage maybe once per week to re-sync the figures.
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 16, 2009 at 6:06 am
If the accounting software created the backup, it probably has a tool to restore its backup. If so, you will need to use that tool to do the restore.
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 13, 2009 at 2:50 am
1) Who writes these scripts? Getting these right is a skill worth exploiting.
2) Have you seen how complex SQL Server 2008 is? It is like really complex! :)...
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 13, 2009 at 2:47 am
If a job that is cancelled after running a long time has been doing SQL insert/update/delete logic all that time, it will probably take longer to roll back than 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 13, 2009 at 2:43 am
It is very likely your 32-bit SQL Server 2000 instance is running on a 32-bit edition of Windows. All 64-bit editions of SQL Server will only run on 64-bit...
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 13, 2009 at 2:40 am
Viewing 15 posts - 1,471 through 1,485 (of 2,497 total)