Viewing 15 posts - 2,401 through 2,415 (of 2,497 total)
Our standard is to use NT authentication everywhere we can. This is mainly because NT auth gives improved security over SQL auth.
All but 1 of our production instances 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
September 10, 2004 at 2:48 am
If you did not have a logging mechanism, you would not have a rollback mechanism.
If your logging mechanism was limited to the memory on your box, you would be limited...
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 10, 2004 at 2:23 am
You may need to think more about the impact of shrinking log files that will grow again over the next few days.
Any shrink operation will release disk space to 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
September 8, 2004 at 3:37 am
How is this any different to using SQL Server authentication?
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 6, 2004 at 3:11 am
The only reliable way to retrieve a random sample of records wit SQL Server is to use the Newid() function. Do a search of this forum's archives for 'random' 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
September 2, 2004 at 7:39 am
There is no way to ensure you have a relationally intact set of data by taking a backup. This is because applications can continue to update the databases while 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
September 2, 2004 at 6:03 am
SQL Mail is not the most bug-free product that Microsoft have produced. Even though it can work for weeks without trouble, it is not unusual for mail to stop working...
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 2, 2004 at 5:45 am
If you can get a RAM disk set up, you could put the log file on there. If you do this, you may need to reduce the checkpoint interval so...
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 25, 2004 at 2:58 am
The Windows Event Log could give you more details of why SQL will not start.
If this does not help, add a startup parameter of -T3608 and try again. (Search...
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 24, 2004 at 3:44 am
There are actually 2 reasons why Full recovery mode may be necessary.
1) To allow point in time recovery using transaction log backups.
2) Provide a full audit trail of all changes...
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 12, 2004 at 3:02 am
If sa24's idea does not work, copy and paste the code in sp_changedbowner into your own user sp. Then locate the test for system databases and remove it. Your amended...
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 11, 2004 at 10:14 am
This is by design. Microsoft, in their infinite wisdom, added some code to the Agent startup process to set MSDB to simple recovery mode. If you set up the right...
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 11, 2004 at 10:05 am
According to the Microsoft documantation, the /PAE switch is not needed in W2003 - it is effectively enabled as a default.
This means all you need to do is enable AWE...
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, 2004 at 9:24 am
Use DB2 or other DBMS (Yukon) that supports TIME as a datatype.
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, 2004 at 9:21 am
You should be able to get SQL started.
However, I would start to build this environment incrementally. Start with a unclustered server at your primary and secondary, and debug 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
August 6, 2004 at 9:17 am
Viewing 15 posts - 2,401 through 2,415 (of 2,497 total)