Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,096 through 10,110 (of 59,099 total)

RE: Slow stored procedures after migration 2008 to 2016 SQL server

alexandermkd - Thursday, January 10, 2019 6:32 AM
Hi federico,
i have executed manualy EXEC TARIFF_SIM_MATRIX_3M 1; (with parameter 1) and both executions plan are...
--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)

January 10, 2019 at 8:05 am

#2018529
RE: SQL Quiz

Lynn Pettis - Wednesday, January 9, 2019 9:20 AM
Jeff Moden - Wednesday, January 9, 2019 8:29 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)

January 9, 2019 at 9:29 am

#2018430
RE: SQL Quiz

Lynn Pettis - Monday, January 7, 2019 4:08 PM
And someone else has posted this same question, so who is to know who...
--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)

January 9, 2019 at 8:29 am

#2018426
RE: substring with Charindex

Jeffrey Williams 3188 - Tuesday, January 8, 2019 3:08 PM
If the values in the string can be in any order 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)

January 9, 2019 at 8:06 am

#2018425
RE: Are the posted questions getting worse?

xsevensinzx - Wednesday, January 9, 2019 7:27 AM
Question for the crew here. How many of you are using UML at the workplace?...
--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)

January 9, 2019 at 8:02 am

#2018424
RE: Are the posted questions getting worse?

Beatrix Kiddo - Wednesday, January 9, 2019 7:06 AM
Also Lincoln Burrows is bumping a LOT of very old threads for seemingly no...
--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)

January 9, 2019 at 7:37 am

#2018421
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

jadhavdileep2008 - Wednesday, January 9, 2019 7:04 AM
RBarryYoung - Monday, April...
--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)

January 9, 2019 at 7:31 am

#2018420
RE: substring with Charindex

drew.allen - Tuesday, January 8, 2019 2:06 PM
Michael L John - Tuesday, January 8, 2019 1:14 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)

January 9, 2019 at 7:21 am

#2018417
RE: substring with Charindex

ettentrala - Tuesday, January 8, 2019 1:43 PM
I able to do this.
--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)

January 9, 2019 at 7:13 am

#2018415

RE: Database in RECOVERY PENDING state - Access Denied

angelinemarren - Wednesday, January 9, 2019 4:27 AM

Jeff Moden - Tuesday, January 8, 2019 10:02 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)

January 9, 2019 at 6:42 am

#2018409