Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,631 through 30,645 (of 59,101 total)

RE: Detect data changes in a "read-only" database?

peter 82125 (3/24/2012)
I need to identy records that have changed in a table.
Do you need to know the actual records that changed or just that the contents 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)

March 24, 2012 at 9:40 pm

#1463972
RE: Detect data changes in a "read-only" database?

Lynn, despite the title, I don't believe that the database is in the "read only" mode because of what the OP asked. I believe the "read only" part 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)

March 24, 2012 at 9:38 pm

#1463971
RE: A Personality Test

Heh... I guess I'd be an ambulance... because the person that asks that question really needs a quick ride to the loony bin if they think such questions will actually...
--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)

March 24, 2012 at 9:28 pm

#1463970
RE: Get month names ordered using recursion

I'm not sure what you're speaking of. You already have the numbers that prove that if you calculate more than the number of rows you need, then you waste...
--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)

March 24, 2012 at 8:35 pm

#1463964
RE: Triangle Join - Can I do it right or a replacement?

The thing I'm curious about is do you really intend to report by day? I can see storing weeks and months and their running totals but I'm not so...
--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)

March 24, 2012 at 8:31 pm

#1463963
RE: how to convert seconds to time in sql

Lowell (3/24/2012)
dastagiri16 (3/24/2012)
hi,
Thanks for replying ...
It is not working in all cases suppose the seconds is more than 100 hours its showing wrong .
Thanks,
Dastagiri.
so...yo want elapsed time converted to years:months:hours:minutes:seconds,...
--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)

March 24, 2012 at 6:40 pm

#1463955
RE: Get month names ordered using recursion

the sqlist (3/24/2012)
ChrisM@home (3/24/2012)
the sqlist (3/24/2012)
...I think we should not be worried about how many rows are actually generated...
I couldn't disagree more. When you're looking at an overall time 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)

March 24, 2012 at 6:36 pm

#1463954
RE: Get month names ordered using recursion

the sqlist (3/24/2012)
...too bad it only works on 2008 and up so I will stay away from it until it becomes more "popular".
Forgive me if you're already aware of it....
--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)

March 24, 2012 at 5:55 pm

#1463950
RE: Get month names ordered using recursion

ChrisM@home (3/23/2012)
Here's one way of limiting the rowcount:
DECLARE @pString VARCHAR(8000), @pDelimiter CHAR(1)
SET @pString = 'one,TWO,THREE,FOUR,five,six,seven,eight,nine,ten,eleven,twelve,thirteen,fourteen,fifteen,sixteen,seventeen,eighteen,nineteen,twenty,twenty one,twenty two,twenty three,twenty four'
SET @pDelimiter = ','
SELECT
ItemNumber = CAST(0 AS BIGINT),
Item = LEFT(@pString,...
--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)

March 24, 2012 at 5:29 pm

#1463947
RE: Get month names ordered using recursion

Tony Palmeri (3/23/2012)
I just get the impression sometimes that (some) developers have the mistaken idea that a single T-SQL statement at run-time "just happens" all at once, and 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)

March 24, 2012 at 1:48 pm

#1463942
RE: Get month names ordered using recursion

ChrisM@Work (3/23/2012)
Lisa Slater Nicholls (3/23/2012)
Hi Jeff, I'll have to look into it at home - this gig is 2k5 only 🙁
I did a lot of work on exactly this subject,...
--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)

March 24, 2012 at 1:11 pm

#1463939
RE: Variable not getting reset inside the loop

Lynn Pettis (3/23/2012)
Sean Lange (3/23/2012)
Eugene Elutin (3/23/2012)
Sean Lange (3/23/2012)
Please! "Even better, don't use loops."? Why? :w00t:
I do not agree!
If you say that, you should say it right!
OK, don't use...
--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)

March 24, 2012 at 1:03 pm

#1463937
RE: Variable not getting reset inside the loop

Eugene Elutin (3/23/2012)
...
Instead of having a development organization with a schism between COBOL programmers and other programmers, the new environment allows programmers to bridge the barriers using common interfaces and...
--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)

March 24, 2012 at 12:58 pm

#1463936
RE: Index rebuild suddenly takes 5 times as long ?!?

Divine Flame (3/23/2012)
TheSQLGuru (3/23/2012)
I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad for 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)

March 24, 2012 at 12:51 pm

#1463935
RE: Attracting Talent

Eric M Russell (3/21/2012)
I think one prerequisite for being a good DBA is know how to deal with cocky developers.
Oooohhh.... easy question for me. "A written set of managment...
--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)

March 24, 2012 at 12:17 pm

#1463929

Viewing 15 posts - 30,631 through 30,645 (of 59,101 total)