Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,586 through 48,600 (of 59,095 total)

RE: Pivot Transformation

Use UnPivot.
--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)

August 26, 2008 at 7:29 pm

#863471
RE: Converting integer to time

Haven't done a performance comparison, but I wouldn't be surprised if your all math solution were faster than just about any string solution including the one I posted.
--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)

August 26, 2008 at 6:39 pm

#863465
RE: SQL Bulk Insert - using " to wrap text fields

Instead of using EXEC... use PRINT(@Query) and post the result, please.
--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)

August 26, 2008 at 6:36 pm

#863463
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks for the code and the write up... it's exactly what I was afraid of though. In your example just for layer #1, if you have a million rows...
--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)

August 26, 2008 at 6:33 pm

#863462
RE: data archiving

gan (8/26/2008)
Jeff Moden (8/25/2008)
If the clustered key is set by date or, perhaps, identity and the identity column is indicative of entry order, then sectional deletes (or insert to archive,...
--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)

August 26, 2008 at 6:21 pm

#863459
RE: Rename a text file, move it, using a stored procedure

MrBaseball34 (8/26/2008)
Kind of wondering how you would catch any errors when moving the file.
I make a copy to a tempfilename passed into the procedure and then if there is 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)

August 26, 2008 at 6:09 pm

#863457
RE: numeric sort of a varchar field

All those are well and good, but the OP still hasn't provided an answer to the question of which numeric field (or both) to sort on for some of 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)

August 26, 2008 at 6:04 pm

#863456
RE: Need help in a query - Accessing and modifying previous row data

sg (8/26/2008)
Hi Amit Khanna,
Thanks for ur reply. I am an asp.net developer, not a dba :rolleyes: but still i have a good knowledge on db.
I have used joins 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)

August 26, 2008 at 6:01 pm

#863455
RE: How to replace a text

Sorry... new job has kept me busy... I think I may have a solution soon. Yep, I know you already have one using REPLACE on the quotes... there's just...
--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)

August 26, 2008 at 5:56 pm

#863453
RE: MIS in the UK

developer6 (8/26/2008)
Jeff: I can only assume that you are not resident in the UK. If being stupid was in any way a prevention for getting old the population...
--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)

August 26, 2008 at 5:50 pm

#863450
RE: Resort Columns Low-to-High

swtrans (8/19/2008)
I have a table with data in 4 columns.
C1 C2 C3 C4
110 99...
--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)

August 26, 2008 at 12:47 pm

#863330
RE: Documenting a Database

Start with using Visio to reverse engineer a diagram of the database... hopefully, they actually used Foreign Keys...
--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)

August 26, 2008 at 12:42 pm

#863325
RE: Data File Growth

Hi Jim,
Indexes also count towards the size of the mdf. If you have wide indexes and a clustered index along with "fk" indexes, the size of your indexes can...
--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)

August 26, 2008 at 12:39 pm

#863323
RE: SQL 2000 Concatenate text fields within a view

Even if you concatenate and convert to text using something like...
[font="Courier New"]SELECT CAST('1'+'2'+'3' AS TEXT)[/font]
...you still won't be able to see more than 8192 characters in a single column, view...
--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)

August 26, 2008 at 9:53 am

#863241
RE: Handling The Text Data Type

Robert...
I know it's been over a year since this article came out, but want to say what an outstanding article you've written... very easy to read and great examples!...
--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)

August 26, 2008 at 9:42 am

#863232

Viewing 15 posts - 48,586 through 48,600 (of 59,095 total)