Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,566 through 47,580 (of 59,095 total)

RE: Wierd Counter!

Thanks for the "cover". 🙂
--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)

October 27, 2008 at 5:49 pm

#890346
RE: How to post comments on externally linked articles

Man, would I like to be able to comment here on external articles so I don't have to sign up for every forum that has a "dangerous code" article. ...
--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)

October 27, 2008 at 11:59 am

#890162
RE: SQL Data Counter

rishgup (10/26/2008)
Jeff Moden (10/26/2008)
And, how does the app know what that latest value is?
Whenever any Insert Operation occurs on tbl employee counter_ins will be increment by 1.
Heh... yeah, 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)

October 27, 2008 at 6:00 am

#889923
RE: counters

Have you looked in "parameter sniffing" like I suggested above?
--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)

October 27, 2008 at 5:56 am

#889921
RE: counters

Heh... me too... as previously stated, there's just not enough info to help here.
--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)

October 27, 2008 at 5:55 am

#889920
RE: SQL DB Performance

Not without actually putting my hand on the system and not with my hands tied by rules like not being able to change code which is likely the biggest performance...
--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)

October 27, 2008 at 5:52 am

#889919
RE: Need help on performance and integrity

Peso (10/27/2008)
Also see
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112721
http://www.sqlservercentral.com/Forums/Topic562564-338-1.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3829716&SiteID=1
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3928920&SiteID=17
Heh... but the question remains... has anyone done it correctly, yet?
--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)

October 27, 2008 at 5:48 am

#889916
RE: small query help me out

AnzioBake (10/27/2008)
I want to Correct myself....
I just tested this again and even explicit conversion gives the result as in Jeffs first example. I played some more and it appears...
--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)

October 27, 2008 at 5:21 am

#889903
RE: Pivot table withiught aggregation

paulneyman (10/26/2008)
Jeff Moden (10/25/2008)
Paul,
It would help us give you a better answer quicker if you posted Table A and it's data in a readily "consumable" format. See the link...
--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)

October 26, 2008 at 7:37 pm

#889812
RE: SQL Data Counter

And, how does the app know what that latest value is?
--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)

October 26, 2008 at 7:32 pm

#889810
RE: Stored Procedure to query many tables

pozzo (10/26/2008)
Thanks for you answer.
I think I need to be more clear.
I already have a single table for each month in each year.
I need to export each table to Excel...
--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)

October 26, 2008 at 7:25 pm

#889809
RE: Updating Values Without Cursor

Garadin (10/25/2008)
rbarryyoung (10/25/2008)
Jeff Moden (10/25/2008)
Parul Sharma (10/24/2008)
I can tell you the answer to that... Seth's will handle a million rows in less than 7 seconds... the others that use 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)

October 26, 2008 at 7:22 pm

#889808
RE: Absolutely (Not?)

Ross McMicken (10/26/2008)
We have a couple of places where we have to use cursors to generate interface files that are sent to legacy mainframe apps. Not an ideal situation, 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)

October 26, 2008 at 7:17 pm

#889807
RE: 'N' number of usage - Tally Table

Absolutely no comment on that stupidity.
--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)

October 26, 2008 at 7:13 pm

#889805
RE: DATEADD FUNCTION WITH TALLY TABLE GIVE OVERFLOW ERROR WITH MONTH

Bottome line is, don't do calculations on t.N in the WHERE clause or all of the Tally table must be evaluated... as I saw previously suggested, this works the best...
--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)

October 26, 2008 at 10:28 am

#889758

Viewing 15 posts - 47,566 through 47,580 (of 59,095 total)