Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,551 through 47,565 (of 59,095 total)

RE: SQL Data Counter

Sure... read the very message of mine that you quoted... lookup IDENTITY in Books Online.
--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)

October 27, 2008 at 9:42 pm

#890394
RE: How to post comments on externally linked articles

Yeah... but they wouldn't like my title for it... "Ready, Aim, Fire all Pork Chops!" 😀
--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)

October 27, 2008 at 9:39 pm

#890393
RE: disabled component to install

lindaotero (10/27/2008)
Hi I have Windows XP professional version 2002 SP2
and when tryig to install sql 2005 "Standard" edition, all the options are gray ...(disable)... the oly one I can install...
--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)

October 27, 2008 at 9:37 pm

#890392
RE: How to post comments on externally linked articles

Oh, my bad... low levels of Caffeine. You're correct, not a triangular join. Read too quickly. Sorry, Lynn.
--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)

October 27, 2008 at 9:19 pm

#890387
RE: SQL-Server 2005: Change Ordinal Column Position

Jeffrey Williams (10/27/2008)
In fact, using the above - the order of the columns returned is different. Why?
Heh... everybody say it with me... "Without Order By, the order of columns...
--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)

October 27, 2008 at 8:55 pm

#890380
RE: SQL-Server 2005: Change Ordinal Column Position

Lynn Pettis (10/27/2008)
True, but when you script the create statement or edit the table in the designer in SSMS, the columns are listed in the order you defined them 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)

October 27, 2008 at 8:49 pm

#890377
RE: SQL-Server 2005: Change Ordinal Column Position

Garadin (10/27/2008)
Fair enough. It was a pretty bold statement that may not be 100% accurate. It was in response to this:
Yes, that's all right, but if you make...
--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)

October 27, 2008 at 8:47 pm

#890376
RE: SQL DB Performance

Isn't there a canned report you can get for the "top 10" longest queries just by right clicking on the database or server?
--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)

October 27, 2008 at 8:24 pm

#890373
RE: SQL Data Counter

You have to plan on the unexpected... what happens if, someday, there's more than one operator? And what happens if you have to do a "bulk" insert of more...
--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)

October 27, 2008 at 8:22 pm

#890372
RE: convert a varchar(4000) to a int !?

smunson (10/27/2008)
Jeff,
Thanks for acknowledging. The only reason I chose to use a loop is because I just didn't have time to go look up the technique that selects...
--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)

October 27, 2008 at 8:16 pm

#890371
RE: Correlated Query

The problem with even allowing such code to exist is that people will take any shortcut they can without regard to future performance. If they run across such 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)

October 27, 2008 at 6:52 pm

#890355
RE: Need Help with Query

You don't need to include TransDate in that... just wasted IO and clock cycles. 🙂
--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)

October 27, 2008 at 6:45 pm

#890354
RE: SQL-Server 2005: Change Ordinal Column Position

Garadin (10/27/2008)
What you're basically asking for with this change is a script to promote laziness and inefficient coding practices that can cause all sorts of issues down the line.
I've agreed...
--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)

October 27, 2008 at 6:40 pm

#890353
RE: How to post comments on externally linked articles

Lynn Pettis (10/27/2008)
Jeff Moden (10/27/2008)
Man, would I like to be able to comment here on external articles so I don't have to sign up for every forum that has 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)

October 27, 2008 at 6:35 pm

#890352
RE: small query help me out

Chris (10/27/2008)
Jeff...thkz for the response could plz clarify this....
so how should i consider it .....
select isnumeric(order_number+'.do') from tbl1..
is this the syntax...
i dont understand this query
SELECT ISNUMERIC('3D2'+'.d0'), ISNUMERIC('3E2'+'.d0'), ISNUMERIC('1,000'+'.d0'), ISNUMERIC(CHAR(13)+'.d0'), ISNUMERIC(CHAR(9)+'.d0')...
--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)

October 27, 2008 at 6:33 pm

#890351

Viewing 15 posts - 47,551 through 47,565 (of 59,095 total)