Viewing 15 posts - 1,666 through 1,680 (of 2,497 total)
The OP asked why we can only have one clustered index per table.
A lot of people responded why this is the case for SQL Server. I posted about DB2...
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 17, 2008 at 3:56 am
The approach to clustering is different between SQL Server and DB2.
As most SQL people know, SQL Server will always physically insert a new row in the correct place in 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 16, 2008 at 3:37 am
The description I gave about MDC was very simplified. If you want more details then you have to search the DB2 documentation.
Believe me, MDC does what it says on...
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 15, 2008 at 9:21 am
I really don't see any way to have multiple clustered indices without storing multiple copies of the data, as it's not clustered unless it's physically stored in that order.
In DB2,...
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 15, 2008 at 7:44 am
You get this message when the database files are closed.
Having AUTOCLOSE on is the commonest way that database files get closed, but there are others...
ALTER DATABASE xxx SET OFFLINE
ALTER...
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 15, 2008 at 5:59 am
The OP said there was plenty of memory on the box.
Remember that with 32-bit SQL Server, the ONLY thing that can use memory above the 4GB line is...
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 15, 2008 at 5:49 am
A clustered index physically stores the data in the sequence given in the index definition. The way this is implemented in SQL Server means you can only have 1...
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 15, 2008 at 5:39 am
They exist, but you do not have to adjust them. Changes to these are only needed if you have specific requirements that could be met by using affinity masks.
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 14, 2008 at 8:22 am
There are a few threads on this forum that have focussed on the differences between 32-bit and 64-bit SQL Server 2005. Most people would not hit any issues, but...
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 14, 2008 at 3:40 am
If the only thing running on your box is the OS and SQL server, than setting max memory to 62 GB might just work, sometimes.
If you run anything else (anti-virus,...
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 14, 2008 at 2:36 am
I would say that 2 hours to uninstall and reinstall SQL 2005 is good! I find that the uninstall can easily take 40 minutes, and the install along 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
April 11, 2008 at 3:19 am
If you aer re-installing to the same folders, there is no need to delete them between the uninstall and the new install.
You should not restore any other system databases apart...
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 11, 2008 at 3:01 am
Windows want to use more memory than it has available.
As Chirag says, check what is happening in SQL Server. SQL should adjust its memory use to avoid excessive paging,...
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 11, 2008 at 2:56 am
In 32-bit mode, SQL Server 2005 SE can use AWE along with Windows /PAE switch to use memory above the 4 GB line.
Only the buffer cache can use memory above...
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 11, 2008 at 2:41 am
SqlServerFineBuild is free, but you can make a contribution (it goes direct to charity) if you wish.
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 9, 2008 at 9:58 am
Viewing 15 posts - 1,666 through 1,680 (of 2,497 total)