Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,786 through 37,800 (of 59,072 total)

RE: Recursive Trigger Question

Navi's (6/30/2010)
Hi,
I am getting the same error..
"Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."
Can you tell me is it comes due to trigger call.
In my case,...
--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)

July 3, 2010 at 4:11 pm

#1188573
RE: Should DBAs Be the Protectors of Data?

Sean Josiah-454849 (7/3/2010)
Jeff:
thus systems have to have 100% uptime, people can't get sick or go on vacation, and nothing fills the round file. yet the world keeps spinning, and todays...
--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)

July 3, 2010 at 1:46 pm

#1188569
RE: What columns are eligible to be in non clustered index

xzd000 (7/3/2010)
Well, what about the property of the column to be used as such?
The emphasis is that - The table does not have primary key column. Does that fact...
--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)

July 3, 2010 at 12:03 pm

#1188559
RE: Should DBAs Be the Protectors of Data?

Heh... I do find it amazing that certain types of data are considered to be NOT mission critical... that is, until it's lost. 😉
--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)

July 3, 2010 at 11:57 am

#1188558
RE: Left Outer Join replace *=

Steve Jones - Editor (7/2/2010)
How's this:
select
Fname
, LName
, Mname
from Employee e
LEFT OUTER JOIN Timekeep t
ON e.employee.id =...
--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)

July 3, 2010 at 11:43 am

#1188556
RE: change DateFirst within a funciton

She Through Whom All Data Flows (11/2/2009)
Ok, I'll attempt to explain why. My function fnMfgMonth calculates the "manufacturing month" for a given date. "Manufacturing month" is determined by the week...
--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)

July 3, 2010 at 11:31 am

#1188553
RE: Should DBAs Be the Protectors of Data?

I agree with your mentor. So far as I'm concerned, a DBA's only job is to protect the data. Anything and everything else a DBA does is in...
--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)

July 3, 2010 at 11:22 am

#1188545
RE: What columns are eligible to be in non clustered index

You can create more than 200 NC indexes on any table if you don't mind duplicates on small tables like this one. With a 5 column table, though, 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)

July 3, 2010 at 11:19 am

#1188543
RE: Are the posted questions getting worse?

Jack Corbett (7/3/2010)
Cool! They must be in the developer track because I didn't see them in the DBA track. I'm sure one of them will be selected. ...
--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)

July 3, 2010 at 11:06 am

#1188540
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

jyurich (7/3/2010)
I am usually a fan of your posts. However, these articles left a lot to be desired. The examples provided are trivial at best (please do take this 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)

July 3, 2010 at 10:39 am

#1188533
RE: Error! Msg 103, Level 15, State 4, Line 1

You bet. Thanks for the feedback, Ami.
--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)

July 3, 2010 at 10:22 am

#1188532
RE: Are We Not Testing Enough?

Grant Fritchey (7/2/2010)
michael.wiles (7/2/2010)
Grant Fritchey,
You alluded to the fact that you look at work history with applicable knowledge in order to give someone a position. How does someone usually...
--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)

July 3, 2010 at 10:11 am

#1188529
RE: Are the posted questions getting worse?

Grant Fritchey (7/2/2010)
Jeff Moden (7/2/2010)
Hey Grant! What day is your local Pass meeting on in July? I'm going to be in lil' Rhody from the 11th 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)

July 3, 2010 at 9:37 am

#1188526
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/2/2010)
I agree with you Jeff. We could only pick from what was submitted, but some of the feedback that I've given is that we ought to...
--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)

July 3, 2010 at 9:32 am

#1188525
RE: Are the posted questions getting worse?

Jack Corbett (7/2/2010)
Sounds like you need to go on the road. Also submit to the Summit. There is a development track, I didn't get to see any abstracts...
--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)

July 3, 2010 at 9:30 am

#1188524

Viewing 15 posts - 37,786 through 37,800 (of 59,072 total)