We create a separate schema.  Permissions are provided to the schema.

Then for every object that needs to be exposed, we create a synonym under the exposed schema that maps to...

I have never used DDM.

But, a few observations

Image data type is deprecated, and should be replaced with varbinary(max)

Since the data in image and (var)binary fields is not human readable,...

If you insist on casting your key to a datetime, then you need to find the values that SQL is having difficulty converting.

Try this snippet to see what data it...

From the code, A and B are the same table.  So, why are you making SQL jump through hoops when joining the column to itself.  Simply join ON A.validon =...

Take a look at this article from Phil Factor

Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt

It has sample extended events snippets for...

From the plan, it appears that you are returning 5.3mil rows.

Do you REALLY need that much data in the results?

However, doing a COUNT(*) so that we remove the time to push to display, seems to prefer the early filtering for CPU usage.  Elapsed time still seems to prefer the...

Do we get any performance benefit by moving the TOP clause up into the Tally cte.

My gut says it is better to reduce the actual number of items as soon...

This post by Brent Ozar is a starting point

https://www.brentozar.com/archive/2016/04/another-hidden-parallelism-killer-scalar-udfs-check-constraints/

_TIMESTAMP is a datetime datatype, so SQL has no way to determine the timezone.

This is why you nee a double "AT TIME ZONE" to do the correct conversion.

There is no...

• This reply was modified 2 years, 4 months ago by DesNorton.

What version of SQL are you using?

As stated in the other thread, download and install the following function in your DB

CREATE_FUNCTION_dbo_DelimitedSplit8K_LEAD.sql

Then use it as follows

WITH cteTwoWords AS (
  SELECT TwoWords =...

Did you download and install dbo.DelimitedSplit8K on your SQL instance?

If you are using an earlier version of SQL, then I suggest that you read Tally OH! An Improved SQL 8K “CSV Splitter” Function by Jeff Moden. ...

As ratbak indicated, you have posted in a SQL 2022 forum.  As such, my proposed solution uses functionality that is available in SQL 2022.

If you are using SQL 2012 to...