Viewing 15 posts - 1,036 through 1,050 (of 2,497 total)
You need to start with what the business expects. This may be different for different databases. Different expectations will drive different solutions.
Take a look at the questions given...
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
April 19, 2010 at 3:03 am
It may be worth running OCSETUP("NetFx3") and rebooting, then retrying your SQL install.
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
April 12, 2010 at 9:41 am
It should be set to 1.5 times your RAM amount. This was best practice in '95 and still is today. Better yet set it to system managed and forget about...
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
April 12, 2010 at 4:35 am
Are you installing on W2008 or W2008 R2? If you are using W2008 R2 then you need to build a slipstreamed media set that includes SQL Server 2008 SP1....
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
April 12, 2010 at 2:53 am
What a recipe for disaster that seems, though... a system db you cannot alter the location of?!
Remember that the key thing with the resource database is that it is 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
April 12, 2010 at 2:42 am
I agree with George that trying to move SQL to another server with a different drive layout is a risky thing to do. If you want to do 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
April 7, 2010 at 3:10 am
My employer moved to Agile development about 15 months ago. One of the real benefits we see is the greater involvement and communication between 'the business' and 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
April 6, 2010 at 4:59 am
Another approach is to create a lookup containing both values and labels.
The label you show in the report drop-down can be formatted with leading spaces or whatever 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
March 31, 2010 at 3:15 am
ORM tools are here to stay, at least for a few years until the next big thing. So is Cloud. Both concepts spin the line that specialist skills...
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
March 31, 2010 at 3:04 am
can non sysadmins own jobs, and leave the job step's Run As blank
I am sure I have set this up in the past, but I do not have a suitable...
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
March 31, 2010 at 2:34 am
I think Moki has covered most angles, but a couple of things need more clarification.
If the job owner has sysadmin authority, the job always runs under the SQL Agent security...
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
March 30, 2010 at 3:05 am
Paging is done by Windows. SQL Server cannot tell Windows to page or to not page any of the SQL Server memory. The 'lock pages in memory' 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
March 23, 2010 at 4:57 am
Shrinking a database will have no impact on the log space used when you rebuild an index. If you are rebuilding a large index you will use a lot...
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
March 23, 2010 at 4:41 am
Many security practitioners are close to paranoid about product administrators doing their work without needing Windows superuser or product superuser rights. IMHO the documentation from Microsoft needed to achieve...
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
March 22, 2010 at 5:32 am
Try looking in the SQL Error Log for the startup messages. This could give you the information you need.
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
March 22, 2010 at 5:03 am
Viewing 15 posts - 1,036 through 1,050 (of 2,497 total)