Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,066 through 16,080 (of 59,101 total)

RE: SQL 2012: how to parse a text datatype column into many different columns

elulu (12/24/2016)
You spoke my heart out!
And yet, there's no action you're going to take against it, eh?
--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 24, 2016 at 10:15 pm

#1919604
RE: Today's Random Word!

TomThomson (12/24/2016)
whereisSQL? (12/23/2016)
DamianC (12/23/2016)
Manic Star (12/23/2016)
Revenant (12/23/2016)
djj (12/23/2016)
Ed Wagner (12/23/2016)
Grumpy DBA (12/23/2016)
Ed Wagner (12/23/2016)
Whisperer
Dog
Bark
Tree
Life
Circle
pi
Geometry
Euclid
Lucid
--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 24, 2016 at 9:01 pm

#1919601
RE: Help with XML Splitter De-entitization, please.

@Mikael,
Perhaps I'm doing something wrong but the mTVF version doesn't return elements that result in empty strings..
[font="Arial Black"]Setup:[/font]
--===== Conditionally drop the test table to make reruns easier.
...
--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 24, 2016 at 6:30 pm

#1919600
RE: How to improve performance, when using LIKE (or any other alternative?)

BOR15K (12/5/2016)
Thank you. Yet I will need to seek a permission from DBA's to add a new column across all the environments.
Write a script to do it and submit 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 24, 2016 at 5:11 pm

#1919599
RE: Parsing paired relationships.

Jason A. Long (12/23/2016)
@jeff - It looks to be the result of some sort of matching process, where A was matched to B and B was matched to A... Resulting...
--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 23, 2016 at 8:18 pm

#1919573
RE: Parsing paired relationships.

Hmmm... looking at the original small list of nodes in the original post, there might just be a way to Ferret out the root nodes. I'll give that a...
--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 23, 2016 at 5:59 pm

#1919571
RE: Parsing paired relationships.

Jason A. Long (12/23/2016)
@jeff - It looks to be the result of some sort of matching process, where A was matched to B and B was matched to A... Resulting...
--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 23, 2016 at 5:31 pm

#1919570
RE: Parsing paired relationships.

@richard-2.gardner,
I'm still playing with the data but let me make a suggestion.
The data you currently have is the result of someone creating the "opposite direction" node for every node in...
--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 23, 2016 at 1:16 pm

#1919559
RE: How to troubleshoot sudden drop in Page Life Expectancy?

SQL Guy 1 (12/23/2016)
Jeff Moden (12/22/2016)
but the only time I truly concern myself with a vertical drop with PLE is if it drops and stays there for an uncomfortable...
--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 23, 2016 at 1:10 pm

#1919558
RE: How to troubleshoot sudden drop in Page Life Expectancy?

SQL Guy 1 (12/22/2016)
I would agree if that was a small drop, for example from 3000 to 2000 sec. But a drop from 3000 to 100 sec I understand...
--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 22, 2016 at 6:08 pm

#1919458
RE: Bulk Insert vs. BCP Utility

smatu (12/22/2016)
What is the difference between Bulk Insert and BCP.
Which will be most effective in importing a bulk of data from flat file into sql server database?
Do both exist...
--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 22, 2016 at 5:45 pm

#1919457
RE: Help with delimited SQL

Phil Parkin (12/22/2016)
nadersam (12/22/2016)
Hi Guys,
I am trying to execute an array of comma delimited SQLs in a stored procedure.
I call it as below
declare @Parameter as nvarchar(max)
set @Parameter ='insert into...
--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 22, 2016 at 4:26 pm

#1919452
RE: BIGINT TO INT - CAN i DO IT?

Just curious... which language is the frontend code written in?
--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 22, 2016 at 4:22 pm

#1919451
RE: How to troubleshoot sudden drop in Page Life Expectancy?

I'll suggest that it's almost a waste of time. It's certainly an indication that something wasn't in memory when it was needed but that's not necessarily a problem especially...
--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 22, 2016 at 3:32 pm

#1919443
RE: Today's Random Word!

Ed Wagner (12/22/2016)
Manic Star (12/22/2016)
djj (12/22/2016)
aPed001 (12/22/2016)
Stuart Davies (12/22/2016)
DamianC (12/22/2016)
Ed Wagner (12/20/2016)
Manic Star (12/20/2016)
Grumpy DBA (12/20/2016)
ZZartin (12/20/2016)
Ed Wagner (12/20/2016)
Revenant (12/20/2016)
djj (12/20/2016)
Ed Wagner (12/20/2016)
Hugo Kornelis (12/20/2016)
Manic Star (12/20/2016)
Power
People
Users
Administrator
Access
Permissions
word
Excel
Mediocre
Accepted
part
Exchange
Stock
Pot
Chicken (not Dino)
Fried
Brain
--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 22, 2016 at 3:29 pm

#1919442

Viewing 15 posts - 16,066 through 16,080 (of 59,101 total)