Forum Replies Created

Viewing 15 posts - 691 through 705 (of 2,497 total)

  • RE: Local System Account=fast, domain acct=slow

    Using a domain account that is in the local Administrators group in Windows 2008 or above DOES NOT mean you get the same privilege set that you get when running...

    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: New more powerful servers are slower than old ones?

    What workload are you trying to work out a performance profile for?

    If it is only going to be a SELECT from a 9MB table then you are most...

    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: Upgrading to 2012?

    Our SQL 2012 upgrade was done as part of a migration to AWS. This had much the same experience as moving to a new conventional data centre, except that...

    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: Issue installing SQL Server 2005

    It can often be a problem to test out a version of SQL Server, unless you can easily get access to the operating systems you need.

    I subscribe to TechNet, 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: Database Diagrams tool in SQLSERVER

    Be aware that the SQL Server database diagram is a live representation of the database. If you drop a table from the diagram it is dropped from the database,...

    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: Upgrading to 2012?

    We upgraded the SQL instances that serve our web applications to SQL 2012 last year, as part of our migration to AWS.

    Over the years we had upgraded from 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

  • RE: Issue installing SQL Server 2005

    There is not enough detail in what you have provided to give a definite answer...

    However, when you installed IIS, did you also install IIS6 compatibility, which is required by 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

  • RE: SQL Server on a virtual server

    If you want to see how a site delivering over 2 million page hits per day running on Amazon Web Services (AWS) performs, then look at http://www.totaljobs.com

    We completed our migration...

    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: How to notify through DB MAIL when sql server agent stopped automatically?

    The Windows Service Control manager can detect when a service stops unexpectedly. You can use this to automatically restart your service or automatically run a command.

    If you want 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: Password Insecurities

    When you have one or two passwords you can remember them. I have probably over 200 passwords so I write them down.

    I actually keep then in an encrypted container,...

    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: The Small Print

    don’t forget to read the small print

    And don't forget to negotiate!

    The larger your commitment to a given vendor, the greater is your capability to negotiate away from vendor standard T&Cs....

    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: Alternative to views

    Why do you not want to use a view?

    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: Cognos impromptu

    If your site already has in-depth skills using Impromptu, then keep on using it. The install costs of Imprompu will be dwarfed by the costs of migrating to 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

  • RE: Its possible convert SSRS report developed from VS2008 to VS2005

    I think Report Services Scripter will do what you need. See[urlhttp://www.sqldbatips.com/showarticle.asp?ID=62[/url]

    If there are any items in your report that do not have an equivalent in the older version 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

  • RE: IIS need for to Run SSRS Reports

    When you deploy your report, don't forget you must set up its security so that end-users can run 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

Viewing 15 posts - 691 through 705 (of 2,497 total)