Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,456 through 10,470 (of 59,099 total)

RE: Remove non alpha chars from a column

Shifting gears a bit,.. Lordy, I miss Dwain. :unsure:
--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)

December 3, 2018 at 8:53 pm

#2015392
RE: Remove non alpha chars from a column

Heh... here I go ago... necro'ing the same wicked old post.
@DonlSimpson ... Try the following and see why I prefer not 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)

December 3, 2018 at 8:49 pm

#2015391
RE: Need index suggestion

Still looking for why anyone would find the sorting to be useful considering the output and the fact that there's noting to preserve that order if used elsewhere.
--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)

December 3, 2018 at 8:41 am

#2015329
RE: How to split comma separated values stored in XML node Without using function- SQL Server 2012

Patchai001 - Monday, December 3, 2018 8:26 AM
This was the requirement from client not to use function as this query will be...
--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)

December 3, 2018 at 8:39 am

#2015328
RE: Missing Indexes

Kendra.Little - Monday, December 3, 2018 7:58 AM
Jeff Moden - Monday, December 3, 2018 7:51 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)

December 3, 2018 at 8:03 am

#2015318
RE: always on in cloud amazon

abdalah.mehdoini - Monday, December 3, 2018 7:44 AM
Hello everyone
I must migrate an always on instance to the AWS azure cloud
the configuration 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)

December 3, 2018 at 7:58 am

#2015317
RE: Missing Indexes

While I absolutely agree with what has been stated in the explanation, the question was (emphasis is mine)...
How many missing index requests are in the execution plan...
--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)

December 3, 2018 at 7:51 am

#2015314
RE: Understanding a Database

roger.plowman - Monday, December 3, 2018 6:49 AM
Jeff Moden - Monday, December 3, 2018 6:27 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)

December 3, 2018 at 7:37 am

#2015311
RE: Update Row for same ID

Hold the phone a minute... why do you have two tables that you must maintain the name in? That's not "normalization" and having to do such maintenance is contrary 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)

December 3, 2018 at 7:32 am

#2015310
RE: CONTAINS() function generates crash dump file

SALIM ALI - Monday, December 3, 2018 6:01 AM
Found the issue and fixed it.
It was a corrupt ResourceDB database. It's not one...
--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)

December 3, 2018 at 7:28 am

#2015307
RE: Traverse hierarchy with a tally table

s.duvernay 71743 - Monday, December 3, 2018 6:27 AM
Hi Jeff,
I read both article but I' have probably miss something...
The point of the...
--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)

December 3, 2018 at 7:26 am

#2015301
RE: Understanding a Database

Just remember that "all relationships" are normally based on the presence of FKs. A whole lot of 3rd party vendors don't even know how to spell "FK". I've not worked...
--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)

December 3, 2018 at 6:27 am

#2015294
RE: Traverse hierarchy with a tally table

Please see the following articles.
Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
Hierarchies on Steroids #2: A Replacement for...
--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)

December 3, 2018 at 6:19 am

#2015292
RE: adding each row incremental

I don't have access to a 2016 box just now but I believe this can be done using Lead or Lag. I believe that Books Online has an example.
--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)

December 3, 2018 at 6:06 am

#2015290
RE: CONTAINS() function generates crash dump file

SALIM ALI - Monday, December 3, 2018 3:46 AM
Hi,
I'm seeing lots of crash dump files generated (SQL Server 2012) due to 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)

December 3, 2018 at 5:57 am

#2015288

Viewing 15 posts - 10,456 through 10,470 (of 59,099 total)