Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,806 through 38,820 (of 59,098 total)

RE: Determine size of record/row in a table

Dan Fran (4/21/2010)
Hello,
I am curious to know if there is a way to determine the size of a specific row/record in a given table. I know that sqlserver only...
--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)

April 21, 2010 at 4:11 pm

#1155738
RE: Hiding payroll data from admin

Lynn Pettis (4/21/2010)
Toby White (4/21/2010)
What system, application, and/or users DO need to see the salary data? If you rely on the SQL engine to decrypt the data, then you cannot...
--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)

April 21, 2010 at 4:08 pm

#1155737
RE: Centrally located stored procs?

Elliott W (4/21/2010)
bagofbirds-767347 (4/21/2010)
Lowell - that worked man. awesome!! Thanks so much!
The rest of you - to answer the main question: i do have a handfull of databases...
--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)

April 21, 2010 at 3:54 pm

#1155728
RE: Centrally located stored procs?

Lowell (4/20/2010)
i believe if you mark the proc as a system proc, it will do the automagical [currentdbcontext].[dbo].[tablename], instead of looking for the ].[tablename] in master;
EXECUTE sp_ms_marksystemobject 'sp_test'
Heh... I'll be...
--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)

April 21, 2010 at 3:52 pm

#1155727
RE: What do you do when you don't get paid?

Ninja's_RGR'us (4/21/2010)
Now the clients wants me to go back as a consultant to keep working on the projects. I refused since it would breach my relationship with my boss...
--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)

April 21, 2010 at 3:42 pm

#1155723
RE: MCJ - The Missing Link

Steve Jones - Editor (4/21/2010)
I have spoken with my boss, and in principle he thinks it's a good idea to help out here. Any preferences on what you're like 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)

April 21, 2010 at 2:54 pm

#1155686
RE: Are the posted questions getting worse?

Grant Fritchey (4/21/2010)
So in summary, Oracle Sucks!
Thanks for that important safety tip Jeff.
Heh... I'll probably get slammed by the folks that like Oracle (not slamming them, though), but I worked...
--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)

April 21, 2010 at 1:24 pm

#1155618
RE: Are the posted questions getting worse?

Grant Fritchey (4/21/2010)
Trey Staker (4/21/2010)
Roy Ernest (4/21/2010)
GabyYYZ (4/21/2010)
Please tell me THIS doesn't happen a lot...*groan*.
I hope it is just a joke....
I doubt it's a joke. I've seen stuff like...
--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)

April 21, 2010 at 11:26 am

#1155545
RE: Are the posted questions getting worse?

Tom.Thomson (4/20/2010)
Jeff Moden (4/20/2010)
Hmmmm... I'd really be interested in the translation for "If you want it real bad, you'll usually get it that way."
The pun on "bad" doesn't really work...
--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)

April 21, 2010 at 11:21 am

#1155541
RE: Today's Random Word!

Trey Staker (4/21/2010)
Hibernate
Heh.... performance problem. 😉
--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)

April 21, 2010 at 11:16 am

#1155537
RE: Optimization: Turning a series of entries into columns

huston.dunlap (4/20/2010)
Thinking about it more I think what I will do is turn the fields into a semi colon delimited list, getting rid of the duplicate fields.
Then I can implement...
--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)

April 20, 2010 at 8:51 pm

#1155066
RE: Pivoting name value pairs

COldCoffee (4/20/2010)
Jeff, you really are a wonderful character.. and for paul and karthik, thanks for providing new views and test results.. u guys are simply great.. thanks all 🙂
Shucks. :blush:...
--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)

April 20, 2010 at 8:46 pm

#1155064
RE: Pivoting name value pairs

Paul White NZ (4/20/2010)
pYak (4/20/2010)
are there any particular cases that you can think of where using the PIVOT operator would be more appropriate?
Not really, no. The PIVOT is shorthand...
--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)

April 20, 2010 at 8:41 pm

#1155058
RE: Select a string when data in the string varies

Bill,
Yeah, at this point, we need some more information. Please post the code for the split function you're actually using so we can check it for errors, the table...
--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)

April 20, 2010 at 8:25 pm

#1155055
RE: MCJ - The Missing Link

dma-669038 (4/20/2010)
I also suggest we keep the 'journeyman' and replace 'Microsoft Certified' with something else...like a 'SQL Server Journeyman' perhaps..one of the comments i got on the survey was 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)

April 20, 2010 at 2:32 pm

#1154944

Viewing 15 posts - 38,806 through 38,820 (of 59,098 total)