Jeff Moden

Forum Replies Created

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

RE: disabled component to install

Lowell (10/28/2008)
aw come on, you know what i mean...Dev is limited to a max of 10 connections, instead of limited only by memory in the full version, a couple...
--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 9:13 pm

#891010
RE: Organizations With No DBAs

Heh... then I'm about to make you incredibly jealous... we're phasing out the Oracle side of the house in my shop. I've died and gone to heaven! 🙂
--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 8:57 pm

#891006
RE: Assigning current of _Cursor to local @variable

J (10/28/2008)
Using "INDEX(0)" is a later manifestation of the code... don't need to know the name of the clustered index that way and that allows you to easily use 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)

October 28, 2008 at 8:14 pm

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

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