Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,071 through 53,085 (of 59,089 total)

RE: Myths

Yeaup, we all need rules... but to keep from becoming a non-thinking "SQL Clone", ya gotta read about the "5 Monkeys Experiment"... you'll see what I mean... 😉
http://www.lanebaldwin.com/v03I8.htm
Dunno if there's...
--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)

January 7, 2008 at 10:07 pm

#765564
RE: Check if temporary table exists or not?

If you use the extra parameter I posted in 2k or 2k5, it will also...
--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)

January 7, 2008 at 5:32 pm

#765548
RE: Check if temporary table exists or not?

Michael Valentine Jones (1/7/2008)
Your checks are not valid for SQL 7.0 and 2000. (This is the SQL Server 7,2000 T-SQL forum)
Maybe not in SQL Server 7 because of 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)

January 7, 2008 at 5:22 pm

#765546
RE: Slow Query and High IO

Yes... and sorry I missed that... I verified that Store_key was the same in both tables and didn't even look Orig_Store_key.
--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)

January 7, 2008 at 8:44 am

#765376
RE: Mathematical T-SQL

That's pretty cool... Thanks, Rob...
--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)

January 7, 2008 at 6:30 am

#765307
RE: SQL SERVER 2005 vs ORACLE 10G

Carl Federl (1/7/2008)
"f I am understanding what you wrote then the solution is truly laughable from a performance (and coding) standpoint!! You have to create two tables and populate them...
--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)

January 7, 2008 at 6:26 am

#765305
RE: SQL SERVER 2005 vs ORACLE 10G

Andrew Whettam (1/6/2008)
Oracle objects can be given Mixed Case names by using quotes when creating them e.g. "MyTableName". This seems to be frowned upon in the Oracle community -...
--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)

January 7, 2008 at 6:24 am

#765304
RE: SQL SERVER 2005 vs ORACLE 10G

No, no... it's not that... in SQL Server, you have a Deleted and Inserted table... in Oracle, they are not tables... they are essentially variables that contain 1 row... you...
--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)

January 7, 2008 at 6:12 am

#765299
RE: Naming Conventions Help

Heh... I'm confused... I recommended generic names, not DATABASE_MODULE_TABLE...
--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)

January 7, 2008 at 5:41 am

#765287
RE: which scripting language does sqlservercentral uses ?

I see that... and it still comes out at just "which scripting language does...".
The other thing is, you should never rely just on the title of a post to convey...
--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)

January 7, 2008 at 5:35 am

#765286
RE: Check if temporary table exists or not?

karthikeyan (1/7/2008)
Concur...
2. Same for permanent tables...
IF OBJECT_ID('dbo.permanenttablename','U') IS NOT NULL PRINT 'Table Exists' ELSE PRINT 'Table Not Exists'
...
--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)

January 7, 2008 at 5:24 am

#765282
RE: Mathematical T-SQL

Show us how, Rob...
--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)

January 7, 2008 at 5:18 am

#765279
RE: SQL SERVER 2005 vs ORACLE 10G

TheSQLGuru (1/6/2008)
Does Oracle really not have temporary tables, or is it just non-performant to use them??
Oracle does have "temp tables" but even though different sessions cannot see the data 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)

January 6, 2008 at 9:22 am

#765155
RE: SQL SERVER 2005 vs ORACLE 10G

Andrew Whettam (1/6/2008)
Jeff, you have made some good points, but pardon me for thinking it comes across as just a teensy bit anti Oracle!
Absolutely incorrect, Andrew... I'm a LOT anti-Oracle!...
--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)

January 6, 2008 at 8:44 am

#765151
RE: Running update Stored Procedure from VBS

Heh... that's exactly what sp_MSForEachDatabase does... it's nothing but a huge cursor...
--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)

January 6, 2008 at 8:32 am

#765150

Viewing 15 posts - 53,071 through 53,085 (of 59,089 total)