you need to get another admin to do it - or you setup a SQL agent job to delete it for you (but will need to kill all sessions with...

and using a sql agent proxy (can be per defined 1 per job) is in a way better than using the xp_cmdshell proxy (system wide).

on a multi-tenant server using the...

if you have to ask you likely don't need it - and I have to say that there is huge amount of info on the net so you asking here...

big transaction that required more space to be allocated - when it failed it did a rollback so space is there now - but wasn't when the transaction was running...

can you give the full command line - change servername and package to something else but meaningful - this so we can see exactly which parms /options you passing to...

One more question though. When we assign primary key to a column it creates clustered index by default on that column but I know that in future I will...

assuming you are using US formats you can do

select convert(decimal(10, 2), parse('$16,500.50' as money using 'en-US'))

for those who avoid twitter (like me) https://www.inverse.com/entertainment/babylon-5-reboot-cast-release-date-2023

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

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

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.

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

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

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

• This reply was modified 3 years, 10 months ago by frederico_fonseca.

Can you clarify how...