Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,896 through 26,910 (of 59,101 total)

RE: Converting particular set of Rows as Columns

gadde (5/1/2013)
Converting one row as one Column is possible using Pivot. But is there any way to convert particular set of rows to one column?
For example, below is the data...
--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 1, 2013 at 10:19 pm

#1611776
RE: Help with sql statement to delete old records for user if multiple records found

I guess the original sin here is that some valuable statistical information has been deleted forever. I would never delete such data until I had squirreled it away somewhere....
--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 1, 2013 at 5:50 pm

#1611755
RE: Retrieve data and log file names from SQL database

I guess I'd have to ask why the 3rd party product doesn't already do this "auto-magically".
--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 1, 2013 at 5:43 pm

#1611753
RE: Extract Speed from DB2

Ross McMicken (5/1/2013)
Jeff, you should also check to see if the AS400 you need to extract from has any third party query tools on it, or Query/400. Those generally have...
--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 1, 2013 at 5:24 pm

#1611752
RE: If you're confident about a change in your DB, triple check

Thank you for sharing the experience. I'm concerned that you have databases set to TRUSTWORTHY ON, though... especially since they're public facing.
--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 1, 2013 at 4:29 pm

#1611751
RE: Need help in transfering 400 million from SQL Server to SQL Server

I'd probably not use any of those methods especially if it's a one off task. I'd most likely do a native BCP out on the source and a native...
--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 1, 2013 at 4:01 pm

#1611743
RE: Extract Speed from DB2

Ross McMicken (5/1/2013)
Jeff Moden (4/29/2013)
I guess I'll ask a similar question on these thread. Is there any way to bulk export data from DB2 to a Tab delimited 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 1, 2013 at 3:54 pm

#1611741
RE: Are the posted questions getting worse?

L' Eomot Inversé (4/30/2013)
Anyway, I'm at a loss to think of a good role to assign to DBAs in the worlds of science fiction and fantasy. Of course that...
--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)

April 30, 2013 at 3:05 pm

#1611418
RE: Most important DBA Skill?

TravisDBA (4/30/2013)
Jim Youmans-439383 (4/30/2013)
Part of the daily grind for a DBA, in my experience, is dealing with frustrated people. You have to have excellent technical skills to find 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)

April 30, 2013 at 2:58 pm

#1611413
RE: huge log file

There are a few more things other than just size to consider about the log file. I've been through this with every new company that I've worked for (quarter...
--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)

April 30, 2013 at 12:11 am

#1611121
RE: Most important DBA Skill?

To summarize what you said and to paraphrase what Mr. David Poole once said....
If you're the first person people seek for help rather than the last, you might be an...
--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)

April 30, 2013 at 12:02 am

#1611118
RE: Cannot shrink log

tshad (4/25/2013)
My Transaction log is about 3GB and I can't shrink it.
It is using a FULL backup and I try over and over again to back and shrink it 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)

April 29, 2013 at 11:42 pm

#1611107
RE: Index maintenance increase log size

S_Kumar_S (4/29/2013)
There is only one clustered index on table, no NONClustered indexes are there.
Lynn Pettis (4/29/2013)
S_Kumar_S (4/29/2013)
One question to all:
If I have data like this, where there is only 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)

April 29, 2013 at 7:43 pm

#1611074
RE: Split a range of numbers in equal parts

Lynn Pettis (4/29/2013)
Now, if we could just get people to use the semicolon statement terminitor correctly instead of using it as a begininator at the start of a CTE definition....
--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)

April 29, 2013 at 7:25 pm

#1611073
RE: Reporting in records in the right order

[Edit] Sorry, misread the original problem so withdrew my comment. Not yet sure with how to resolve the "fork in the road". Reminds me of "Yogi". ...
--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)

April 29, 2013 at 6:41 pm

#1611062

Viewing 15 posts - 26,896 through 26,910 (of 59,101 total)