Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,411 through 37,425 (of 59,072 total)

RE: Snoops

Steve Jones - Editor (8/2/2010)
Dimbulbz (8/2/2010)
... I don't know where you have taken your sample from, but that is scary and perhaps I need to do my own polling...
--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 2, 2010 at 4:40 pm

#1201299
RE: Tally Table Uses - Part I

Stefan Krzywicki (8/2/2010)
I do appreciate the suggestion, but I'm going to let it stand. I can't count the number of times I've read code or a coding technique and thought...
--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 2, 2010 at 7:12 am

#1200989
RE: Are the posted questions getting worse?

Gianluca Sartori (8/2/2010)
What exactly are you americans doing at work that makes you worth all that money?
Heh... we don't get to keep all that. Most of us work 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 2, 2010 at 7:07 am

#1200983
RE: TSQL or SSIS

KBSK (8/1/2010)
Jeff Moden (7/28/2010)
If the structure of the text file is known, BULK INSERT would probably be your best bet. Doesn't require ad hoc queries to be enabled.
Thank you.
I...
--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 2, 2010 at 6:59 am

#1200972
RE: Are the posted questions getting worse?

Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).
Wow! If that's actually true, that's WAY too low for someone of your level of talent, Gianluca. ...
--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 2, 2010 at 6:28 am

#1200953
RE: Tally Table Uses - Part I

Heh... pretty low marks for the article so far, Stefan. Although I certainly appreciate what you tried to do both in your code and for the Tally Table, I...
--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 2, 2010 at 6:17 am

#1200947
RE: Tally Table Uses - Part I

It IS interesting to see what folks do with the Tally Table or the "pseudo cursor" methods that are used to build it.
Nice article and lot's of code to play...
--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 1, 2010 at 9:56 pm

#1200834
RE: Are the posted questions getting worse?

WayneS (8/1/2010)
GilaMonster (7/31/2010)
And for the weekend...
Want someone to email questions to: http://www.sqlservercentral.com/Forums/Topic961691-1550-1.aspx
Am outa here for the weekend.
I just had to submit my rates for this. 😀
Edit: Now, if I 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 1, 2010 at 8:59 pm

#1200829
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Tom.Thomson (8/1/2010)
If you believe that nulls generated by outer join always get removed before any user sees them you have lead a very sheltered life!
Heh... and to think I 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 1, 2010 at 8:48 pm

#1200827
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

David Portas (8/1/2010)
Jeff Moden (8/1/2010)
Maybe I have your intention wrong but look again. Tom said that a NULL could not be used to explain WHY data was missing (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)

August 1, 2010 at 8:40 pm

#1200826
RE: Deterministic UDF slower than Non-Deterministic?

dant12 (8/1/2010)
Jeff Moden (8/1/2010)
dant12 (7/31/2010)
wow Jeff, thats a nice load of replaces lol. ill test it first thing on monday and post the results against the old T-SQL and 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 1, 2010 at 4:56 pm

#1200808
RE: Need urgent help

Alvin Ramard (8/1/2010)
This may be too much for the forum, but it would not be too much for a homework assignment.
I actually don't believe it's a homework assignment or even...
--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 1, 2010 at 3:35 pm

#1200798
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Maybe I have your intention wrong but look again. Tom said that a NULL could not be used to explain WHY data was missing (or unknown my book). ...
--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 1, 2010 at 3:21 pm

#1200795
RE: Are the posted questions getting worse?

bitbucket-25253 (7/31/2010)
nor when my use of cursors (excuse me Jeff) slowed things down to a crawl.
Heh... I [font="Arial Black"]KNEW [/font]there was a disturbance in the Force! 😛
--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 1, 2010 at 2:14 pm

#1200789
RE: Are the posted questions getting worse?

Alvin Ramard (7/31/2010)
GilaMonster (7/31/2010)
It's Sunday 1am and I'm recovering a 120 GB sql database from a month old backup and a collection of flat files. DBA? We don't need 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)

August 1, 2010 at 2:10 pm

#1200788

Viewing 15 posts - 37,411 through 37,425 (of 59,072 total)