Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,361 through 45,375 (of 59,095 total)

RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

Marios Philippopoulos (2/1/2009)
RBarryYoung (1/31/2009)
Marios Philippopoulos (1/31/2009)
I have a trigger that appears to execute a very large number of logical reads; on one occasion it has hit 73,421,728 logical reads!
Is this...
--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 1, 2009 at 8:19 am

#936156
RE: GROUPING only if EXISTS

Dyamond (2/1/2009)
Jeff,
Thanks for responding, but it still isn't working.
Table
Date, Name, Desc, Code
1/05/09, Test 1, This is Test 1, 55544
1/05/09, Test 1, This is Test 2, 33333
1/05/09, Test 1, This...
--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 1, 2009 at 7:59 am

#936152
RE: procedure

Perfect. 🙂 Miller time? :w00t:
--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)

January 31, 2009 at 9:30 pm

#936113
RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

Ah... true enough.
--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)

January 31, 2009 at 9:22 pm

#936111
RE: Guest Editorial: And Now; a Recitation

BWAA-HAAA! Oh, you said "chops". 😛
--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)

January 31, 2009 at 9:17 pm

#936108
RE: count of consecutive value

dubem1 (1/31/2009)
I can this select return only a single row, with the most recent result code?
Sure... just like you can in the first. Just add a condition to 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)

January 31, 2009 at 9:14 pm

#936106
RE: procedure

RBarryYoung (1/31/2009)
alim.shaikh (1/31/2009)
unfortunately, sql server doesn't provide array since it is not a full fledge programming language...
This is incorrect on two counts. first, SQL is a "full-fledged" programming language....
--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)

January 31, 2009 at 9:10 pm

#936104
RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

RBarryYoung (1/31/2009)
Marios Philippopoulos (1/31/2009)
I have a trigger that appears to execute a very large number of logical reads; [font="Arial Black"]on one occasion [/font]it has hit 73,421,728 logical reads!
Is this for...
--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)

January 31, 2009 at 9:03 pm

#936101
RE: procedure

RBarryYoung (1/31/2009)
dastagirid (1/30/2009)
i used .net c# .here i created one array. that array have two values ..
There are lots of ways to do it, but for two values, they aren't...
--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)

January 31, 2009 at 9:00 pm

#936098
RE: Need help with SQL 2005 SELECT CASE statement

Helen, you're new. Help us help you. Take a moment and read the article at the link in my signature below. Thanks.
--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)

January 31, 2009 at 8:57 pm

#936097
RE: count of consecutive value

Actually, I didn't wait...
Did you drop an recreate the table with the new data? Both solutions I posted return A 3 for the new data.
--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)

January 31, 2009 at 8:54 pm

#936095
RE: count of consecutive value

dubem1 (1/31/2009)
Hello Jeff,
I try your code and found it not really do what I want because if you have this (the following show the 10 last exam result code of...
--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)

January 31, 2009 at 8:47 pm

#936093
RE: GROUPING only if EXISTS

This is untested because you provided no table structure nor any readily consumable data in the form of INSERT statements... for future posts, please see the link in my signature....
--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)

January 31, 2009 at 8:45 pm

#936091
RE: Trouble with variables and function

RBarryYoung (1/31/2009)
Sorry Jeff. 🙂 There is some good stuff there...
Heh... NP... just remember when it happens, the Force flows in more than 1 direction. 😉
--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)

January 31, 2009 at 8:27 pm

#936088
RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

Marios Philippopoulos (1/31/2009)
I have a trigger that appears to execute a very large number of logical reads; on one occasion it has hit 73,421,728 logical reads!
There are two puzzling aspects...
--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)

January 31, 2009 at 8:26 pm

#936087

Viewing 15 posts - 45,361 through 45,375 (of 59,095 total)