Viewing 15 posts - 1,246 through 1,260 (of 2,497 total)
Windows 32 bit can directly address 4GB RAM.
First, lets look at the situation ignoring Windows /PAE switch and SQL AWE memory...
Everything that uses memory must fit into 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
July 20, 2009 at 2:57 am
Is 'Show Advanced/All Properties' checked? You do not see the option you need unless advanced properties aer shown.
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 17, 2009 at 8:19 am
Sorry, I am out of ideas.
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 17, 2009 at 8:17 am
Registry access is often the problem, but ther can be other blocks to getting this working...
It is worth trying to control the services using a different tool as part of...
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 17, 2009 at 6:25 am
The default security model in Analysis Services is that the local Administrators group has ServerAdmin access and nobody else has.
A system administrator can grant ServerAdmin access to the DBA group,...
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 17, 2009 at 5:37 am
You need remote access to the target machine registry. Some sites lock this down, so you may need to talk to your Windows people to see what has been...
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 17, 2009 at 5:31 am
Lots of good advice in this thread!
Another way that anything relying on a MAC address can produce duplicate results is that you are relying on all MAC addresses being globally...
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, 2009 at 5:24 am
You will need to take disk images of all drives that contain program files that will be involved in the upgrade.
Some of the problems you encounter may leave you with...
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, 2009 at 5:09 am
I have some involvement in redundancy councelling, and would add some other points...
Do not be surprised if you feel low or depressed. Most people find the disruption to their...
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, 2009 at 5:02 am
There is a choice:
1) You can be lazy and put the SQL service account in the local Administrators group. In this situation you give SQL Server more rights than...
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, 2009 at 5:44 am
I agree with Rudy.
If you want to look at building your own conversion routine then look for 'Packed Decimal' or 'comp-3' in Google.
It will be quicker and easier...
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 13, 2009 at 10:00 am
On a 32-bit server the Perfmon TargetServerMemory results and Task Manager will never report more than 4GB memory in use.
In order to see if you are using more than 4GB...
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 10, 2009 at 6:01 am
Duplicate post...
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, 2009 at 3:53 am
In order to set up a custom role in msdb that inherits the capabilities of SQLAgentOperatorRole (or any other role) you need to do the following...
1) Create your role
2) Add...
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, 2009 at 3:53 am
In SQL Server 2005 and above, all tables have the capability of supporting multiple partitions. By default all data is kept in a single partition.
If you want 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, 2009 at 5:41 am
Viewing 15 posts - 1,246 through 1,260 (of 2,497 total)