Jeff Moden

Forum Replies Created

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

RE: disabled component to install

Lowell (10/28/2008)
compatiblility in that case means it won't fail on install...it'll install the tools no problem.
but as you've noticed it will not install everything. That is by design.
People are 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 28, 2008 at 6:45 pm

#890984
RE: Convert Start and End Dates to Time records

No problem... thanks for taking the time to feedback, Paul. 🙂
--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 28, 2008 at 5:25 pm

#890975
RE: Updating Aging Databases

Nicely done, Phil. The last paragraph certainly sums up my sentiments.
--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 10:20 pm

#890398
RE: What SQL Statements Are Currently Executing?

Heh... and I get my butt chewed for using deprecated forms of aliased column names. 😉 I don't feel so bad, now.
--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:52 pm

#890396
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

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