Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,826 through 39,840 (of 59,098 total)

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
RE: Time Bomb Coding

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....)
Why not just test it to be sure or not? 😉
--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:57 pm

#1117320
RE: Single column to multiple columns

Jeff Moden (2/10/2010)
Yes there is. Does the table with this data in it have a Primary Key?
Never mind... can't wait. This will work with or without a primary...
--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:52 pm

#1117317
RE: Single column to multiple columns

Yes there is. Does the table with this data in it have a Primary Key?
--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 6:10 pm

#1117298
RE: Democratizing the Microsoft MVP Award

Steve Jones - Editor (2/10/2010)
Nooooooooo, I was hoping not to manage anyone but myself.
Cool... makes us even. I was hoping to not be managed by anyone but myself. ...
--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 5:24 pm

#1117291

Viewing 15 posts - 39,826 through 39,840 (of 59,098 total)