Viewing 15 posts - 3,121 through 3,135 (of 7,614 total)
| Vardecimal storage format | Use of vardecimal storage format was encountered. Use data compression... |
October 9, 2018 at 2:41 pm
October 9, 2018 at 10:42 am
October 9, 2018 at 10:19 am
October 9, 2018 at 9:27 am
If you want to limit the delimiters to strictly:dot, comma, underscore and space, in the code below, change:
PATINDEX('%[^A-Z0-9]%'
to
PATINDEX('%[.,_ ]%'
SELECT
CASE...
October 8, 2018 at 2:54 pm
October 7, 2018 at 6:00 pm
Yes, they are the same in SQL Server.
SQL chose not to treat extra decimal positions as en error, instead it implicitly rounds to the stored scale. I assume...
October 5, 2018 at 2:36 pm
Fwiw, I usually stick to sp_refreshview for views, and only use the broader module proc when I need to.
October 5, 2018 at 2:32 pm
October 5, 2018 at 12:26 pm
October 5, 2018 at 11:01 am
constraints
- PERIODYTD date is always greater or equal to PERIOD
- difference between the...
October 5, 2018 at 9:50 am
Yes, you can combine them into one integer and get them back. The int value will most likely be negative, I don't know if that matters for you.
The...
October 4, 2018 at 3:35 pm
If you (almost) always look up on tableB by the MName, then cluster the table on that. That would prevent a full scan of the table from happening every time...
October 4, 2018 at 2:29 pm
Viewing 15 posts - 3,121 through 3,135 (of 7,614 total)