Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,986 through 18,000 (of 59,069 total)

RE: pager life expectancy is 220 seconds. Would buffer pool extensions help

Snargables (3/30/2016)
I realize our internal BI guys are writting procs that need to be optimized. I've identified the high logical ready processes and plan on optimizing them. In the mean...
--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)

March 30, 2016 at 12:07 pm

#1868697
RE: The Younger Generation

It's not just the "younger generation", whatever that is (they're all younger than me lately). Going back to the interviews I've been conducting, there are people of all generations...
--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)

March 30, 2016 at 11:09 am

#1868680
RE: Convert a string with an array of variables?

I've got a pretty good and uber simple process for doing such things. I use it to replace nearly 500 address parts and it's nasty fast. I'll try...
--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)

March 30, 2016 at 11:04 am

#1868676
RE: Is PowerShell Intimidating?

Gary Varga (3/30/2016)
RP1966 (3/30/2016)
...I always loved the Unix shells - in comparison Powershell is just so clunky and verbose...
I think that you might benefit a lot from the aliases which...
--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)

March 30, 2016 at 10:55 am

#1868672
RE: Need help on getting last day of the months in seconds for 13 months

@Tamrak,
Please explain why you want the last second of the month. Is it because you think that's the way to get everything for a given month? If not,...
--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)

March 29, 2016 at 9:08 pm

#1868455
RE: Log files will not Shrink:

dopydb (3/29/2016)
Excellent ! it seems one of our applications are leaving residual transactions open that will never be killed of until sql would be rebooted!
mal
THAT needs to be fixed. ...
--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)

March 29, 2016 at 8:33 am

#1868261
RE: Dexterity Matters

From the article:
...[font="Arial Black"]is especially apparent in Azure [/font]and online interfaces where the control, or the browser, might not respond as quickly as I expect.
Sounds to me like dexterity isn't...
--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)

March 28, 2016 at 8:50 pm

#1868128
RE: DBA Service

gaktheknife (3/28/2016)
Hello All,
We currently do not have an on premise DBA we have a DBA Service that monitors our Databases now. I did not set the service up but...
--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)

March 28, 2016 at 5:10 pm

#1868112
RE: Finding months in incremental fashion

Ah... sorry... didn't realize this was a post from nearly 2 years ago and the OP hasn't logged in since 2015-11-12.
--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)

March 28, 2016 at 3:11 pm

#1868095
RE: Need help on getting last day of the months in seconds for 13 months

Lynn Pettis (3/28/2016)
Jeff Moden (3/28/2016)
Tamrak (3/28/2016)
Thank you very much.
Do you actually understand HOW it works?
Probably not, but then he hasn't told us how he will be using it either.
That's 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)

March 28, 2016 at 3:07 pm

#1868094
Reply To: Running Totals with window function

Heh... and they say the Quirky Update method is complicated. :blink:
--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)

March 28, 2016 at 2:54 pm

#1868091
RE: Need help on getting last day of the months in seconds for 13 months

Tamrak (3/28/2016)
Thank you very much.
Do you actually understand HOW it works?
--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)

March 28, 2016 at 2:49 pm

#1868088
RE: Need help on getting last day of the months in seconds for 13 months

Tamrak (3/28/2016)
I wrote the query and it returned the results only on the 28th of each month.
With cteMonths
as (
select DATEADD(s, -1, DATEADD(m, DATEDIFF(m, 0, GETDATE())-12, 0)) AS ReportMonth, row_number()...
--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)

March 28, 2016 at 2:46 pm

#1868087
RE: Need help with datatype Time conversion

Luis Cazares (3/28/2016)
Jeff Moden (3/28/2016)
Luis Cazares (3/28/2016)
I'm guessing that Jeff is thinking on taking a similar path to this, but wants to be sure about the possible restrictions.
Exactly. And,...
--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)

March 28, 2016 at 8:52 am

#1867991
RE: INSERT Statement - How to Handle to Avoid Thousands

kocheese (3/28/2016)
AH. I gotcha now and see what you are saying / doing. Makes sense now. Thank you for the help. Appreciate it
And now you know...
--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)

March 28, 2016 at 8:37 am

#1867985

Viewing 15 posts - 17,986 through 18,000 (of 59,069 total)