Viewing 15 posts - 1,621 through 1,635 (of 2,497 total)
One point from the OP...
SSAS is unable to use Windows PAE, so in 32-bit mode the maximum amount of memory available to SAS is 2GB, unless you have the /3GB...
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, 2008 at 7:39 am
If you move master and/or mssqlssytemersource from their default location, do not be surprised if the next service pack install fails and leaves your SQL instance unuseable. 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
August 5, 2008 at 8:29 am
My preference is to always use SQL native backup for master database. A restore of master is normally only done when things are broken, and at that stage I...
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 5, 2008 at 6:42 am
If your Prod environment is 64-bit, then your pre-production environment also needs to be 64-bit. Ideally everything from Dev onwards needs to be 64-bit - the last thing 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
July 21, 2008 at 2:34 am
I used to manage an application that needed its users to have db_ddladmin rights in tempdb.
I created a job that ran when Agent was started to create these rights. ...
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 18, 2008 at 8:17 am
If you want to set up a user in SQL Server 2005 or above so they can:
View all object definitions in all daabases (including SP source, etc)
View all data in...
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 18, 2008 at 8:05 am
Marios is right, I had forgotton this issue.
There is a documented process for moving master DB data and log files, and for moving the resource DB files. I had...
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 16, 2008 at 9:31 am
If you want to apply SP2 and a CU without rebooting, you must:
1) Stop all SQL Server services
2) Stop the .Net Optimization service (stop both the x86 and x64...
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 16, 2008 at 2:55 am
Bob,
Cool idea, but it would duplicate the systems our governments are already working on. If you have done or thought nothing wrong, what have you to fear 🙂
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 15, 2008 at 8:38 am
mofcomp is a system utility. It compiles the mof file that is in the location specified. One of the main uses of compiled mof files is to make...
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 15, 2008 at 2:50 am
Anyone who has used SQLServerFineBuild knows it aims to produce a best-practice install and configuration with a single click.
SQL Server 2008 brings many new features that would need to be...
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 15, 2008 at 2:43 am
sql.sanya,
What benefit is the server giving to your business? If it is helping the business earn money, then the business needs to pay money to keeps its assets working.
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
July 11, 2008 at 6:26 am
On 64-bit SQL Server you need to set a maximum memory limit. Otherwise SQL Server adds the page file size to the actual server memory and tries to use...
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 8, 2008 at 10:14 am
Even with a development server, I would test your planned configuration on a Crash & Burn server first.
Also, when you do make the move to SQL Server 2008,...
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 4, 2008 at 3:34 am
My advice is report this to Microsoft PSS, they may be able to help even though you aer on an old OS.
The most likely cause of the problem 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
July 4, 2008 at 3:31 am
Viewing 15 posts - 1,621 through 1,635 (of 2,497 total)