Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,236 through 5,250 (of 59,101 total)

Reply To: Working Predictable Hours

JRuss wrote:
Reported in The Economist just last week: "Working 55 hours or more a week is 'a serious health hazard' according to the World Health Organisation, in a first global...
--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 28, 2021 at 7:08 pm

#3889359
Reply To: Speed up join

@scott745618,
I suspect that there's some pretty nasty accidental many-to-many joins based on the account number and date. Take a look at the article at the 2nd link in my signature...
--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 28, 2021 at 1:52 pm

#3889229
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

Rasmus Remmer Bielidt wrote:
I realise that I am a bit late to the party. The percentage increase is one that many people get wrong.
When I demonstrate similar issues, I like to 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 28, 2021 at 12:54 pm

#3889196
Reply To: Query never completes on HAG primary replica but runs in seconds on Secondary

I'll go one step further... stop using REORGANIZE except to compress LOBs and then make sure that you do a REBUILD right after because it also compresses the indexes. It...
--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 28, 2021 at 12:15 am

#3888992
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

Viewing 15 posts - 5,236 through 5,250 (of 59,101 total)