Forum Replies Created

Viewing 15 posts - 76 through 90 (of 162 total)

  • Reply To: Quickly Dropping Columns

    I find the answers a little bit misleading. If a column is part of another index, FK or constraint, it just can't be dropped (without dropping / changing the index,...

  • Reply To: Compare data of two tables

    CHECKSUM(*) or BINARY_CHECKSUM(*) could be an option but this needs all columns in the same order and (sometimes) equal data type.

    Beside of this the function may work or a good...

  • Reply To: A Good Reason to use a VCS

    MVDBA (Mike Vessey) wrote:

    when they come running for restore of a proc from a 400GB database it kinda changes their mind

    Forbit them to create any table in the primary filegroup, than this...

    • This reply was modified 5 years, 2 months ago by  Thomas Franz.
  • Reply To: A Self-Tuning Fill Factor Technique for SQL Server – Part 2

    Nice article.

    My main problem with the fill factor is, that I can't set it per partition. So I have either to waste a lot of space in my old, cold...

  • Reply To: Minimalistic SELECT

    @Carlo: so the dot in SELECT 1.test is not a whitespace or a dot as between filename and extension, but a simple decimal separator without a following decimal number as...

  • Reply To: What Keeps You Employed?

    Jobdescription: Well, it depends 🙂

  • Reply To: Get the Datetime

    be aware, that adding dates / times only works with the DATETIME data type but not with the new (ANSI compatible) DATETIME2 (this would cause Error 8117: Operand data type...

    • This reply was modified 5 years, 7 months ago by  Thomas Franz.
  • Reply To: Filestream on partitioned table

    Just stumbled over this old question.

    A possible anwere would be: try to disable the index instead of dropping it. After the switch you have to rebuild it (may take very...

  • RE: Index Column Order – Be Happy!

    I miss one important version:
    If you regularly filter for Status = 5 (and not 3 or 4 or 6 or anything else) and OrderDate BETWEEN x and y, the...

  • RE: A Tiny Trauma

    The tinyint is not your problem. Sure, after changing it to smallint, you will not receive an aritmetic overflow exception, but your data will be invalid (negative). So you only...

  • RE: Synonyms

    I think a problem with synonymes (as with several other "solutions") is SourceControl. When I use them to refer to database db_prod or db_test (depending on my environement) it will...

  • RE: The Number that shouldn't be a number

    even in this case (breaking down to daily or even hourly costs) you can not invoice more than rounded cents. So more precisition will only prevent rounding errors, if you...

  • RE: The Number that shouldn't be a number

    Worst data types: I've seen money values, that are usually < 100 EUR be stored in DECIMAL(38,17) columns (and many percentage columns with the same declaration too).

  • RE: CASTING Binary to BIGINT

    Rune Bivrin - Tuesday, September 25, 2018 1:54 AM

    I didn't realize it was October 12 already 🙂

    well, time passes faster, the older...

  • RE: Indexing a Computed Column

    You should / could have mentioned that an index persists the column (but only in the index itself) too.

    Persisting on the table level safes you a little...

Viewing 15 posts - 76 through 90 (of 162 total)