Also, if the %of duplicates is higher than the % of singles, then it may be better to copy the singles into a new table and switch out...

Also, if the %of duplicates is higher than the % of singles, then it may be better to copy the singles into a new table and switch out the partitions

DROP TABLE IF EXISTS #test;
CREATE TABLE #test ( ValueId varchar(30));

INSERT  #test ( ValueId )
VALUES ( '1' )
     , ( '99'...

DROP TABLE IF EXISTS #test;
CREATE TABLE #test ( ValueId varchar(30));

INSERT  #test ( ValueId )
VALUES ( '1' )
     , ( '99' )
 ...

BUT, that will only work if LEN(ValueID) <= 12

For longer strings, you will need to break ValueId into parts to match the GUID pattern

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, 7 months ago by DesNorton.