Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,426 through 49,440 (of 59,099 total)

RE: query performance problem

Ok... here we go... other than personal preference, what are the practical reasons why you do 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)

July 5, 2008 at 5:10 pm

#838559
RE: obtain data from 2 weekdays?

bitbucket (7/5/2008)
Jeff ran your codea and got the following:
@Day @monday ...
--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)

July 5, 2008 at 5:09 pm

#838558
RE: To Certify or Not To Certify

... and THAT's precisely what I'm getting at... neither the cert nor the degree really matter because some cheat at both and the good guys will shine no matter what,...
--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)

July 5, 2008 at 2:41 pm

#838551
RE: The Database Weekly Update for July 7, 2008

And I've noticed that as I've gone to multiple cores, things have gotten better.
I hope DBAs don't need to learn how to program in parallel computing,
I think multi-cores are going...
--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)

July 5, 2008 at 2:34 pm

#838550
RE: query performance problem

Heh... I thought you said it was cleaned up... it has leading commas in it 😀
--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)

July 5, 2008 at 2:28 pm

#838548
RE: To Certify or Not To Certify

GilaMonster (7/5/2008)
When I'm interviewing, I assume that the fact that a person has a certification means that he/she knows that area.
That's where you and I may differ... I don't ask...
--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)

July 5, 2008 at 2:16 pm

#838547
RE: Randomly Pick Specified Number of Rows?

Melville (7/5/2008)
As to Mr. Moden's 'why' - I think that the answer is that sometimes you want a specified but user variable number of rows returned -
Heh... lordy... I...
--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)

July 5, 2008 at 1:58 pm

#838546
RE: query performance problem

rbarryyoung (7/5/2008)
Well my first suggestion is to stop using Query Wizard, because it makes it really easy to make really bad and ugly queries like this.
Secondly, to do anything 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)

July 5, 2008 at 1:10 pm

#838543
RE: what would be the maximum seed value for a bigint column in a table in SQL Server 2000

dakshinamurthy (7/5/2008)
I would also helpfull if i get to know what to do if we exceed the seed value for a bigint field in a table
If you exceed the maximum...
--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)

July 5, 2008 at 1:04 pm

#838542
RE: DateTime to Date only....

BitBucket... I like your signature line... I think everyone should have that line in it... 😉
--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)

July 5, 2008 at 12:58 pm

#838541
RE: obtain data from 2 weekdays?

Ooooohhh! Be real careful... unless all of your dates have a midnight time, the following will miss all but the first millisecond of the date carried by @friday...
select *...
--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)

July 5, 2008 at 12:27 pm

#838540
RE: CLR - Stored Procedure Lock

Of course, the real question is...
What have you written a CLR for that you think can't be done in T-SQL?
Seriously... several of us have had several major "races"...
--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)

July 5, 2008 at 9:41 am

#838512
RE: DateTime to Date only....

Looks like Carl beat me to the notation about formatting being done on the client side...
Carl... no, I don't have the link that you're asking about... sorry.
--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)

July 5, 2008 at 9:37 am

#838511
RE: DateTime to Date only....

b_boy...
Along with what Mouse suggested, lookup CONVERT in Books Online to find all of the built-in date patterns. It's worth the read.
As a side bar, if there's a GUI...
--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)

July 5, 2008 at 9:36 am

#838510
RE: DateTime to Date only....

Carl Federl (7/5/2008)
There was a very long forum post on various methods to get only the date portion from a datetime datatype. One of the most efficient was 1....
--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)

July 5, 2008 at 9:28 am

#838507

Viewing 15 posts - 49,426 through 49,440 (of 59,099 total)