Quick thought, algorithms like Levenshtein Distance are overkill for such a naive comparison.

😎

Here is one way of doing this:

USE TEEST;
GO
SET NOCOUNT ON;
GO
---------------------------------------------------------------------
-- SAMPLE DATA
---------------------------------------------------------------------
DECLARE @COMPTEXT TABLE
 (
...

• This reply was modified 3 years, 1 months ago by Eirikur Eiriksson.

You can't "restore" the mdf file on its own. You can attach it though. Here's an example.

By the way, sounds like the database is in FULL recovery, but...

Question: what kind of connectivity do you have between the two instances?

😎

Migrating the data via CSV export/import is one of the most labour-intensive methods.

The problem is simple, but it would be helpful when you post a problem like this, if you post a readily consumable date set, have a look at the code...

Yet again it would be helpful if we could see the actual execution plan!

😎

Your approach is fundamentally flawed as you cannot select missing values from which the values are missing!

😎

The solution is simple, this example should get you over this hurdle:

            
October 23, 2022 at 10:28 am
            
#4103257

            
            
                                                
        

One shouldn't trust any such software further one can throw a double-decker bus.

😎

Network packet capture tools like Wireshark and a properly configured firewall are the minimal precautions. This is why...

Colour me simple, but why not use the Spatial Data Type for this?

😎

The sp_MSForEachDB procedure is not on my menu,...

Just a quick thought, here is a slightly more efficient way 😉

😎

SELECT
    COLL.DATA.query('.')
FROM @MapRules.nodes('/root/collections/collection') AS COLL(DATA)
WHERE COLL.DATA.value('(groupby/text())[1]','NVARCHAR(50)') = 'RoomNumber';

Reduces the query's work by ca....

The problem is straightforward, but we need your help in order to help you.

😎

Can you please post the DDL (create table) script, sample data as an insert statement and the...

I need a T-SQL script to find, for a given view across all databases (they all have this one particular view), which ones contain a specific column and which...

My thought is that, whichever approach you'll take, you are now into the regression testing season, good luck!

😎

If you can make 2019/2022 appear as 2008 you should seriously consider getting...

• This reply was modified 3 years, 2 months ago by Eirikur Eiriksson.

Quick question, do you need to capture inserts? If you are capturing updates and deletes, the inserts will be in the source table, normally no need to duplicate that data!

😎

Given...

Slightly improved version, a test harness and the results from my modest little laptop.

😎

The function:

USE TEEST;
GO
SET NOCOUNT ON;
GO
CREATE OR ALTER FUNCTION dbo.ITVF_UXTS_TO_DT2B
(
    @UXTimeStamp BIGINT
)
RETURNS...