Viewing 15 posts - 2,701 through 2,715 (of 59,067 total)
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
Oooooooo... thank...
September 15, 2022 at 2:43 pm
hi,
from this link https://docs.microsoft.com/en-us/sql/ssms/scripting/search-text-with-regular-expressions?view=sql-server-ver16
i found :b matches either space or tab charcters , pls tell me how to use. i used but it was not working.
We have no idea...
September 15, 2022 at 2:30 pm
Thanks for the feedback, Thomas. I'll have to leave that up to the individual user because, although close, UNIX TimeStamps are not quite the same as UTC even if people...
September 15, 2022 at 2:05 pm
And, my apologies... I left left the "K' off the 120 above (just fixed in my original post above) but that's still a long way away from the millions of...
September 14, 2022 at 10:02 pm
Here's another good one... the Op recently marked an answer as accepted on the other thread and said nothing on this one. Fun, eh?
It would likely be faster still if...
September 14, 2022 at 9:07 pm
I suspect that the bulk of the cost is coming from the sort operation in the STRING_AGG() function. And assuming that sort is necessary to meet requirements,...
September 14, 2022 at 8:50 pm
I suspect that the bulk of the cost is coming from the sort operation in the STRING_AGG() function. And assuming that sort is necessary to meet requirements, that same...
September 14, 2022 at 7:39 pm
Removed what's probably an inappropriate rant based on extreme frustration.
September 14, 2022 at 7:31 pm
p.s. Ask the fellow that made the XML suggestion for the code. 😉
September 14, 2022 at 7:24 pm
You don't understand... it's not the STRING_AGG that's the issue (it's a symptom of the real problem) and using XML to do the same thing isn't going to solve a...
September 14, 2022 at 7:19 pm
I'm pretty sure that you want to change to NVARCHAR(), instead. IIRC, UTF-8 is a Unicode encoding.
September 14, 2022 at 6:36 pm
only Log for those full recovery model.
To echo one of Johan's questions, how often do you do those?
September 14, 2022 at 6:28 pm
This appears to be a near duplicate post from the following...
Good luck in getting this OP to answer questions. I still have a few outstanding questions there but, to be...
September 14, 2022 at 6:25 pm
Grant does a great job of presenting both Redgate and non-Redgate topics btw.
Cheers!
Very kind of you to say. Could you share it with my boss?...
September 14, 2022 at 4:49 pm
I get this error:
Get-ADUser : The supplied distinguishedName must belong to one of the following partition(s):
any ideas ???
You've still not explained what you intend to glean from the AD...
September 14, 2022 at 4:09 pm
Viewing 15 posts - 2,701 through 2,715 (of 59,067 total)