Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,991 through 43,005 (of 59,102 total)

RE: creating table and copying fields

novice82 (7/16/2009)
Thanks Jack.
I found a solution from the oracle forum.
Cool! Tell us what the solution is, please.
--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 17, 2009 at 1:49 pm

#1026424
RE: 'replacing' values in a select statement

mmunson (7/16/2009)
Hi GSquared! 🙂
I could.... but I was hoping to get around that because I would need approval to create a new table. And then heads...
--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 17, 2009 at 1:48 pm

#1026420
RE: Pivot query problem - can this be done ?

Ya beat me to it. Thanks for the "plug", Allister. 🙂
--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 17, 2009 at 10:52 am

#1026323
RE: UNPIVOT using T-SQL

Mansfield (7/16/2009)
Since you have done the pivot the hard way, here's the equivalent to unpivot...
Before you go calling it the "hard way", you might want to read up on 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 17, 2009 at 10:50 am

#1026322
RE: Earch Table Size

Heh... I know where this one came from because it avoids RBAR 😉
--===== "Space Used on Steroids"
-- If "UnusedKB" is negative, it's likely you need...
--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 17, 2009 at 10:29 am

#1026310
RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

The following takes about the same time as the sp_MSForEachTable and has the distinct advantage of returning the row counts as a sortable single result set instead of a result...
--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 17, 2009 at 9:24 am

#1026254
RE: Advice for the Unemployed

Doc (7/16/2009)
One little thing I would add to this list -- get your own blog or a web site and write, let the Employers see that you are interested into...
--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 17, 2009 at 5:23 am

#1026093
RE: SQL While Loop

Roger Abram (7/16/2009)
It worked out just fine and I really want to thank you for your help!
Rog
That's cool, but there're two ways to do things... the way that works and...
--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 17, 2009 at 5:02 am

#1026085
RE: deleting dupliacte records from one table

desktopteam (7/16/2009)
I agreee didn't want to mess with any of the standard tables they may have. It's something that has been appering over time, with over 15000 computers in our...
--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 17, 2009 at 4:51 am

#1026082
RE: deleting dupliacte records from one table

desktopteam (7/16/2009)
Hi,
I am pretty new to sql in terms of updating or deleting databases. we currently use Symatnec antivirus and are noticing an increase in dupliacte computer names but they...
--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 16, 2009 at 11:40 am

#1025813
RE: Date functions causing queries to take longer

Heh... nah... you and I both know... "It Depends". Test everything... leave little to chance.
--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 16, 2009 at 11:26 am

#1025807
RE: Naming Conventions Standards

deewiley (7/16/2009)
When I saw this question I had to add some information on how we do this in our shop. We do not generayy use prefixes for tables or views...
--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 16, 2009 at 10:43 am

#1025787
RE: Date functions causing queries to take longer

Grant Fritchey (7/16/2009)
TheSQLGuru (7/16/2009)
I think we will have to disagree on this one. I estimate that 90+% of the time a user has a query with a date range...
--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 16, 2009 at 10:14 am

#1025770
RE: Is This The Best Way to Remove Duplicate Records ?

Heh... the devil's in the data. Thanks for the feedback. 🙂
--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 16, 2009 at 10:01 am

#1025758
RE: Is This The Best Way to Remove Duplicate Records ?

ifila (7/16/2009)
I found the issue. It was NOT the delete SQL code !
Thanks
Two way street here... what was the problem you found and how did you fix 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 16, 2009 at 8:22 am

#1025687

Viewing 15 posts - 42,991 through 43,005 (of 59,102 total)