Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,066 through 31,080 (of 59,101 total)

RE: Output as CSV file.

Ah... ok. Now I get where you're coming from. Thanks for the consideration.
--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)

February 18, 2012 at 10:00 am

#1448911
RE: Programmers v Salespeople

Ron Hinds (2/17/2012)
It pains me to say it, but the most important (and therefore highest paid) people are not programmers or sales, but marketing. You can have the most technically...
--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)

February 18, 2012 at 9:57 am

#1448910
RE: Can I get three examples of ETL?

lozis6947 (2/17/2012)
I would say that your #2 is a bit off
Care to elaborate?
--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)

February 18, 2012 at 9:48 am

#1448907
RE: Minimal Logging and BULK

Agreed on the SELECT/INTO but you really don't want to do that across a linked server. It WILL lock the source in that case.
--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)

February 17, 2012 at 2:11 pm

#1448807
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (2/16/2012)
GilaMonster (2/16/2012)
SQL Kiwi (2/16/2012)
Are the posted articles[/url] getting worse?
Dunno about worse, but definitely shorter
Hit and miss, and this one was short. We have some long...
--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)

February 17, 2012 at 2:07 pm

#1448804
RE: Are the posted questions getting worse?

Greg Edwards-268690 (2/17/2012)
Try synthetic oil.
I did and it works... hate the taste, though. 😉
--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)

February 17, 2012 at 2:05 pm

#1448800
RE: Are the posted questions getting worse?

Evil Kraig F (2/17/2012)
GSquared (2/17/2012)
bitbucket-25253 (2/17/2012)
Way way back Virginia Tech was working on a system with a buried cable in each lane, a sensing mechanism on the front of your...
--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)

February 17, 2012 at 2:03 pm

#1448798
RE: How to generate new sequence number in sql server.

kiran.rajenimbalkar (2/17/2012)
and I have to generate a new values by using function like "nextval"
Sequences as what you speak of will be available in SQL Server 2012. They 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)

February 17, 2012 at 6:49 am

#1448462
RE: Answers

ramyours2003 (2/17/2012)
Hi ,
Can any one answer these
1)What is meaning of switch -m and -c when we bring sql server in single user mode?
2)How can I change...
--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)

February 17, 2012 at 6:34 am

#1448452
RE: Programmers v Salespeople

On the subject of the question of "which is easier to replace", both are difficult to replace for the same reason. Prior knowledge.
--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)

February 17, 2012 at 6:28 am

#1448447
RE: Can I get three examples of ETL?

SQLKnowItAll (2/16/2012)
jake.mayher (2/16/2012)
I agree with Jeff, ETL is in no way specific to the dimensional data warehouse. I define ETL as any process which takes data from one source into...
--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)

February 17, 2012 at 6:19 am

#1448443
RE: Output as CSV file.

Revenant (2/16/2012)
Jeff Moden (2/16/2012)
Revenant (2/16/2012)
- calling the shell is generally considered unsafe; and
I absolutely agree but only because most people don't take the time to set up for its...
--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)

February 17, 2012 at 6:11 am

#1448440
RE: Mulitple Saarch Criteria using ONE Column

Cadavre (2/16/2012)
Jeff Moden (2/15/2012)
🙂
I did say that I've tested this before. :hehe:
Ah, but where would I be if I didn't insist on writing test-scripts to test everything?
Absolutely correct. "A...
--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)

February 16, 2012 at 4:36 pm

#1448227
RE: SELECT wont work using IN()

soulchyld21 (2/16/2012)
I seem to be having trouble with the fact that Im getting customers who have bought one product of the two ('BACNZCT1','BAC1PTS') and not both using this query, could...
--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)

February 16, 2012 at 4:27 pm

#1448223
RE: How to backup only new data?

halifaxdal (2/16/2012)
Red Gate is not an option: it gives me error that my current privilege is not enough to even compare data using Red Gate SQL Data Compare:
EXECUTE permission denied...
--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)

February 16, 2012 at 4:12 pm

#1448220

Viewing 15 posts - 31,066 through 31,080 (of 59,101 total)