Viewing 15 posts - 5,191 through 5,205 (of 59,068 total)
Sorry I could not include the data it was a work project. I've simplified the CTE so now I don't need the lead so everything is working. I am...
May 27, 2021 at 12:06 pm
Is there any resources for learning UDFs? I have look online but I could only find basic introductions. I am keen to fully understand how I can best use...
May 27, 2021 at 10:43 am
Always Encrypted is different than TDE. If you are using ALways Encrypted, the keys are in sys.column_encryption_keys and sys.column_master_keys.
Awesome... thanks Steve. We don't use any...
May 27, 2021 at 10:21 am
Hello Jeff,
Can you please help with it in the way you advised in SQL SERVER.
Thank you
ASiti
Sorry... I kind of ignored this thread because it looked like folks had...
May 27, 2021 at 10:13 am
Also... make sure you test the "Devil" out of any SQLCLR you might use for this... a lot of people have a lot of different ideas of what should happen...
May 27, 2021 at 9:58 am
Here https://sqlperformance.com/2012/07/t-sql-queries/split-strings you have a performance comparison for some methods.
As you can see, the CLR versions have no comparison with the rest. You can build...
May 27, 2021 at 9:40 am
I have to disagree... this isn't a "Disturbing" technique. Companies are being forced into a position of being able to be sued because of information that they're supposed to protect. ...
May 26, 2021 at 4:16 am
I'm thinking that you don't actually want an Average... I'm thinking that you want a Linear Regression and, perhaps, the Mode. You should also relegate a "0" input to a...
May 25, 2021 at 8:39 pm
They actually are NOT affected at the same time. They are inserted just as they are in any file system. Just because it's a relational database doesn't change...
May 25, 2021 at 6:54 pm
I guess I don't understand the need to "loop through the records". A well written WHILE loop is usually faster and about 8 times less resource intensive. That, notwithstanding, why...
May 25, 2021 at 6:24 pm
I'll second what Jonathan stated about performance. I also have a really bad aftertaste about MERGE and all the nightmares it caused when it first came out. They may have...
May 25, 2021 at 6:22 pm
That's pretty interesting, Steve. I'm going to have to give that a try on a much larger table. I'll be back but not today... I've got a really full dance...
May 25, 2021 at 6:17 pm
To cover that 0.1% I can add triggers to the mix.
they must have table "inserted" available with all the records in it, the whole set. And it cannot be...
May 25, 2021 at 2:26 pm
When you said "If SQL Server 6.5 and 7 worked that way - then it was incorrect.", the only thing that was incorrect there was you thinking so. ...
May 25, 2021 at 2:23 pm
My very general advice would be to stick to base tables and not use any of the features outside of the ANSI ISO standards for creating tables. Essentially, this...
May 25, 2021 at 1:04 am
Viewing 15 posts - 5,191 through 5,205 (of 59,068 total)