Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,391 through 33,405 (of 59,099 total)

RE: Select From Table Before Transaction Begin

saif_84 (6/13/2011)
I already have SP Creator that build Template for my tables operation but i think adding Code that handle event log every table without have Generic SP will make...
--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 2, 2011 at 3:51 pm

#1347494
RE: How to select all the tables

Heh... it's one of those "language barrier" things that I've seen so often and have had to interpret so often at some companies I've worked for. Unless I'm seriously...
--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 2, 2011 at 3:25 pm

#1347493
RE: Finding the substring where the start position is the nth occurrence of a character?!

I've modified the post (se the second code box) were I was missing the USE of the split function. Apologies for the previous omission.
--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 2, 2011 at 3:13 pm

#1347492
RE: First Normal Form

Tom.Thomson (7/2/2011)
Actually, I wouldn't go so far as to call any of the comments so far unprofessional.
There was one in particular (not directed at you) that seemed it would derail...
--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 2, 2011 at 2:18 pm

#1347487
RE: Finding the substring where the start position is the nth occurrence of a character?!

SQLkiwi (7/1/2011)
Jeff Moden (7/1/2011)
I didn't post the code but, if you look under the code window I posted, there's a link. 🙂
I was expecting the code you posted 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 2, 2011 at 1:55 pm

#1347485
RE: Code Ownership - DBA vs. Developer

PaulB-TheOneAndOnly (7/2/2011)
I respectfully disagree. I stand by my position which is the only one that allows for responsibilities assignment and accountability.
I wrote a rather long post... what is it that...
--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 2, 2011 at 1:46 pm

#1347482
RE: Efficient ways to reset lost sql sa password

I do much the same, Lynn. The only problem I've not been able to solve is if someone with SA privs gets really ticked off and changes the password...
--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 2, 2011 at 1:14 pm

#1347480
RE: Combining Multiple Records Into One

opc.three (6/28/2011)
That's the rub...the level of prejudice towards SQLCLR is right up there with the bazooka...and we both know it's mostly FUD.
I realize I'm getting into semantics but it's 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)

July 2, 2011 at 1:05 pm

#1347479
RE: Code Ownership - DBA vs. Developer

PaulB-TheOneAndOnly (6/29/2011)
Developer owns the code.
Business owns the data.
DBA owns the database environment and is responsible for: Integrity, Availabiltiy, Recoverability and Performance.
Perhaps in your environment.
In our environment, all phases of 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)

July 2, 2011 at 11:17 am

#1347465
RE: Are the posted questions getting worse?

GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.
Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected again. 🙂
--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 2, 2011 at 10:52 am

#1347461
RE: Transaction Log

opc.three (7/2/2011)
@syed, you're welcome for the link. The people on this thread are continuing to quote and correct your posts because you are either spreading poor advice, misinformation or 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)

July 2, 2011 at 10:43 am

#1347457
RE: Transaction Log

Ninja's_RGR'us (7/2/2011)
Lynn Pettis (7/2/2011)
Ninja's_RGR'us (7/2/2011)
Let's make it 6 out of 8.
Censored.
Could be me, but I think this was a bit too much. We really should not attach the messenger...
--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 2, 2011 at 10:31 am

#1347453
RE: Transaction Log

Syed Jahanzaib Bin hassan (7/1/2011)
I think you poeple living with 'I and Me' and cant afford if someone else providing the solution.You poeple have non professional behavoir and attitude,why do...
--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 2, 2011 at 10:23 am

#1347452
RE: First Normal Form

Tom,
I share JJ B's sentiments. Whether I agree with the content of the article or not (and, considering the zealous and sometimes unprofessional retorts in this discussion by others,...
--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 2, 2011 at 10:06 am

#1347451
RE: A Little Interviewing Advice

To be sure, most managers I've had, even the very good ones, suck when it comes to making promises in the form of schedules. 😛
From what you good folks 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)

July 2, 2011 at 8:41 am

#1347443

Viewing 15 posts - 33,391 through 33,405 (of 59,099 total)