Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,476 through 44,490 (of 59,097 total)

RE: Books OnLine?

Betim Drenica (3/23/2009)
Hi guys,
Thanks a lot for your posts!
First I am not SQL Server newbie, and 2nd I am asking in the kind of poll!
Thanks!
Heh... you should have stated 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)

March 23, 2009 at 4:29 pm

#964862
RE: Which country is best for Outsourcing?

karthikeyan (3/23/2009)
All,
Which country is best for outsourcing? I believe i will get some interesting answers.
Why do you want to know?
--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)

March 23, 2009 at 4:13 pm

#964855
RE: Are the posted questions getting worse?

RBarryYoung (3/23/2009)
Steve Jones - Editor (3/23/2009)
Thanks :blush:
good to meet you as well and glad you liked the presentation.
So what's Lynn really like in person? Can you actually see 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)

March 23, 2009 at 2:37 pm

#964787
RE: How to import data from text file into SQL

halifaxdal (3/23/2009)
Jeff Moden (3/20/2009)
halifaxdal (3/20/2009)
Thank you all for the reply, like I mentioned earlier, the problem has almost been resolved except: how to ignore the last line in the source...
--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)

March 23, 2009 at 2:29 pm

#964779
RE: Hex to Decmial Conversion

Grady Christie (3/20/2009)
That works perfectly!
Many Thanks, Grady Christie
Grady,
How did you manage to prepend the "0x" to your columns to get this to work correctly?
--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)

March 23, 2009 at 2:12 pm

#964759
RE: Shrinking Database file

SUBRAHMANYA HEDGE (3/23/2009)
If your database is not configured for Replication or Logshipping you can use following command to shrink your databse log file to death:
backup log with truncate_only...
--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)

March 23, 2009 at 6:11 am

#964341
RE: Just testing the new code window... please disregard

RBAR? How so?
--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)

March 23, 2009 at 5:46 am

#964329
RE: T-Sql rant

Carlton Leach (3/22/2009)
"Cursors are only useful for people who don't know how to write SQL"
Heh... Amen Mr. Leach.
--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)

March 23, 2009 at 5:31 am

#964325
RE: is possible thro a single query

Agh... the code above needed a tweek... sorry about the error... it failed one scenario so I fixed 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)

March 22, 2009 at 10:58 am

#964145
RE: T-Sql rant

Michael Valentine Jones (3/22/2009)
The thread on the link below is a good example of a way not to generate a Next ID. I had thought about this method myself,...
--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)

March 22, 2009 at 10:47 am

#964141
RE: is possible thro a single query

S (3/22/2009)
Hi,
Kindly find attached the file for table structure and insert statement in txt files.
Thanks,
Sree 🙂
Heh... see? Someone already started working on your stuff since you made it easy...
--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)

March 22, 2009 at 10:30 am

#964137
RE: updating CLR UDFs / Procedures strategy: contributions needed.

Giovanni (3/21/2009)
Jeff,
you were perfectly correct with the file extension issue. I was missing the "reverse" approach with T-SQL and that lead us to think of using CLR to be...
--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)

March 22, 2009 at 8:13 am

#964127
RE: is possible thro a single query

S (3/22/2009)
Hi,
Thanks for the reply and interest. 🙂
Kindly find attached files containing data in .xls file,.txt file(with data in pipe delimited format) and table structure in .txt file.
Thanks,
Sree
Heh... you either...
--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)

March 22, 2009 at 8:02 am

#964124
RE: T-Sql rant

Lynn Pettis (3/21/2009)
We also need the proper "business" scenario. Could be something based on our past experience or something similiar. I guess we should come up with some...
--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)

March 22, 2009 at 7:56 am

#964123
RE: Regarding Level and its Description

Ashok (3/19/2009)
Thanks GSquared,
Exactly thats what I'm looking for :-).
And Steve, I suggest you to...
--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)

March 21, 2009 at 8:40 pm

#964059

Viewing 15 posts - 44,476 through 44,490 (of 59,097 total)