Viewing 15 posts - 1,771 through 1,785 (of 2,497 total)
I notice you are doing replication. Are you using CLR proceduers within your replication process. There is a known bug in using CLR within replication on 64-bit boxes...
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, 2008 at 3:42 am
The SQL Agent service account only needs local admin rights if you want it to automatically restart SQL Server or SQL Agent if they fail.
Getting services to restart automatically on...
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 12, 2008 at 3:31 am
The answer is NO. I think it will never happen while MS also sells Windows.
My 2 cents on some of the reasons...
1) SQL Server is closely tied into 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
February 12, 2008 at 3:13 am
You will need to import the documents to a column in a SQL Server table before SQL Server can create a full text index on them.
Alternatively you can use 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
February 12, 2008 at 3:05 am
There is no desperate need to reinitialise tempdb.
Unless your applications do non-standard things that leave objects permanently in tempdb, the space will get re-used automatically. If your...
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 12, 2008 at 2:55 am
You may find http://www.codeplex.com/SQLServerFineBuild useful. I published this to help provide a 1-click install and configuration of SQL Server 2005. It includes a section on upgrading from SQL...
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 12, 2008 at 2:50 am
Having rights to access the SQL binaries makes no difference to you being able to start/stop the SQL services. You need the following rights on the SQL Services, which...
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 12, 2008 at 2:47 am
I always install SQL Server 2005 by copying the install media to a disk on the server, so the install runs locally.
You may find http://www.codeplex.com/SQLServerFineBuild helpful. I published this...
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, 2008 at 2:58 am
If you are looking at MSDN, also take a look at TechNet. A TechNet Direct subscription is cheaper than MSDN, and give you access to all the MS server...
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, 2008 at 2:56 am
You might find http://www.codeplex.com/SQLServerFineBuild helpful. I published FineBuild to help provide a 1-click install and configuration of SQL Server 2005. It has a section in the Reference manual...
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, 2008 at 2:51 am
I hope you are running in 64-bit mode. 4GB is not a lot of memory, and adding more could do a lot for your performance.
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 8, 2008 at 2:49 am
Most people who have been through the migration process recommend you do not do an in-place upgrade. It is far safer to uninstall SQL Server 2000 and do 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 8, 2008 at 2:47 am
Windows Task Manager shows true results on a 64-bit server. If you want more details than Task Manager gives, download Process Monitor from MS (it is a former Sysinternals...
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 8, 2008 at 2:39 am
Take a look at http://www.codeplex.com/SQLServerFineBuild. The main purpose of my publishing FineBuild is to help give a 1-click install and configuration of SQL Server 2005.
However, it also contains 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 8, 2008 at 2:29 am
The routine sets Page Verify to CHECKSUM for SQL Server 2005. This is a more thorough method of detecting possible corruption than the Torn Page detection.
The options for Torn...
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 8, 2008 at 2:19 am
Viewing 15 posts - 1,771 through 1,785 (of 2,497 total)