Jeff Moden

Forum Replies Created

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

RE: find out who / what casued my database to increase in size?

If proc cache hasn't been cleared, it may show up in the built in reports as one of the queries that used the most I/O.
--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 21, 2017 at 2:59 pm

#1947644
RE: Are the posted questions getting worse?

Sean Lange - Wednesday, June 21, 2017 12:21 PM
Luis Cazares - Wednesday, June 21, 2017 10:32 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 21, 2017 at 2:49 pm

#1947642
RE: Using Ntile for fixed number of rows

Jason A. Long - Wednesday, June 21, 2017 1:42 PM
See if something like the following will work for you.
Test data...

IF...
--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 21, 2017 at 2:44 pm

#1947640
RE: Where to use ISNULL to convert NULL in PIVOT result set

I wouldn't put it anywhere in a PIVOT for the very reason of NULLs. If you use a CROSSTAB instead, it's all "auto-magic" and can be twice as fast, as...
--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 21, 2017 at 2:14 pm

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

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