Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,111 through 10,125 (of 59,099 total)

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

#2018295
RE: Date Field Calculation Logic

Just a heads up... I "talked" with the author of this problem and have confirmed the intent. pietlinden was almost on the money...
--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 7, 2019 at 10:10 pm

#2018248
RE: Translate Sql Query to Clr

Solomon Rutzky - Monday, January 7, 2019 8:08 PM
meryemkurs072 - Monday, January 7, 2019 12:25 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 7, 2019 at 9:57 pm

#2018247
RE: Date Field Calculation Logic

lazerathSQL - Monday, January 7, 2019 1:48 PM
Hello all!
I am the author to this question/challenge. This is good discussion and I appreciate...
--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 7, 2019 at 7:20 pm

#2018242
RE: Does Stored Proc Complete if Machine Rebooted?

tinausa - Monday, January 7, 2019 3:39 PM
Thanks Eirikur, the machine that is rebooting is...
--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 7, 2019 at 7:06 pm

#2018241
RE: Insert Faster way

p.s. You can also keep the IDENTITY column without a sort by loading up an identical staging table that has no IDENTITY column and then SWITCH it into the table...
--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 7, 2019 at 12:14 pm

#2018209
RE: Translate Sql Query to Clr

meryemkurs072 - Monday, January 7, 2019 11:49 AM
Thank you Jeff, Solomon
Are there other solutions for query encryption?
Nothing that a good DBA can'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)

January 7, 2019 at 12:11 pm

#2018208
RE: Insert Faster way

RGP - Monday, January 7, 2019 10:21 AM
Jonathan AC Roberts - Monday, January 7, 2019 9:47 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 7, 2019 at 11:44 am

#2018204
RE: Determining uncompressed size when removing Row level table compression

phil.martin 65477 - Monday, January 7, 2019 8:09 AM
The table in question has 30million rows and is almost 500GB in size (compressed)....
--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 7, 2019 at 11:39 am

#2018202
RE: Rebuild index taking time

RGP - Monday, January 7, 2019 11:11 AM
Jeff Moden - Thursday, December 20, 2018 10: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)

January 7, 2019 at 11:31 am

#2018199

RE: How to select the last record added to a table

BrainDonor - Monday, January 7, 2019 7:53 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 7, 2019 at 7:41 am

#2018165