Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,536 through 47,550 (of 59,099 total)

RE: A Few Good DBAs

Grant Fritchey (10/29/2008)
Does this mean I get to carry a gun at work now?
I promise, no more than one developer a week. 😀
What... you're not already packin'? Thought is...
--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)

October 29, 2008 at 5:50 am

#891130
RE: Assigning current of _Cursor to local @variable

Greg Snidow (10/28/2008)
I know this is a SQL forum, but there are times when I, and this is just me, find it easier to do this kind of thing 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)

October 28, 2008 at 10:10 pm

#891027
RE: Predictable Index Fragmentation

Nice job, Craig... and great graphics! I'm gonna have to play... 🙂
--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)

October 28, 2008 at 10:05 pm

#891025
RE: A Few Good DBAs

What a great read... and how timely! I just went through something like this with my bosses! Well done!
--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)

October 28, 2008 at 9:58 pm

#891023
RE: Assigning current of _Cursor to local @variable

Thanks Sergiy! 🙂
--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)

October 28, 2008 at 9:46 pm

#891022
RE: SQL-Server 2005: Change Ordinal Column Position

Heh... yeah, that was my first impression when I saw the original post. I wanted to scream "WHAT? ARE YOU NUTS??" Then I remembered the time when...
--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)

October 28, 2008 at 9:40 pm

#891019
RE: small query help me out

Thanks for the feedback, Christo. 🙂
--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)

October 28, 2008 at 9:34 pm

#891016
RE: Absolutely (Not?)

Heh... "Azure"... is that like a "Purple Haze"? 😛
--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)

October 28, 2008 at 9:31 pm

#891015
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

J... I misread Gary's post... it was all actually a pretty nice compliment. 🙂 The "While-loop Hole" wasn't a crack at me... it was his way of saying...
--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)

October 28, 2008 at 9:30 pm

#891014
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

GF (10/15/2008)
Jeff, thank you for taking the time to listen.
My current needs are to split an address into two parts.
example: 1234 south street needs to be split into 1234 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)

October 28, 2008 at 9:27 pm

#891013
RE: SQL Data Counter

rishgup (10/28/2008)
Jeff Moden (10/27/2008)
Sure... read the very message of mine that you quoted... lookup IDENTITY in Books Online.
Jeff,
By identity column you mean IS IDENTITY = 'TRUE' which will increment 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)

October 28, 2008 at 9:23 pm

#891012
RE: convert a varchar(4000) to a int !?

Heh... yep... I know exactly what you mean. The good part about a failing memory is all the new people you get to meet everyday. 😛
--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)

October 28, 2008 at 9:14 pm

#891011
RE: disabled component to install

Lowell (10/28/2008)
aw come on, you know what i mean...Dev is limited to a max of 10 connections, instead of limited only by memory in the full version, a couple...
--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)

October 28, 2008 at 9:13 pm

#891010
RE: Organizations With No DBAs

Heh... then I'm about to make you incredibly jealous... we're phasing out the Oracle side of the house in my shop. I've died and gone to heaven! 🙂
--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)

October 28, 2008 at 8:57 pm

#891006
RE: Assigning current of _Cursor to local @variable

J (10/28/2008)
Using "INDEX(0)" is a later manifestation of the code... don't need to know the name of the clustered index that way and that allows you to easily use 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)

October 28, 2008 at 8:14 pm

#890995

Viewing 15 posts - 47,536 through 47,550 (of 59,099 total)