Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,496 through 42,510 (of 59,102 total)

RE: Are the posted questions getting worse?

Steve Jones - Editor (8/6/2009)
I will sneak a picture of Jeff at some point and post it up here. Don't worry, we'll track him down at some point.
Heh... no fair....
--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)

August 6, 2009 at 3:08 pm

#1035691
RE: Disable and enabling index frequently

Thanks... at work, I'm still stuck in the world of 2k. Haven't really had a chance to dig into that stuff, yet. I appreciate the leg up.
--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)

August 6, 2009 at 3:05 pm

#1035690
RE: Are the posted questions getting worse?

GSquared (8/6/2009)
jcrawf02 (8/6/2009)
That's how I picture Jeff too, a princess in a forest.
[hides]
I'm just hoping to make him shoot soda out of his nose when he reads my post.......
--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)

August 6, 2009 at 2:41 pm

#1035671
RE: Are the posted questions getting worse?

jcrawf02 (8/6/2009)
That's how I picture Jeff too, a princess in a forest.
[hides]
Heh... yeah... substitute toothfairy in a pink tutu. 😛
--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)

August 6, 2009 at 2:41 pm

#1035670
RE: Are the posted questions getting worse?

Grant Fritchey (8/6/2009)
GilaMonster (8/6/2009)
Grant Fritchey (8/6/2009)
Jeff Moden (8/6/2009)
I've not confirmed my plane reservations but I'm 99.99% sure that I'm going to be in Lil' Rhody from 9/6 to 9/12. ...
--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)

August 6, 2009 at 1:30 pm

#1035641
RE: Page SPlit Errors

Page split erros? Do you really mean "Torn Page" errors?
--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)

August 6, 2009 at 1:24 pm

#1035638
RE: Need help to move 99 lacs records

SELECT INTO will not work on an existing table. 99 Lacs is 9.9 million rows. No matter how you slice it, that will take some time especiall if SIMPLE...
--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)

August 6, 2009 at 1:22 pm

#1035637
RE: What would be the cheapest query for this?

virgilrucsandescu (8/6/2009)
If I have a table / view like this :
ID ATTR1 ATTR2 ... ATTRn
--------------------------
id1 , attribute fields line 1
id1 , attribute fields line 2
id2 , attribute...
--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)

August 6, 2009 at 1:17 pm

#1035633
RE: Moving Average Column / Commulative Average

Read the article at the first link in my signature below. Provide a CREATE TABLE statement and the code to populate it with 10 rows of data using 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)

August 6, 2009 at 1:12 pm

#1035628
RE: Update column with itself plus value of column in another table -- accumulating?

hugh.hemington (8/5/2009)
The "Create Some Data" part of the "tutorial" is complete gibberish since it avoids showing how to assign static values to ANYTHING! (Kee-rist, who comes up with 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)

August 6, 2009 at 1:02 pm

#1035622
RE: Substring statement

tiffany.franks (8/6/2009)
Thank you Ken, you are a genius! This works great, I'm still learning, I appreciate the help!
Tiffany
Tiffany,
Just for further reference, the method Ken used is known as 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)

August 6, 2009 at 12:57 pm

#1035616
RE: Same tables different counts

Mitch2007 (8/6/2009)
It's a many to many relationship. Although there are duplicate Account numbers in table one and duplicate account numbers in table 2 there can only be one account number...
--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)

August 6, 2009 at 12:49 pm

#1035609
RE: Disable and enabling index frequently

GilaMonster (8/6/2009)
It was a feature added in SQL 2005 for cases where an index needs to be dropped for data loads. It means that the index can be recreated without...
--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)

August 6, 2009 at 12:46 pm

#1035606
RE: Are the posted questions getting worse?

Grant Fritchey (8/6/2009)
Jeff Moden (8/6/2009)
Grant Fritchey (8/6/2009)
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's...
--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)

August 6, 2009 at 12:43 pm

#1035604
RE: How to be notified when a insert/update happens?

Gianluca Sartori (8/6/2009)
Jeff Moden (8/5/2009)
I cheat on things like this... xp_CmdShell to a batch file with a NETSEND.
LOL!
Haven't heard of NET SEND in the last 5 years!
It's disabled...
--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)

August 6, 2009 at 12:36 pm

#1035598

Viewing 15 posts - 42,496 through 42,510 (of 59,102 total)