Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,456 through 31,470 (of 59,101 total)

RE: String splitter to table weird result

Digs (5/2/2010)
.."As we've seen on dozens of posts, an XML splitter would not have performed so well."..
Jeff you have seen the yahoo .csv link I posted in this thread.
I too...
--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, 2012 at 4:49 pm

#1430249
RE: merge statement and cte(common table expression)

David Moutray (12/25/2011)
:blush: It's one of those things I keep telling myself I should do.
I'll make it a New Year's resolution. 🙂
So! How's that New Year's resolution coming?...
--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, 2012 at 4:35 pm

#1430248
RE: Script component

sqlfriends (1/6/2012)
well, the script is to update a column A based on a column B in the same table.
If column B value is null, then use A will be concatenate...
--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, 2012 at 4:16 pm

#1430241
RE: Microsoft Gold Certified Partner Companies - Horror Stories

Do you have a convenient link for the "recent changes"?
And I'm biased, too! Any "Gold" partner that has Gail Shaw working for them has got to be one of...
--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, 2012 at 3:38 pm

#1430234
RE: Global temp tables are not created through SQL TASK control.....

Admittedly, I'm no SSIS expert but I believe that the SQL Task is being executed as a separate session. When the SQL Task exits, it ends the session which...
--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, 2012 at 3:22 pm

#1430232
RE: Extracting and parsing XML from fields (CRM related)

My pleasure. It's an honor that you're carrying some of my articles as a link in your signature. Thanks, Lutz.
--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, 2012 at 3:15 pm

#1430230
RE: Microsoft Gold Certified Partner Companies - Horror Stories

PhilipC (1/7/2012)
Came across one of the worst vendor related databases a few weeks ago where a business department just went ahead and purchased the software and rail-roaded IT into implementing...
--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, 2012 at 3:12 pm

#1430229
RE: Log File writing algorithm

To add to what Gail has already identified, it's an INSERT. That means that any and all indexes for the table will also be logged and updated.
--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, 2012 at 3:01 pm

#1430228
RE: Update Large Table

ChrisM@home (1/8/2012)
Dbloc (1/6/2012)
...After the update is done I then Insert these specific rows in to another table.
Why not do this in one step? Select the rows you want from 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)

January 8, 2012 at 2:54 pm

#1430226
RE: Denali needs Windows 6.0 minimum

Arun Jebakumar (1/8/2012)
Denali is going to be SQL Server 2012 🙂
Considering the required operating system change, it might as well be SQL SERVER 2020 for me. I'm not sure...
--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, 2012 at 2:49 pm

#1430225
RE: Extracting and parsing XML from fields (CRM related)

LutzM (1/7/2012)
You'll need the DelimitedSplit8K function to split the data. If you don't have it in your tool box already, search this site for it (originally posted by Jeff Moden).
Lutz,
Thank...
--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, 2012 at 2:46 pm

#1430224
RE: Database design

CELKO (1/8/2012)
There is no such thing as a magical, generic, universal "id" to mimic a pre-RDBMS pointer chains.
Actually, there is. See the movie as to why it should...
--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, 2012 at 1:56 pm

#1430215
RE: Understanding and Using APPLY (Part 1)

SQL Kiwi (1/7/2012)
Jeff Moden (1/6/2012)
Would you mind posting your split function so I can take a look, please?
Can I ask that you guys start a new thread for 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 8, 2012 at 1:15 pm

#1430212
RE: Are the posted questions getting worse?

SQL Kiwi (1/8/2012)
Is it just me, or is SQL code prettifying (specifically colours) broken on the site at the moment?
I've been getting the same thing and reported it the 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)

January 8, 2012 at 1:06 pm

#1430208
RE: HHMMSS int field to human-friendly time?

As a sidebar, it looks like they've really messed up the colorization on the code windows again. I sent an email to the SSC webmaster and have gotten no...
--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, 2012 at 10:56 am

#1430201

Viewing 15 posts - 31,456 through 31,470 (of 59,101 total)