Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 59,072 total)

Reply To: Sql error log?

Did the job ever work or is it brand new?

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 27, 2021 at 12:09 pm

#3888698
Reply To: Recursive CTE

Scott745618 wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 27, 2021 at 12:06 pm

#3888697
Reply To: Recursive CTE

Scott745618 wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 27, 2021 at 10:43 am

#3888669
Reply To: How can I tell where my Database encryption keys are kept
Steve Jones - SSC Editor wrote:
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.
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-column-encryption-keys-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-column-master-keys-transact-sql?view=sql-server-ver15
Awesome... thanks Steve. We don't use any...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
May 27, 2021 at 10:21 am

#3888666
Reply To: loading data from staging table to final with validations to data specific

asita wrote:
Hello Jeff,
Can you please help with it in the way you advised in SQL SERVER.
https://www.sqlservercentral.com/forums/topic/how-to-insert-data-to-target-table-when-there-is-no-matching-and-update-if-has#post-3888376
Thank you
ASiti
Sorry... I kind of ignored this thread because it looked like folks had...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 27, 2021 at 10:13 am

#3888663
Reply To: Parse a very large delimited string

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 27, 2021 at 9:58 am

#3888648
Reply To: Parse a very large delimited string

Thom A wrote:
fgrodriguez wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 27, 2021 at 9:40 am

#3888643
Reply To: Agree or Lose Features

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. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 26, 2021 at 4:16 am

#3888023
Reply To: Query to Get Differences in Table Sizes

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 25, 2021 at 8:39 pm

#3887922
Reply To: Timing of GETDATE as a column default

Jeffrey Williams wrote:
Jeff Moden wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 25, 2021 at 6:54 pm

#3887871
Reply To: Recursive CTE

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 25, 2021 at 6:24 pm

#3887859
Reply To: MERGE statement with MATCH based on multiple fields

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 25, 2021 at 6:22 pm

#3887858
Reply To: The "magical" switch statement.

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 25, 2021 at 6:17 pm

#3887855
Reply To: Timing of GETDATE as a column default

Sergiy wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 25, 2021 at 2:26 pm

#3887761
Reply To: Timing of GETDATE as a column default

Jeffrey Williams wrote:
Jeff Moden wrote:
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. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 25, 2021 at 2:23 pm

#3887759

Viewing 15 posts - 5,206 through 5,220 (of 59,072 total)