Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,416 through 41,430 (of 59,102 total)

RE: The Value of Experience

I'm going to take the opposite stance from a lot of other folks. Sure, I believe that you have to know other "stuff" to be a good DBA or...
--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 23, 2009 at 12:05 am

#1069812
RE: Populate rows with column values, but not a pivot!

It's easy and I found Ginger...
See the first link in my signature below to provide a CREATE TABLE statement and some sample data so we can show you how.
--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 22, 2009 at 11:57 pm

#1069807
RE: Need to pull mulitple row communication infor into single row per customer

BWAA-HAA!!! What downside? Just think of it... you store everything in one table and you only need one index. Simplicity at it's best. :-P:-D;-)
(For those not familiar...
--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 22, 2009 at 11:53 pm

#1069804
RE: String functions

Loops are slow... break the habit of using them. 😉
SELECT TOP 10 RIGHT('000'+CAST(ROW_NUMBER() OVER (ORDER BY (SELECT 1))-1 AS VARCHAR(3)),3)
FROM Master.sys.All_Columns
--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 22, 2009 at 11:48 pm

#1069803
RE: Pull or Push the Data

You may want to look into a thing called "Replication".
--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 22, 2009 at 11:38 pm

#1069799
RE: Summing differences between time stamps

I've seen this exact same problem a couple of times over the years... and it was homework for a course. Please show what you've tried and if you still...
--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 22, 2009 at 11:35 pm

#1069797
RE: help on query

Ashok Nalam (10/22/2009)
So it has basically start from ( based on configuration by customer specific) to end time then start time onwards.
It depends... where is the "configuration by customer specific"...
--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 22, 2009 at 11:26 pm

#1069795
RE: BCP Command with Parameters

You can't use BCP with parameters unless you turn it into dynamic SQL.
--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 22, 2009 at 11:22 pm

#1069792
RE: split a long string column into separate columns

Thanks for the kudo, Lowell.
--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 22, 2009 at 11:09 pm

#1069788
RE: Script all data of a table

I missed this before, Flo... it's written well enough that it probably should have been an article. Well done.
--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 22, 2009 at 10:48 pm

#1069785
RE: Using synonyms to redirect queries

Heh... "It Depends".
It all depends on how you load the data (ie: IDENTITY_INSERT) and whether or not an IDENTITY column is even needed. I don't see an IDENTITY column...
--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 22, 2009 at 10:43 pm

#1069783
RE: query for random data but grouped

Sorry... I just haven't gotten to this one, yet. Do you still need help on it?
--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 22, 2009 at 10:18 pm

#1069777
RE: Are the posted questions getting worse?

Steve Jones - Editor (10/22/2009)
Actually, I think in OODBMS or HDBMS, we'd get worse design. Harder to understand. My point is that RDBMS is the easiest (relative) of the 3....
--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 22, 2009 at 10:16 pm

#1069776
RE: TSQL Question about getting data

All right, Brad... I looked at all of this and, although I return what you wanted, I got carried away. If it were me and I saw some 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)

October 22, 2009 at 10:05 pm

#1069774
RE: TSQL Question about getting data

Steve Jones - Editor (10/16/2009)
You wouldn't use a variable, and you wouldn't go through each row.
If I understand, what you likely want to do is use a CASE statement 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)

October 22, 2009 at 9:57 pm

#1069772

Viewing 15 posts - 41,416 through 41,430 (of 59,102 total)