Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,981 through 10,995 (of 59,095 total)

RE: Init-cap the characters in SQL server

Lynn Pettis - Wednesday, October 10, 2018 2:01 PM
And if your server or database is using a case sensitive collation?
Run like...
--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)

October 11, 2018 at 9:17 pm

#2009273
RE: Are the posted questions getting worse?

Shifting gears back to the SSMS 17 vs old SSIS problems... I learned my lesson way back in SS 2000 when it was DTS. I developed methods to do most...
--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)

October 11, 2018 at 8:31 am

#2009139
RE: Are the posted questions getting worse?

jasona.work - Thursday, October 11, 2018 8:06 AM
But it keeps showing up in Unread posts, TAUNTING us!
(I've unsubscribed already.)
It's like an itch...
--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)

October 11, 2018 at 8:24 am

#2009133
RE: What are some really dumb things you could write in a SQL Query

drew.allen - Thursday, October 11, 2018 7:49 AM
Hugo Kornelis - Thursday, October 11, 2018 7:16 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)

October 11, 2018 at 8:09 am

#2009126
RE: Are the posted questions getting worse?

Brandie Tarvin - Thursday, October 11, 2018 5:19 AM
Steve, there's no good way to add comments to Report Post anymore. Can you...
--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)

October 11, 2018 at 8:02 am

#2009121
RE: Are Indexes Actually Changes to the System?

Ah crud. Somehow, I left out a couple of sections above and forgot to attach the index DNA proc and spreadsheet (now attached).
First, here's what "Low Threshold Rebuilds" do to...
--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)

October 10, 2018 at 11:58 pm

#2008991
RE: Are Indexes Actually Changes to the System?

First, here’s a flowchart of the code that ran each test in each of the following charts. What’s NOT shown...
--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)

October 10, 2018 at 10:49 pm

#2008987
RE: Are Indexes Actually Changes to the System?

Paul Randal - Wednesday, October 10, 2018 6:20 PM
But above you say "REORGANIZE (NEVER USE REORGANIZE!!!! IT DOESN'T WORK THE WAY...
--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)

October 10, 2018 at 8:58 pm

#2008983
RE: Are Indexes Actually Changes to the System?

The forum software keeps messing me up. I'll have to type this up all at once and paste it. I'm working on the response. Sorry for the delay.
--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)

October 10, 2018 at 7:54 pm

#2008981
RE: Are Indexes Actually Changes to the System?

Paul Randal - Wednesday, October 10, 2018 5:40 PM
And btw, reorganize doesn't cause page splits. Random inserts (or row expansions) cause page...
--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)

October 10, 2018 at 5:52 pm

#2008978
RE: What are some really dumb things you could write in a SQL Query

Just in case you didn't see it, they took it down from the MS site it was previously posted on. Someone also took the copy down from YouTube. However, they...
--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)

October 10, 2018 at 5:31 pm

#2008974
RE: What are some really dumb things you could write in a SQL Query

ScottPletcher - Wednesday, October 10, 2018 4:16 PM
Jeff Moden - Wednesday, October 10, 2018 3: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)

October 10, 2018 at 5:07 pm

#2008972
RE: Are Indexes Actually Changes to the System?

Paul Randal - Wednesday, October 10, 2018 2:42 PM
Correct. Reorg (and anything else) can't move rows to the right in the index...
--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)

October 10, 2018 at 4:36 pm

#2008970
RE: Are Indexes Actually Changes to the System?

Paul Randal - Wednesday, October 10, 2018 10:30 AM
Jeff - can you explain this comment you made please: "NEVER USE REORGANIZE!!!!...
--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)

October 10, 2018 at 4:34 pm

#2008969
RE: What are some really dumb things you could write in a SQL Query

ZZartin - Wednesday, October 10, 2018 2:17 PM
SELECT * in a deployed production job
A very strong code smell, indeed, but as with...
--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)

October 10, 2018 at 3:54 pm

#2008965

Viewing 15 posts - 10,981 through 10,995 (of 59,095 total)