Jeff Moden

Forum Replies Created

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

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

RE: Slicing Tuples

I don't work with Python and so took a guess. It could only work one of two ways and I chose the wrong one. 😀

--Jeff Moden

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:17 am

#2018408

RE: Renaming a primary key columns in the Azure DB

ashkan sirous - Wednesday, January 9, 2019 4:59 AM

allinadazework - Tuesday, January 8, 2019 8:09 AM

--Jeff Moden

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:09 am

#2018406

RE: Database in RECOVERY PENDING state - Access Denied

I've see it quite often. I think it most likely that the SQL Server Service tried to come up before the drive connections were up.

If you go to...

--Jeff Moden

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 8, 2019 at 10:02 pm

#2018373

RE: Select convert to 2 decimal places, comma, right aligned

chad 62627 - Tuesday, January 8, 2019 2:02 PM

Jeff Moden - Thursday, January 3, 2019 10:07 PM

--Jeff Moden

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 8, 2019 at 6:45 pm

#2018370

RE: Are the posted questions getting worse?

WayneS - Tuesday, January 8, 2019 8:17 AM
Has "The Thread" died? I haven't seen anything new in too long now.

Heh... it'll be...

--Jeff Moden

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 8, 2019 at 8:37 am

#2018302

RE: Renaming a primary key columns in the Azure DB

I have to ask.... just what is the supposed technical difficulty on the web server side that they're having with column names? It's important because it will dictate your path. ...

--Jeff Moden

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 8, 2019 at 8:29 am

#2018300

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

It's probably the same thing we went through. There's a different cardinality estimator that came into play in 2014 (IIRC). There's also a Trace Flag you can set to continue...

--Jeff Moden

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 8, 2019 at 8:10 am

#2018295