Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,011 through 53,025 (of 59,072 total)

RE: SQL SERVER 2005 vs ORACLE 10G

JohnG (1/8/2008)
Definately NOT true. Oracle stores two digits per byte (plus an overhead byte or two for sign, etc.) in a varying storage model. Equivalent to the new...
--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 8, 2008 at 9:57 pm

#766014
RE: Converting text to varchar data types

Then, I don't know...
--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 8, 2008 at 9:51 pm

#766013
RE: Converting text to varchar data types

sp_SpaceUsed may not tell the whole story unless you include a second parameter... see BOL for more info but here's the basic syntax...
Syntax
sp_spaceused [[@objname =] 'objname']
...
--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 8, 2008 at 9:01 pm

#766001
RE: SQL Defrag

Well..... kinda... DBCC INDEXDEFRAG will report back once every 5 minutes with a % complete... so you could start a run and get the % complete... the math is pretty...
--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 8, 2008 at 8:54 pm

#765999
RE: Bulk Insert vs Flat File Connection Mng

Heh... neither... use BULK INSERT from T-SQL 😉
--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 8, 2008 at 8:00 pm

#765993
RE: Problem in Query

Ahmad Osama (1/7/2008)
Hi
Actualy I have used distinct im my query thus i can't use roll up
Change it... it's worth it in terms of performance. 😉
--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 8, 2008 at 7:58 pm

#765992
RE: Critical issue need suggestion

Would you mind posting some data so we can help you accurately? Please see the following article for how to get really good answers quickly... seriously... read the article......
--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 8, 2008 at 7:56 pm

#765991
RE: Using Parameters with Stored Procedures

I know it's an older article, but I gotta say, nicely done, Kathi! Great examples for folks that don't know.
--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 8, 2008 at 7:48 pm

#765989
RE: varchar datatype not writing all data to table

Interesting problem and thanks for the feed back...
Now, what's an "SQLDataAdapter"??? :blink:
--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 8, 2008 at 7:31 pm

#765986
RE: Which one to compare 1'st string or integer in a where clause for better performance

It's great code! But only if you're inserting 1 row at a time from the GUI. 😉
--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 8, 2008 at 7:28 pm

#765985
RE: Why is log file for tempdb filling up?

Chaohua Wang (10/5/2006)
This error may not cause your system down. The database tempdb is automatically shrunk normally. There is an "bug" here. We may get an error message if 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)

January 8, 2008 at 7:19 pm

#765983
RE: how to find the parent

The numbering system is flawed to begin with... 003.31 should not be the child of 003.3... they're both at the same "level" in legal numbering. If 003.31 is 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 8, 2008 at 7:14 pm

#765981
RE: Contracting question - Left old company, but still provide support.

Michael is quite correct... if the 1099's end up becoming your main income or they exceed certain amounts, you MUST pay estimated quarterly taxes... do consult a good accountant! ...
--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 8, 2008 at 7:08 pm

#765979
RE: Identity insertion and updation

Kishore.P (1/8/2008)
use sp_msforeachtable to drop the identity column in all tables.
Yup... easy to do if no foreign keys... of course, if these IDENTITY columns are being used as the PK...
--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 8, 2008 at 7:05 pm

#765978
RE: Identity insertion and updation

balaji_rcs (12/24/2007)
Hi,
Thanks for your reply. I want to remove the identity properties in the table totally. i.e I want to remove the identity while update also.
Yeah, uh-huh... what...
--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 8, 2008 at 7:02 pm

#765977

Viewing 15 posts - 53,011 through 53,025 (of 59,072 total)