Viewing 14 posts - 1 through 14 (of 14 total)
I would like to see how many people are born on Jan 1 1900 in leaked databases 😀
I think fraud is probably the most common criminal attack, so prized PII...
December 14, 2020 at 11:27 am
True, though one would expect SSC to store data using an
nvarchar
. I, unfortunately, can't edit it so I've emailed the WebMaster.
Agreed. For what it's worth, I still enjoyed...
November 3, 2020 at 9:47 am
Might be worth updating the question to use NCHAR to get the character. Code written in good old ASCII won't let you down 😉
DECLARE @val NCHAR =...
November 3, 2020 at 9:29 am
Learned something new!
I knew about this one:
t = ['a', 'b', 'c']
print(*t)
The unpacking thing is cool, can put the asterisk in the middle too:
for name...
October 9, 2020 at 6:55 am
Can I ask what tools you're using? I assume you're getting timing from third party tools. What I'd love is a way to check execution plan regressions.
Sorry, I may...
September 23, 2020 at 3:48 pm
Is it viable to check for application performance regressions by running a workload on SQL Server 2019, recording metrics, and then running the same workload on the same...
September 22, 2020 at 8:15 am
Is it viable to check for application performance regressions by running a workload on SQL Server 2019, recording metrics, and then running the same workload on the same app &...
September 21, 2020 at 10:47 am
Hi Palotaiarpad.
I think this is because the question states, "I need to code some SQL in my application", which means that it's an ad-hoc query from the application. Creating a...
June 29, 2019 at 8:29 am
Cool, thanks for confirming. You definitely achieved your goal of raising awareness of sp_prepexec() - I'll remember that one for the future 🙂
June 27, 2019 at 4:13 pm
Is it not one round trip if you put both statements in the same batch? In Java I think the following is only 1 round trip:
Statement stmt...
June 27, 2019 at 12:39 pm
OK, I have confirmed that there are no duplicates in the staging table at any point. So right now there is actually no reasonable explanation for the PK violation. There...
March 20, 2017 at 7:31 am
Sergiy - Sunday, March 19, 2017 8:06 AMDoes table @staging_table_var have a PK on column [staging]?
March 20, 2017 at 5:24 am
Hi Kevin. I was also paranoid about the optimizer ignoring the SELECT. I checked the locks acquired in a SQL Profiler trace and right in-between the StmtStarting and StmtCompleted of...
March 6, 2017 at 10:21 am
Hi Ken. Thanks for the suggestion. I read a nice article about a cleaner way of doing the upsert using a pattern similar to what you described. The article:
March 6, 2017 at 9:47 am
Viewing 14 posts - 1 through 14 (of 14 total)