Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,896 through 14,910 (of 59,097 total)

RE: Scalar function with source conditional to a parameter

Further, using scalar functions to select from a table is going to cause a performance problem. The function code needs to be converted to an iTVF.
--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)

June 20, 2017 at 12:29 pm

#1947442
RE: Your Job Description

Eric M Russell - Monday, June 19, 2017 1:06 PM
Jeff Moden - Saturday, June 17, 2017 9:30...
--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)

June 19, 2017 at 2:40 pm

#1947324
RE: Random Masking

Crud... "Random Masking". It thought it was an early question about Halloween. 😉
--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)

June 19, 2017 at 2:11 pm

#1947317
RE: Query to show units in use on each day for past 12 months

dcaulton73 - Monday, June 19, 2017 8:48 AM
Excellent, thank you that has sorted it. Not quite fully understanding what the COALESCE part...
--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)

June 19, 2017 at 2:09 pm

#1947316
RE: Parse SQL String

dEVafri - Friday, June 16, 2017 6:34 AM
The reason is that, I would also like to use this script in SQL Server...
--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)

June 18, 2017 at 2:32 pm

#1947198
RE: Use or abuse of full text searching

All "Costs" are really just estimates. The real key here is... is there actually a performance problem? How long does the query typical take to execute, how many CPU milliseconds...
--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)

June 18, 2017 at 2:30 pm

#1947197
RE: Your Job Description

David.Poole - Friday, June 16, 2017 2:02 AM
I think many job descriptions aren't worth the paper they are printed on. My role...
--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)

June 17, 2017 at 9:30 pm

#1947181
RE: Best way to handle a table-based queue?

Scott Coleman - Tuesday, June 13, 2017 8:58 AM
Jeff Moden - Monday, June 12, 2017 5:49 PM
--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)

June 14, 2017 at 6:52 am

#1946739
RE: Best way to handle a table-based queue?

Sergiy - Thursday, June 8, 2017 1:15 AM
In real life there is no threshold for execution duration.
True enough but, in real...
--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)

June 12, 2017 at 7:16 pm

#1946471
RE: Best way to handle a table-based queue?

Jeff Moden - Thursday, June 8, 2017 7:55 AM
Bill Talada - Thursday, June 8, 2017 5:01 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)

June 12, 2017 at 5:53 pm

#1946467
RE: Best way to handle a table-based queue?

Scott Coleman - Monday, June 12, 2017 2:50 PM
I'd still like to hear someone say why they don't use UPDATE ......
--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)

June 12, 2017 at 5:49 pm

#1946466
RE: Is the logic the same for these two queries?

Based on the fact that someone used the YEAR() function in one of the renditions of the code, can we safely assume that the t.tabdate column is a DATETIME column? ...
--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)

June 12, 2017 at 12:24 pm

#1946447
RE: Parse Data in SQL

Ed Wagner - Sunday, June 11, 2017 12:52 PM
Yep - the MS Docs page is definitely wrong. I just created a test...
--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)

June 12, 2017 at 8:02 am

#1946398
RE: Parse Data in SQL

If it were an NCHAR, you would need to be seriously concerned no matter what. I ran into this problem before with some system tables (can't remember which ones just...
--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)

June 10, 2017 at 8:23 pm

#1946314
RE: Parse Data in SQL

Here's the link for the current definition of PARSENAME.
https://docs.microsoft.com/en-us/sql/t-sql/functions/parsename-transact-sql
But Books Online and the link above is incorrect. PARSENAME actually returns an NVARCHAR(128), which is the...
--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)

June 10, 2017 at 6:23 pm

#1946312

Viewing 15 posts - 14,896 through 14,910 (of 59,097 total)