Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,796 through 39,810 (of 59,072 total)

RE: Time Bomb Coding

David.Poole (2/11/2010)
Jeff, there is a short and illuminating article on http://www.infoq.com http://www.infoq.com/vendorcontent/show.action?vcr=847 regarding technical debt in agile projects that echoes what you say.
Basically a project team is given a fixed...
--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)

February 11, 2010 at 6:51 pm

#1117864
RE: Time Bomb Coding

george sibbald (2/11/2010)
Jeff Moden (2/10/2010)
It makes it through QA, they put the "Approved" stamp on it, it get's shipped to the customer, and the customer tries to use the code...
--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)

February 11, 2010 at 6:49 pm

#1117863
RE: query help required

Heh... OK... got it. You write nice tight code all the time and I was just wondering if you saw something that I was missing.
To be sure, I always...
--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)

February 11, 2010 at 12:01 pm

#1117700
RE: query help required

Sorry, Nabha. Your code certainly looks like it'll work just fine. Considering the data spec, I was just wondering why you went the extra mile with the correlated...
--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)

February 11, 2010 at 6:55 am

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

Heh... so MS is only now discovering some of the features left behind by the people who originally wrote Sybase. 😛
Not to worry... if it's documented anywhere by MS,...
--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)

February 11, 2010 at 6:48 am

#1117540
RE: Single column to multiple columns

My bad... not sure what I was thinking. Previous code will return blanks and not nulls. The following will return nulls for the missing data and is 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)

February 10, 2010 at 10:47 pm

#1117379
RE: 32 bit versus 64 bit

Yes... more features... but the wrong way...
I'm not sure if they've fixed the problem yet or not but my understanding is that 64 bit versions cannot use JET drivers... 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)

February 10, 2010 at 10:37 pm

#1117373
RE: query help required

Nabha (2/10/2010)
Maybe I'm missing something but could it be as simple as this?
Regards,
Willem
http://wschampheleer.wordpress.com
That would give the records even if the employee is not active now.
and 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)

February 10, 2010 at 10:32 pm

#1117371
RE: Question and learning on shrinking datafile,log file, tempdb

I boot my servers with more than 8GB for TempDB. 😉
Give it some room to breath and stop shrinking it. Also, as you're finding out, scheduled shrinking of...
--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)

February 10, 2010 at 10:18 pm

#1117361
RE: Bit of a noob with some expereince needs help with duplication

I never import to the final table... I always import to a "staging" table and then use some "upsert" or "merge" code I've written to both pre-validate the data 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)

February 10, 2010 at 10:09 pm

#1117355
RE: When is 8000 too small?

My guess would be that 8000 is too small as soon as you need 8001. 😉
While it would be nice to maybe have more than 8060 bytes, it'll get 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)

February 10, 2010 at 10:03 pm

#1117353
RE: The Best Laptop

Manie Verster (2/10/2010)
I have a HP (Hewlett-Packard) laptop with no trackpoint and have been thinking about getting a laptop with a trackpoint. I use a mouse, not the touchpad, 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)

February 10, 2010 at 9:15 pm

#1117340
RE: select max date record

Hi Scott,
You're new to the forum and you've just run into the same problem that a lot of folks run into. To find out what that problem is 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)

February 10, 2010 at 8:58 pm

#1117338
RE: Time Bomb Coding

Like Remi said, "Where's the 10 Star button?" Outstanding article, David. Definitely a classic and a keeper.
One of my personal favorite time bombs is when people write, ummmm.......
--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)

February 10, 2010 at 8:50 pm

#1117337
RE: Time Bomb Coding

Ryan C. Price (2/10/2010)
nicholasw (2/10/2010)
Instead of:
IF EXISTS(SELECT 1 FROM ......WHERE....)
Would the following be quicker still?
IF EXISTS(SELECT TOP 1 1 FROM ......WHERE....)
No, and it doesn't really make sense - TOP implies...
--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)

February 10, 2010 at 7:59 pm

#1117322

Viewing 15 posts - 39,796 through 39,810 (of 59,072 total)