Forum Replies Created

Viewing 15 posts - 271 through 285 (of 2,497 total)

  • RE: Byte Me: Wrong turn

    We are always going to have 'bad data', and we should be helping to set user expectations about its reliability. This could be difficult for some users to cope...

    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: Deleted

    I suggest you use the most recent training material you can find.

    There is very little that was in SQL 2012 that is not in SQL 2016, the main...

    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: SSRS installation error on SQL Server 2016 cluster

    What kevaburg says works on all versions of SQL Server above SQL 2005 (it probably works on SQL2005 but I have not tested it there).

    You can also use this technique...

    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: Go Code

    When I left school in the early 1970s, almost 40% of kids my age struggled to get good grades at the age 16 exams. The UK Government statistics show...

    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: Looking for way to dynamically replace street suffix with abbreviation based on tables

    I know you are trying to replace full values with abbreviations and probably have good reasons to do this. However, if this was my system I would be looking...

    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 backup

    Going back to Krasavita's original question: how long will it take to back up 600GB?

    As seen in the replies, the answer depends on many things. To a large extent,...

    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: backward compatibility

    The SQL 2005 backward compatibility pack can be installed with any version of SQL Server above SQL 2005. It is not needed with anyt version, unless 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: Fact table with hundred of columns - Any alternative?

    Definitely you need to know which attributes relate to Facts and which relate to Dimensions.

    As a starting point, if the attribute is numeric and the aggregated value 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: Deleted

    SSAS will probably be useful for a few years to come, but R Services will become the main analysis tool of the future. I would not be surprised if...

    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: Unable to install SP1 or SP1 CU5

    Please do not uninstall any version of .Net on any box you hope to continue to use. There are a vast number of inter-dependencies that may get broken. ...

    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: peer to peer replication PK violation issue.

    When I was Architect at Totaljobs Group we implemented P2P replication.

    One of our design criteria was to reduce operational risk. We already had our applications written 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: A Beautiful Google Mind

    Most people who read this will have charities nearby that could really use some part-time technical support. It is worth finding one that works in a field you like...

    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 Agent stopping automatically in SQL Server 2016 Cluster

    When you uninstalled your ins1, ins2, did you clean out the redundant virtual names from AD?

    If AD still has an entry that relates to the original ins1 Agent...

    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: Alternate Way to Write query: ISNULL function causing issues

    I think both the original code and all the alternatives suggested would prevent the use of an index to resolve the clause using pdenddate. This is due to 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: File Stream

    You don't want your antivirus to read the filestream container

    Agreed!! If you are concerned about storing a virus, then most A/V products have an API that allows a .Net application...

    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 - 271 through 285 (of 2,497 total)