« first day (3919 days earlier)      last day (23 days later) » 

7:05 AM
Morning
 
7:21 AM
Morning
 
7:36 AM
@JohnK.N. I wonder if some of Solomon's functions could come in handy.
 
8:34 AM
@JohnK.N. do you want to remove all CRLF or only those at the end of the text?
 
I want to replace CRLF with @@.
The idea is to replace CRLF with @@ during the export and then on re-import to the new system replace @@ with CRLF.
 
@JohnK.N. would you accept a CLR solution?
 
8:56 AM
Not sure. The less I have to alter the SQL Server instance, the better. I'm just going to add an important bit of information to the question.
 
 
1 hour later…
10:03 AM
Converting the ntext value to nvarchar(max) is the right answer
 
@PaulWhite ok
 
10:35 AM
@PaulWhite Does that still work if the ntext column has a record with more than 4000 characters?
yes it does. Just read the answer
 
@JohnK.N. Of course
 
 
3 hours later…
1:21 PM
how to get the people that you are asking for help annoyed postgresql.org/message-id/…
 
2:07 PM
@ypercubeᵀᴹ perhaps you need to ask more than once for a high precision answer.
 
2:43 PM
o_O
 
3:42 PM
good morning heap
@McNets Depending on the algorithm, it could converge on the correct answer more quickly than direct computation
 
4:02 PM
@bbaird ;) morning
 
4:14 PM
@PaulWhite I just took closer look at what your deterministic RemoveNonNumericCharacters() function for 2017+ is doing, and that's pretty smart. Translating the fixed list of characters you do want, so you can use the output to re-translate out the potentially infinite list of stuff you don't want. 👏 Awesome!
Just curious, why the collation clause?
 
4:55 PM
weird question of the day
4
Q: Can I carry 25 pounds in cash to UK without a receipt?

AakI am going to carry 25 Pounds (2* 10 Pounds note + 1* coin of 2 Pound + 3 * coin of 1 Pound) with me on a flight to UK. I don't have any receipt for this money. What questions I might face at immigration because of this?

 
 
1 hour later…
6:05 PM
As a dumb American, I was intrigued by that question because I read pounds as a unit of weight.
11.3 kg of cash would be a lot to haul around 😅
3
 
6:30 PM
I thought something similar when I first read the link/title only.
(if they could be allowed to carry a bag of 25 pounds)
the original post was:
> Can I carry 25 Pounds to UK without a receipt?
 
6:43 PM
@PaulWhite In this table swap, is it possible that new rows can go in the old table during the transaction, or is a table lock automatically going to happen due to the drop and rename later in the steps (assuming I wrap the whole thing in a transaction)?
 
 
3 hours later…
9:31 PM
@J.D. It makes string operations a lot faster when binary comparison is all that is needed. The full Unicode comparison rules are powerful but expensive
@CadeRoux Yes it is possible. Locks are taken as needed, not in advance.
So if concurrent inserts to the old table are possible you'd need to account for those before dropping 😀
To state the bleeding obvious at you
 
9:50 PM
@PaulWhite Yeah, is there a simple way to force that? Otherwise, I need to make it clear in the instructions for them to stop the service.
Meaning our OLTP system's service while they do the maintenance.
Like if I put WITH (TABLOCK) on the source table in the SELECT is that lock going to stay on the whole transaction or is it going to be released right before the DROP?
Seems like I need to ensure the isolation level is serializable.
 
10:30 PM
Sounds good, thanks Paul!
 

« first day (3919 days earlier)      last day (23 days later) »