Viewing 15 posts - 76 through 90 (of 160 total)
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...
September 20, 2019 at 7:07 am
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...
August 27, 2019 at 2:37 pm
@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...
August 26, 2019 at 3:07 pm
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...
April 23, 2019 at 2:35 pm
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...
April 10, 2019 at 12:54 pm
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...
February 28, 2019 at 5:45 am
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...
February 6, 2019 at 6:30 am
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...
January 10, 2019 at 12:55 am
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...
December 15, 2018 at 9:25 am
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).
December 13, 2018 at 8:46 am
Rune Bivrin - Tuesday, September 25, 2018 1:54 AMI didn't realize it was October 12 already 🙂
well, time passes faster, the older...
September 25, 2018 at 2:17 am
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...
August 23, 2018 at 12:54 am
I did not make many tests for edge cases and wrote this only a short proof of concept, but this piece of code would return the same and would be...
August 23, 2018 at 12:41 am
Since we have to do diffent tasks (or little steps toward this tasks) every day, a good day would be the wrong measurement. When I have a big tasks that...
August 17, 2018 at 9:02 am
Viewing 15 posts - 76 through 90 (of 160 total)