Forum Replies Created

Viewing 15 posts - 961 through 975 (of 2,497 total)

  • RE: SQL 2008 R2 Installation account question

    Do you have a BUILTIN/ADMINISTRATORS login? If so, then you are able to login using the local admin group.

    You can safely remove the BUILTIN/ADMINISTRATORS login provided that you are...

    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

  • RE: Disabling the Named Pipe Protocol in SQL Server

    We successfully use Full-Text under SQL Server 2005 and SQL Server 2008 R2 with Named Pipes disabled

    Interesting. Maybe the Microsoft documentation is wrong. See http://msdn.microsoft.com/en-us/library/ms345189.aspx for 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

  • RE: Disabling the Named Pipe Protocol in SQL Server

    If you want to use Full Text indexing then you will need Named Pipes.

    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

  • RE: Need to zip and move C2 level audit files

    Why are you looking at C2 auditing? This is an obsolete standard that does not match current compliance requirements. IMHO you should be looking at Common Criteria, which...

    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

  • RE: SQL Server 2008 Installation

    I am glad this worked for Andrew, but I would be cautious about doing this work on a Production box.

    Doing repeated install /uninstall / install processes can leave your system...

    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

  • RE: Best DBMS for business

    Excel is not a DBMS

    There are 34.6 million hits on Google for the term "excel database". Excel may not have had DBMS capabilities as its primary design goal,...

    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

  • RE: Huge size of unused space problem

    The space used figures reported by SQL Server can become inaccurate over time. Many people are not concerned by how accurate they are. If you want these values...

    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

  • RE: Best DBMS for business

    The world's most popular database by a long long way and well known as easy to use by end users is Excel.

    The world's most troublesome database system for people dealing...

    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

  • RE: SQL Server 2008 upgradation failed

    Why are you installing SQL 2005 before you install SQL 2008? Are you trying to simulate an upgrade you are planning for a live server?

    It is far safer...

    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

  • RE: Restore System DBs to Another SQL Instance

    If you are upgrading from SQL 2005 to SQL 2008 then don't even thing of restoring MSDB as a way to get your data into SQL 2008, unless 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

  • RE: Uninstalling SQL Server 2005, having no impact on SQL Server 2008

    In theory you should be OK. In practice you will have to try it and see if anything breaks.

    My view is that it is a lower risk to leave...

    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

  • RE: update hotfix 3024 for SQL Server Database Services 2005?

    Could this be related to Windows KB 937444? This fix is required for Filestream to work with a SQL 2008 cluster on W2003, but may have other benefits to...

    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

  • RE: What Brand of Desktop is best these days?

    If you have Hyper-V, then you cannot access USB devices via Virtual Machine Connection. However, if you connect to your guest via Remote Desktop then USB devices are accessible.

    This...

    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

  • RE: What Brand of Desktop is best these days?

    It was good running 64-bit Vista on a 12GB machine. It ran about as fast as 32-bit XP on a 2GB box... Iv'e now moved everything except 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

  • RE: What Brand of Desktop is best these days?

    The desktop I had built 3 years ago is still fast for today, and should be good for another 3 years. It cost me GBP 1500 initially, with another...

    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

Viewing 15 posts - 961 through 975 (of 2,497 total)