Viewing 15 posts - 1,456 through 1,470 (of 2,497 total)
Retro-fitting insulation is an established practice in some parts of the world.
In Switzerland, the government periodically raises the insulation requirements for offices and apartmement blocks. Compliance with the new...
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 26, 2009 at 4:29 am
One potential issue with DNS aliases is getting them changed. At my old place we had servers in GB and US (with no clustering), and wanted the applications 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 25, 2009 at 5:34 am
In your situation you will not get any extra benefits from applying Lock pages in memory.
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 25, 2009 at 5:20 am
The counters show that you are successfully using AWE. What problem do you think you have?
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 24, 2009 at 8:19 am
Each lock uses exactly the same amount of memory. I think Books Online has the details of how big this is.
If you have 20 rows in a table locked,...
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 24, 2009 at 5:56 am
Steve is right. The sa account can have any password without impaqcting on how SQL Server operates.
Anyone who has sysadmin authority can change the password of 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 24, 2009 at 5:48 am
If you Google Surrogate Key you will find lots of opinions, often in opposition to other opinions and sometimes (excessively) strongly held. The main viewpoints are 'Never', 'It depends',...
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 24, 2009 at 5:44 am
The suggestion about using your firewall or network switch configuration is the best way to achieve this.
One way to think of the TCP address and port numbers is to think...
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 24, 2009 at 5:32 am
Persnally, I think having a level of indirection between your applications and the hardware is a good thing. All SQL Server machines should be given a DNS alias, 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 24, 2009 at 5:19 am
If you download SQL Server FineBuild from Codeplex, you will find the spSetDBMaintenance stored procedure creates database backup jobs for all databases that do not already have a backup.
The jobs...
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 24, 2009 at 5:12 am
PAE is automatically enabled only if the server is
using hot-add memory devices
This does not prevent you from adding /PAE to BOOT.ini even if you have hot-swap memory. 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
February 24, 2009 at 5:07 am
Google tells me that it is free with Sysinternals tools.
It runs a NTFS defrag on named files only.
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 23, 2009 at 6:58 am
What TCP port have you specified for these instances. If you are trying to use the same port for both instances, you can conect only to the first instance...
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 23, 2009 at 2:55 am
Lots of good advice has already been given, but here is my bit...
Try Google to find if there is a SQL Server user group near you. They often have sessions...
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 9:00 am
Are you trying to copy DTS packages or copy data?
If you are copying DTS packages, IMHO the best option is to export and import using DTSBACKUP2000. This will keep...
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:46 am
Viewing 15 posts - 1,456 through 1,470 (of 2,497 total)