Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,056 through 53,070 (of 59,072 total)

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
RE: help insert employee to #temp table all month

It's a "hint" on how to post data... 😛
--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 12:01 am

#765140
RE: SQL SERVER 2005 vs ORACLE 10G

Oh yeah... almost forgot... if you hate the fact that SQL Server 2000's VARCHAR only goes up to 8,000 characters and did hand-springs over SQL Server 2005's VARCHAR(MAX) so 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 5, 2008 at 11:57 pm

#765139

Viewing 15 posts - 53,056 through 53,070 (of 59,072 total)