Viewing 15 posts - 2,131 through 2,145 (of 2,497 total)
Microsoft have done what most vendors do. They have divided the feature set of their product into different editions, and charge more for the most comprehensive edition. If you want...
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 12, 2007 at 4:54 am
SQL 2005 Reporting Services is included in the normal SQL 2005 install media.
When you do the SQL 2005 install, what do you see on the displays showing the System Configuration...
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 12, 2007 at 4:47 am
SQL 2005 creates a number of local groups during the install process. BOL has the full details of this. They hold the service accounts used to run the various SQL...
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 9, 2007 at 5:56 am
There are normally no issues in SQL Server in using views, or in using a hierarchy of views. SQL Server will merge the syntax of your ultimate SQL query 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
March 9, 2007 at 5:49 am
I think the Upgrade Advisor uses the features in the RTM version of SQL 2005 as a target. It will not tell you about restrictions added in fixes since RTM. ...
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 9, 2007 at 5:41 am
You can create a database on Dev or EE edition and set up partitioning. Take a backup of the database and restore it to Standard Edition, and it should work OK. ...
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 9, 2007 at 5:35 am
I have run the normal Windows defrag tool on our non-production servers while SQL is running. The disks defrag OK, and SQL is not harmed - this is the result...
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 9, 2007 at 5:24 am
The path you specify during the install is a high-level path. SQL will add additional folders to this path as it sees fit to hold the various SQL components.
SQL2000 likes...
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 9, 2007 at 5:11 am
There are many things that can be done, but you need to start from the DW requirements documentation and potential SLAs. This should tell you more about how much data...
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 6, 2007 at 3:07 am
Chris,
I think you are wrong about AWE and PAE. PAE applies only to Windows, and enables the adressing extentions to allow Windows to access memory over the 4GB line. AWE only applies...
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 2, 2007 at 3:37 am
I have not tried this on Vista, but a common performance issue is certificate checking. By default, managed code that has a certificate will cause the OS to check those...
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 1, 2007 at 3:53 am
This works for us. The process starts with building a virtual domain and installing SQL on virtual servers. If you already have a Windows cluster, start at...
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 1, 2007 at 3:38 am
Steve,
Good editorial!
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
February 27, 2007 at 2:40 am
Try a Google search. I think this is a known bug. The permissions are set but the dialogue does not show them. You can maintain the permissions using GRANT, DROP,...
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
February 23, 2007 at 8:34 am
Tom's note reminded me... The apply of HF 2187 to the active node will only update cluster-aware components on the other node(s).
At the very least, Management Studio will not 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
February 22, 2007 at 9:14 am
Viewing 15 posts - 2,131 through 2,145 (of 2,497 total)