Question for the smart people, and the rest of you.

Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is...

This is interesting:

DECLARE @X NVARCHAR(MAX) = N'DECLARE @SQLSTR NVARCHAR(MAX)  
;with xdata as
(
SELECT  
    A = 2147483647/1000
   ,B = 2147483648/1000
 ...

I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know...

Sorry for the late response.

In short, a good practice for any migration is knowing what access and control methods are used by the applications on the current systems and making...

Could you please provide more details on what you are trying to achieve, like a description of before and after?

😎

Answering the question of separation of instances, "it all depends", there...

You might want to use the Lead version of the splitter

😎

CREATE FUNCTION [dbo].[DelimitedSplit8K_LEAD]
--===== Define I/O parameters
        (@pString VARCHAR(8000), @pDelimiter CHAR(1))
RETURNS...

There are several ways of achieving this, and selecting the best option depends on various factors.

😎

Quick questions:

1. How are you retrieving the raw values?
2. Are the raw values in a...

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

Quick question, can you post the DDL (create table) for the tables, sample data as an insert statement, what you have tried so far and the expected result set?

😎

The problem...

Quick question, can you post the DDL (create table) for the tables, sample data as an insert statement and the expected result set. This problem is trivial but in order...

Quick thought, nicely formatted and presented code.

😎

Further on Phil's and Jeff's comments, as much as we would like to answer a specific question, that specific question is missing so could...

Could you please elaborate further with some tangible details?

😎

From what you have posted, my first guess would be the wrong butterfly flapping its wings in the wrong direction in central...

Quick questions:

1. Excuse my ignorance, but what does QC stand for?
2. Have you looked at the sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities views?
3. Do you need to profile the data or is this...

Thank you guys for the response, much appreciated!

😎

Just reiterating a question I posted on the 2019 Administration forum, on SSMS backward compatibility, does anyone have any input?

😎

The issue is that I'm trying to simplify an environment...

I know... I'm weird... I couldn't stop laughing as I read the following article about AI and on-prem.  I mean who knew that computationally intense processes on the cloud...