Viewing 15 posts - 766 through 780 (of 2,654 total)
assuming you are using US formats you can do
select convert(decimal(10, 2), parse('$16,500.50' as money using 'en-US'))
September 20, 2022 at 9:08 am
for those who avoid twitter (like me) https://www.inverse.com/entertainment/babylon-5-reboot-cast-release-date-2023
September 19, 2022 at 3:16 pm
I'm not sure how server specs would translate to different behavior in the query engine. I did actually verify that the problem is version- specific. And a calculation with...
September 18, 2022 at 8:57 pm
even on the same version but with different server specs it can return different results - I would not consider it a bug but rather a consequence of using float...
September 18, 2022 at 9:49 am
I want more of B5... for work I would like those that don't understand the technology would include and listen to those that do in their discussions.
September 17, 2022 at 2:39 pm
multiple issues there.
Union on its own needs to sort the data to remove duplicates - adding to this you have identity_insert on which has its own issues.
and (probably the worst)...
September 17, 2022 at 1:44 pm
to use UTF8 in SQL 2019 NVARCHAR is not required (see https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16#Unicode_Defn) - but increasing the size of the existing varchar MAY be required.
have a look at https://techcommunity.microsoft.com/t5/sql-server-blog/introducing-utf-8-support-for-sql-server/ba-p/734928
September 15, 2022 at 11:16 am
example of what I do on one of my databases with regards to users and groupmembership
note the detail of formatting the dates in a very specific format as well as...
September 14, 2022 at 3:38 pm
You want the unique clustered index on ( date_, ID_vard ), assuming that you do primarily query the table by date_, and not on just ID_vard.
Can you clarify how...
September 13, 2022 at 3:57 pm
You should look at partitioning the table by period.
Maybe.. maybe not.
one of my main big tables (clustered columnstore) is partitioned as well - but each partition has 3 Billion...
September 13, 2022 at 3:29 pm
Columnstore is good for aggregation SQL's - not for plain retrieval of data but 45 min still looks very bad.
on your case I would be interested in seeing how it...
September 13, 2022 at 2:36 pm
if you get the files in Excel and convert to CSV then it would be better if you define the format of the dates at that point - assuming the...
September 12, 2022 at 10:15 pm
You also need to consider licencing costs for MSSQL and they can be very complicated. From memory the minumum licence is 4 cores and then in multiples of 2...
September 12, 2022 at 4:48 pm
there is nothing we can say to help you there - all those values are specific to your own AD structure. It can be whatever your admins decided it would...
September 10, 2022 at 2:21 pm
why don't you try it? should be rather easy for you to set up a test case on your own instead of spending time asking if it is possible.
you even...
August 31, 2022 at 3:20 pm
Viewing 15 posts - 766 through 780 (of 2,654 total)