Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,596 through 53,610 (of 59,098 total)

RE: BCP Stored Procedure

peterhe (12/14/2007)
if the file exists, bcp jsut overwrites it. So you don't need to delete it
Not when you use ">>" for redirection to the log file...
Of course, if the OP...
--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)

December 14, 2007 at 5:00 pm

#760481
RE: Columns to store different data types

Querying the data then showing rows as columns being the main reason.
But, that's so easy. Heh, guess ya gotta do what ya gotta do.
SQL_Variant will take just about...
--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)

December 14, 2007 at 8:22 am

#760279
RE: Hidden RBAR: Triangular Joins

Hi Madhivinan!
Long time no "see" and good to see you... and Thanks for the compliment.
Yeah... I'm responsible for the RBAR thing... publicly introduced it way back in the following...
http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
... but...
--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)

December 14, 2007 at 8:18 am

#760274
RE: Formatting Numerical Data Columns: (##,###)

And, thanks for the feedback!
--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)

December 14, 2007 at 8:12 am

#760268
RE: automating converting normalized data to single table format

First, please take a look at the following to see how to get better answers quicker...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
With that in mind, here's the test tables and data I used... (scroll bars are...
--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)

December 14, 2007 at 7:02 am

#760222
RE: how to get row value displayed column-wise instead of row-wise in sql server

Please don't double post... we'll get to you...
http://www.sqlservercentral.com/Forums/Topic433241-338-1.aspx
--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)

December 14, 2007 at 6:03 am

#760188
RE: how to get row value displayed column-wise instead of row-wise in sql server

Lookup "Cross-tab" and "Pivot" in Books Online... both methods have their uses 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)

December 14, 2007 at 6:02 am

#760187
RE: SELECT INTO

I think David recommends his method because SELECT/INTO will temporarily lock SysObjects while the data is transferring...
However, I prefer the SELECT/INTO method for two reasons...
1. If you 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)

December 14, 2007 at 5:57 am

#760179
RE: Zip around 1000 Db's having each 10 Gb size

C'mon folks... WinZip Pro costs what, 60$??? Don't screw around with your archive data... do it right. You probably spend more than $60 a month buying coffee, softdrinks, and/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)

December 14, 2007 at 5:47 am

#760171
RE: table datatype vs temporary table

i'm going to copy and manupulates lakhs(appx.) of records
Oh, yeah... almost forgot... if you're going to do something to "lakhs of records", then forgot about the table variables... they do...
--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)

December 14, 2007 at 5:43 am

#760168
RE: table datatype vs temporary table

I just got 2k5 so I haven't done any performance testing (yet) to compare the two... and, I'll probably get all sorts of flack for this... but based on 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)

December 14, 2007 at 5:38 am

#760165
RE: Formatting Numerical Data Columns: (##,###)

Replace the 1234567890 with your INT column or formula. Could turn this into a function. Note that it's generally a bad idea to do this type of formatting...
--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)

December 13, 2007 at 10:23 pm

#760076
RE: SQL 2005 reading file attributes

Oh, crud... you're right... I just loaded 2k5 over the weekend and verified what you say to be true... it's not in 2k5... reportedly it was and I took someone'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)

December 13, 2007 at 5:35 pm

#760058
RE: Client people expectation

It will be a valuable experience... perhaps not the way most think, but valuable nevertheless.
--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)

December 13, 2007 at 4:18 pm

#760047
RE: UK JOB & US JOB

And then, anyone who is touting the label of "Senior Software Engineer" needs to be able to do some pretty complex stuff right off the top of your head (like...
--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)

December 13, 2007 at 4:13 pm

#760044

Viewing 15 posts - 53,596 through 53,610 (of 59,098 total)