Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,601 through 42,615 (of 59,102 total)

RE: Are the posted questions getting worse?

Lynn Pettis (8/2/2009)
Thought I'd bring this to the water cooler. We talked to Kassondra again today, and she leaves reception tomorrow to actually start Basic Training. She sounded...
--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 2, 2009 at 8:36 pm

#1033505
RE: Migrating Foxpro database programs to SQL 2005

As a sidebar... you might be a "novice_coder" in T-SQL but, from what I can see in this thread, you are not a "novice developer". 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)

August 2, 2009 at 7:25 pm

#1033497
RE: CLR Fail to load

I also say that if you've broken it down to 10 procedures that there's nothing wrong with that... unless the procedures only handle one row at a time and then...
--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 2, 2009 at 7:19 pm

#1033496
RE: CLR Fail to load

jqd2001 (8/2/2009)
Jeff (and I) was talking about Cursors and loops, not TVF's. ...there is no reason to believe that your only choices are cursor-based code or 1500-line procedures.
Barry,
For big...
--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 2, 2009 at 7:14 pm

#1033495
RE: CLR Fail to load

jqd2001 (7/23/2009)
there should be no need for "procedural feature" nor a cursor to loop through rules no matter how complicated
Jeff,
In that sense, we will end up with...
--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 2, 2009 at 6:48 pm

#1033493
RE: How to join Candidate and Qualification tables

pandeharsh (8/2/2009)
Hi,
I think I hv posted my problem ok like providing,structure of tables.
only thing is that i didn't populated my tables.
Then, as you have stated, "You have half understtod...
--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 2, 2009 at 4:32 pm

#1033482
RE: Disable and enabling index frequently

manohar (8/2/2009)
Hi all,
I have a table in which records frequently gets inserted. Around 5000 records per minute.
I am selecting data from that table once or twice per minute
Because of huge...
--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 2, 2009 at 4:11 pm

#1033480
RE: Shrinking Database

trayalacheruvu (7/28/2009)
Hi,
i have around 500 tables in my database with size of 20 GB. Now i am planing to remove 200 tables from the database. after deleting the database still...
--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 2, 2009 at 4:05 pm

#1033478
RE: Are the posted questions getting worse?

RBarryYoung (8/2/2009)
Oh Jeff, ... You might want to take this one ... 😀
By the way, Barry... thank you for the very high compliment about SSC and the Tally 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)

August 2, 2009 at 3:38 pm

#1033477
RE: Be a Craftsman

I'm just going to skip over the words "unionize IT workers". It may be right for some but not for me, thank you.
And, yeah... I've pretty much always chosen...
--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 2, 2009 at 3:16 pm

#1033475
RE: Migrating Foxpro database programs to SQL 2005

novice_coder (8/2/2009)
Hello Allister,
Thanks for the help. Your code shows how to think column wise rather than going row by row. I am getting a hang of it now. And you...
--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 2, 2009 at 3:09 pm

#1033474
RE: Are the posted questions getting worse?

RBarryYoung (8/2/2009)
Oh Jeff, ... You might want to take this one ... 😀
For some reason, that thread hasn't been notifying me of new posts via email. I've responded...
--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 2, 2009 at 3:04 pm

#1033473
RE: Be a Craftsman

David Korb (8/2/2009)
I spent about 40 minutes crafting a reply, but when I hit "Preview" received a "The session identity provided has expired or could not be found." message. All...
--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 2, 2009 at 11:44 am

#1033458
RE: Migrating Foxpro database programs to SQL 2005

novice_coder (8/1/2009)
Hello Jeff,
You are the man. Everything is going in SPs and I am scheduling the scripts calling these SPs.
Thanks for the help.
On RBAR: I guess I have 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)

August 2, 2009 at 11:03 am

#1033454
RE: Date conversion

Heh... everybody is happy... 'cept me. 😛 No one answered my question. Here it is again...
Does SSRS have something in it to take an SQL DateTime and format...
--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 2, 2009 at 10:58 am

#1033452

Viewing 15 posts - 42,601 through 42,615 (of 59,102 total)