Viewing 15 posts - 1,111 through 1,125 (of 2,497 total)
SQL Server picks up the path for the master data and log files from startup parameters.
As far as I know, it will always ignore the paths stored for...
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
December 23, 2009 at 4:04 am
We have active instances on each node of a two-node cluster, but for us they are both EE. One node has our main publisher DBs and the other node...
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
December 23, 2009 at 3:55 am
The cluster index will help you manage free space far batter than you can at present, and having a CI may also improve your performance.
There is no way an outsider...
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
December 18, 2009 at 8:52 am
There are a few SQL experts and some PSS engineers who suggest setting the pagefile to zero on a 64-bit box that has memory in double-digit GBs. The rationale...
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
December 18, 2009 at 5:54 am
Even if you uninstall CU6, you may not get rid of all traces of it. Many CUs update the system tables, and I doubt the uninstall will always 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
December 18, 2009 at 3:31 am
Not all database systems support the concept of a cluster index. Therefore if you have a 3-party app that was written to work on a number of database systems,...
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
December 18, 2009 at 3:20 am
In 64-bit Windows, SQL Server thinks the total amount of memory available is the total of the physical memory plus the size of the page file. Therefore if 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
December 18, 2009 at 3:05 am
There are many cheap NAS boxes available, but all that I have seen appear as a network drive to Windows. This means they are no use for testing clustering.
One...
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
December 16, 2009 at 9:33 am
Let's assume this becomes the standard way of living in 'developed' countries.
There is no way your life log could not be hacked, either by government or by criminals....
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
December 14, 2009 at 5:43 am
GilaMonster (11/25/2009)
roelofsleroux (11/25/2009)
Gila you sound like Doomsday Prophet. This is South Africa.Jy ook? So baie mense van Suid-Afrika op hierdie forums.
Hahahahaha I was laughing waiting to see Gail's reply!
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
November 26, 2009 at 3:15 am
You can get SQL Agent on SQL 2008 Express Edition to start. You need to set up account rights and enable the agent XPs.
But as soon as 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
November 26, 2009 at 3:04 am
We have had a number of questions which included a deliberate spelling error that had an answer xxx is wrong because it does not exist. As far as 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
November 26, 2009 at 3:01 am
Did you check the memory use when you are running backups and other batch processes? You need to set your max memory use to take these into account.
If 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
November 25, 2009 at 9:32 am
One of the fundamental design criteria behind the ODBC standard is the ability to run ad-hoc queries. In order to do this, the ODBC driver needs to access certain...
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
November 25, 2009 at 4:47 am
I have experienced similar problems when memory has been under perssure.
The OP said they have a 16GB box with 13GB allocated to SQL Server. This may be OK 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
November 25, 2009 at 4:30 am
Viewing 15 posts - 1,111 through 1,125 (of 2,497 total)