Forum Replies Created

Viewing 15 posts - 781 through 795 (of 2,497 total)

  • RE: Sizing the Data File SQL 2008R2

    Ultimately you can pick whatever time horizon you want. However, there are factors you should include when picking your time scale...

    1) What is the realistic time between raising 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

  • RE: Transaction log backup, tempdb negative space?

    Jamie, have you done any research to find out what might be going on? If so, what are your results so far?

    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: software assurance for SQL servers

    If you are using Software Assurance, then from the date of your next SA review after SQL 2012 is released I am told your SQL Server licences will be moved...

    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: Sizing the Data File SQL 2008R2

    The reason the two backups were different sizes is almost certainly due to the additional space map pages that get inserted into SQL Server as files grow.

    A single space map...

    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: NT SERVICE\SQLSERVERAGENT

    The NT SERVICE\SQLSERVERAGENT and NT SERVICE\MSSQLSERVER entries are what are known as Service SIDs. Google can tell you more about what these are.

    To me, it looks like your 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: Manually scripting database backups (FULL recovery)

    I suggest you look at Ola Hallengren's databae maintenance solution. http://ola.hallengren.com/ It has won a number of awards, and is likely to be a lot more reliable than something...

    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 R2 EE Active-Passive Cluster Installation Issue

    DUPLICATE POST

    Please reply using http://www.sqlservercentral.com/Forums/Topic1250853-146-1.aspx?

    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 R2 EE Active-Passive Cluster Installation Issue

    The account needs to have the Domain 'Add workstations to Domain' right.

    This can be granted on its own via a script, or your account can be added 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: sql 2005 (32bit) on Windows Server 2003 (64bit) AWE enable?

    My understanding of how AWE works means that AWE is not available on a 64-bit OS. Therefore the 32-bit SQL Server functionality that allows use of memory above 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: How many IP address include in 2 node active -passive cluster

    Don't forget that if you are running on Windows 2008 or above, ther are useful performance benefits from having one MSDTC instance per clustered node if you are running any...

    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: Integrate SQLExpress 2005 Installation

    There are a few things that can help.

    http://sqlinstaller.codeplex.com aims to integrate the SQL install into .Net applications. My guess is that it provides some classes that act as 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

  • RE: SQL Server 2008 R2 Installation and Service Packs.

    FineBuild aims to provide a SQL Server installation complete with requested Service Pack and CU plus best-practice configuration from just a single click.

    I have also seen some other SQL installation...

    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: Differential Backups in SQLServer 2005

    IMHO unless you get to above 1TB, there is very little advantage to taking a differential backup compared to a full backup, especially where the full backup is at 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

  • RE: WWBOD

    I've never got to my FU level, but I have there are more important things than trying to get it. At the start of 2010 I dropped to half-time...

    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: Possible to install sql server 2008 to Windows 2000 server opeation sys

    The SQL Server install checks the operating system when it starts, and Windows 2000 fils this check.

    The error message will tell you the name of the rule that does 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

Viewing 15 posts - 781 through 795 (of 2,497 total)