Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,441 through 37,455 (of 59,098 total)

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
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

David Portas (7/31/2010)
Tom.Thomson (7/29/2010)
If anyone attempts to use SQL's single null to indicate why data is missing they are being very stupid. Codd explicitly required NULL (and later 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 2:06 pm

#1200786
RE: Need urgent help

shishirbabel (7/30/2010)
We have an e-commerce website with hundreds of products . Need new functionality added to the website where after every 24 hours products will be automatically rotated in [font="Arial...
--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 1:50 pm

#1200782
RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

sql dba kittu (7/31/2010)
In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.
My bad uck they didn't provide me...
--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 1:34 pm

#1200780
RE: TSQL LAB 2 - Writing Conditional WHERE Clauses

Ok... after reading this a second time, I have to ask... what about performance? Under optimal conditions (ie. correct indexes on the table), which method(s) will actually be 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 12:59 pm

#1200775

Viewing 15 posts - 37,441 through 37,455 (of 59,098 total)