Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,321 through 46,335 (of 59,095 total)

RE: Require help on CTE common table expressions query construncting

noeld (12/29/2008)
I know I am going to get some heat because of it but hey USA is a free country.
Only if you've never had to fight for her... 😉
--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)

December 29, 2008 at 6:48 pm

#918698
RE: Is it safe to use "update syscolumns set colstat"

WHY? WHY do you want to drop the IDENTITY attribute? It's served you quite well for a hundred million rows... why are you trying to change horses in...
--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)

December 29, 2008 at 6:44 pm

#918697
RE: SQL Queries Are Coming To Town

Uoumph! I once wished I could sing like Burl Ives... BWAA-HAA!!! Now I wish you could! 😛
Merry Christmas and Happy New Year!
--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)

December 29, 2008 at 6:40 pm

#918695
RE: How data can remove automatic from tempdb after some task

Without more information, I'd have to say "like you would anywhere else". Insert from one table to the other using Insert/Select... then, delete the rows you just moved from...
--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)

December 29, 2008 at 6:34 pm

#918693
RE: Determining Physical Size of Tables/Indexes etc..

Dunno if this will work on 64 bit... but I think you'll like it if it does...
/**********************************************************************************************************************
Purpose:
Returns a single result set similar to sp_Space used for all user...
--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)

December 29, 2008 at 6:26 pm

#918691
RE: Writing select results to a file

If the file is a "continuous" log instead of a file to be created on the fly, look into the simplicity of making a Text based linked server... a pretty...
--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)

December 29, 2008 at 6:13 pm

#918689
RE: what will be the value of YEAR(GETDATE()) + MONTH(GETDATE()) + DAY(GETDATE()))

PhilPacha (12/29/2008)
Hmmm... Simple addition will NOT work. Multiplication is also needed.
Example 1: 2009 + 1 + 2 = 2012 (January 2, 2009)
Example 2: 2009...
--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)

December 29, 2008 at 6:06 pm

#918687
RE: Semi joins

Heh... I guess I don't use WHERE EXISTS for the same reason I don't use Try/Catch... I know the database and I know the DRI... when I join on something,...
--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)

December 29, 2008 at 6:00 pm

#918685
RE: How to calculate the Bi-weekly in SQL

RBarryYoung (12/29/2008)
Matt Miller (12/29/2008)
Sorry to say - it's coming.... ^%%$#@$^%&* semicolons will eventually be required on all SQL statements. You can thank the ANSI board for that one. ...
--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)

December 29, 2008 at 5:56 pm

#918683
RE: Looking Forward

Matt Miller (12/29/2008)
Matt Miller (12/29/2008)
Jeff Moden (12/26/2008)
Steve Jones - Editor (12/26/2008)
Congrats!
Hey, pick up running as a new vice, that's what I did 🙂
http://amileaday.blogspot.com/
Just bought a nice new Calypso Cruiser (bicycle)......
--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)

December 29, 2008 at 5:52 pm

#918682
RE: Changing Taxonomy

RBarryYoung (12/29/2008)
For what it's worth, I think that one exercise that we should all try is to seriously consider what good the forum Taxonomy/Structure truly does for each of us...
--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)

December 29, 2008 at 5:43 pm

#918681
RE: Multi-column primary keys

Dang... sorry Grant... wasn't directed at you. It was directed at folks that somehow think it's OK in any way, shape, or form, to have unecrypted SSN's 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)

December 29, 2008 at 6:36 am

#918361
RE: what will be the value of YEAR(GETDATE()) + MONTH(GETDATE()) + DAY(GETDATE()))

Just so you know... storing dates in a database like that is a form of "Death by SQL"... it will bite you sometime in the future.
The only reason you should...
--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)

December 29, 2008 at 5:39 am

#918326
RE: Generating random 6 digit numbers

For the record, here's how I'd do it... very very fast because there's only 1 conversion and the rest is all integer math...
SELECT ABS(CHECKSUM(NEWID()))%900000 + 100000
--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)

December 29, 2008 at 5:31 am

#918320
RE: Generating random 6 digit numbers

I wouldn't use RAND() to generate the random number because if more than one row is returned in a given Select that uses it, ALL of the supposedly random numbers...
--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)

December 29, 2008 at 5:28 am

#918318

Viewing 15 posts - 46,321 through 46,335 (of 59,095 total)