Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,746 through 26,760 (of 59,099 total)

RE: Loading XML Data into SQL Server (SQL Spackle)

dg81328 (5/31/2013)
even though u successfully loaded the raw xml into a table you still processed the data one row at a time. It is much better to use OPENXML and...
--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)

June 1, 2013 at 6:49 am

#1620276
RE: Are the posted questions getting worse?

I guess I'm paranoid about any leading index column that has very low selectivity. As most folks know, while they can really help with SELECTs, they're absolutely horrible 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)

June 1, 2013 at 6:16 am

#1620274
RE: Are the posted questions getting worse?

Grant Fritchey (5/31/2013)
Jack Corbett (5/31/2013)
Jack Corbett (5/31/2013)
Have I mentioned these 2 things lately:
1. I can't stand ORM tools and the queries they create
2. I...
--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)

May 31, 2013 at 4:22 pm

#1620244
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

SQL_Enthusiast (5/31/2013)
For some unknown reason, the creator of this file set the naming convention to something I can't begin to fathom... :unsure:
The file name is like this: NAME1_NAME2_NAME3_NAME4_NAME5_YYYYMMDD_YYYYMMDDHRMMSS.YYYYMMDDHRMMSS -- Yes,...
--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)

May 31, 2013 at 4:01 pm

#1620239
RE: Database Documention Tool

There are NO tools that I know of that do database "documentation" correctly unless you've taken the time to document the database correctly (extended properties) to begin with. I...
--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)

May 31, 2013 at 3:33 pm

#1620237
RE: SSIS - What is the best practice for creating a fixed length flat file.

Sigerson (5/31/2013)
Of course, bcp is the better choice just to spit out a lot of rows into a text file, but I don't think it can do a fixed-length file....
--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)

May 31, 2013 at 3:08 pm

#1620234
RE: Create a Leveling of Intermediaries

There might be some confusion of terms here. Are you saying that if a give IntermediaryID (I'm assuming that's the top level of the hierarchy here) has no children,...
--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)

May 31, 2013 at 8:05 am

#1620093
RE: Create a Leveling of Intermediaries

manoj.ramaiah (5/30/2013)
Hi,
I have a table called Intermediary, which have some columns like
CREATE TABLE Intermediary
(
IntermediaryPK INT ,
IntermediaryID NVARCHAR(20),
IntermediaryName NVARCHAR(200),
IntermediaryTypeID NVARCHAR(1),
ParentIntermediaryID NVARCHAR(20),
IntermediaryTypePK TINYINT,
LevelID TINYINT,
ParentIntermediaryPK INT,
GrandParentIntermediaryPK INT,
GrandParentIntermediaryID NVARCHAR(20)
)
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)

May 31, 2013 at 7:29 am

#1620067
RE: Can this be sorted without temporary tables

I guess the next question would be, why did you put leaders and followers in separate tables? It's a lot easier to manage such things if they're all 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)

May 31, 2013 at 7:18 am

#1620058
RE: Help with next date in SQL query

Tyekhan (5/30/2013)
Yes the num column is unique, but the best thing to use would be ID as the same records would have the same ID.
Jeff Moden (5/30/2013)
So, any feedback on...
--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)

May 30, 2013 at 10:44 am

#1619789
RE: Help with next date in SQL query

So, any feedback on my previous comment of...
Like I said, if the "Num" column is the wrong thing to consider to be unique, then we'll have to change a couple...
--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)

May 30, 2013 at 7:33 am

#1619704
RE: Convert integer to 4-character alphnumeric representation

rburko (5/29/2013)
Okay, the need for all this is:
A process inserts a parent row, then takes the identity value and puts it as the first 4 characters as part of 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)

May 30, 2013 at 6:58 am

#1619690
RE: Convert integer to 4-character alphnumeric representation

rburko (5/29/2013)
Jeff, I work with what I'm given. And I've probably covered all the possible swear words just thinking of the best way to handle what I'm given.
Heh... that's...
--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)

May 30, 2013 at 6:48 am

#1619682
RE: Sum Time

lanky_doodle (5/29/2013)
Thanks guys.
That's given me the starting point I need.
You have to be a little bit careful when it come to performance on such things, meaning that you should severely...
--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)

May 29, 2013 at 4:12 pm

#1619517
RE: What is Functional DBA?

A "Functional DBA" is one that simply hasn't had too much of his own beer to drink. 😛
--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)

May 29, 2013 at 12:07 pm

#1619445

Viewing 15 posts - 26,746 through 26,760 (of 59,099 total)