Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,016 through 18,030 (of 59,102 total)

RE: mysterious slowdown every 4 minutes

andrea.dimaio (3/31/2016)
Hi
I' ve a database used to a gaming application. 99% of procedure called by the application are 2 stored procedure called 'new_transaction' and 'upd_trandaction'. Those stored are called usually...
--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 31, 2016 at 8:12 am

#1868857
RE: Is PowerShell Intimidating?

Manic Star (3/31/2016)
I just wrote a script in PS that iterates through my databases on server X and gives me a lovely csv file of all the permissions on all...
--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 31, 2016 at 8:03 am

#1868854
RE: Is PowerShell Intimidating?

Manic Star (3/30/2016)
Powershell is awesome! Then i'm a former developer, so it was like the power of .net without the annoying user interface layer to program. It just does what...
--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:24 pm

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

Viewing 15 posts - 18,016 through 18,030 (of 59,102 total)