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 6 years, 7 months ago by Thomas Franz.

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...

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...

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...

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...

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...

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).

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...

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...

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...

Here a version, which uses selfreferencing CTEs:

CREATE TABLE dbo.synonym (synonym VARCHAR(50) NULL, word VARCHAR(50) NULL, sort_order INT PRIMARY KEY);
INSERT INTO dbo.synonym (synonym, word, sort_order)
VALUES...

In my opinion this is a very bad script.
- Scalar functions (as those) are very slow
- creating a table variable (since you can't use #temp-tables inside a function)...

The whole, valid command would be (plus maybe some with-options)
RESTORE VERIFYONLY FROM DISK='\\SERVER1\Backup\my_big_db\FULL\SERVER1_my_big_db_FULL_20180803_210600.bak'

Sorry, but checking the disk space does not make any sense, since I do...