Viewing 6 posts - 2,491 through 2,497 (of 2,497 total)
You should treat MSDE the same as SQL Server as far as fix levels, security setup, etc is concerned. There are many hacks out there that allow you 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
August 4, 2003 at 3:55 am
The following link may be interesting: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328551
It looks like you can get some blocking within TempDB if TempDB has a lot of pressure from heavy workfile and/or temporary table create...
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 22, 2003 at 3:25 am
Quote: "The maximum (theoretical) size of a database is 1,048,516 TB, and not a single terrabyte as earlier suggested."
Don't forget you can have up to 32768 databases per 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
July 9, 2003 at 4:11 am
We run with SQL Logging all logons, and NT auditing set on for most things. There have been a few situations where people have claimed the DBAs 'must 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
July 3, 2003 at 6:36 am
I just leave MSDB in simple mode, but do a full backup of MSDB shortly after my other backups are finished.
I do transaction log backups of the 'real'...
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 26, 2002 at 8:15 am
A few things to remember...
a) Space may be needed to process the transaction log, as well as database.
SQL Server will always scan the transaction log and to back...
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
May 27, 2002 at 5:30 am
Viewing 6 posts - 2,491 through 2,497 (of 2,497 total)