Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,196 through 54,210 (of 59,072 total)

RE: Parallel Processing of Large Volume ETL Jobs

Thanks for the rowcount and line size... I've got an experiment or two to do... I'll be back...
--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)

November 10, 2007 at 7:37 am

#750051
RE: Recursive query for a Bill of Materials table

Matt Miller (11/9/2007)
If it's a process THIS expensive, you should consider making this a permanent table. Meaning - keep the existing table just as it is, and have another...
--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)

November 9, 2007 at 10:37 pm

#750037
RE: Select Statements in Stored Procedure gets Error converting data type DBTYPE_DBTIMESTAMP to datetime.

I think you're going to find that the problem is a bad date in the Oracle view. Check for any dates there that are outside the range of '17530101'...
--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)

November 9, 2007 at 9:23 pm

#750032
RE: insert

Not true, Sergiy... and if you look, although it works, UPDATE tablealias isn't even listed in 2k BOL...
Syntax
UPDATE
{
...
--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)

November 9, 2007 at 5:55 pm

#750021
RE: Creating a customized identity column

Heh... or, you could just shoot yourself in the head now and save on the anticipation 😀
--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)

November 9, 2007 at 5:23 pm

#750018
RE: Add 3 columns into another column

Heh... no problem there... most people don't even know it exists! 😛
Thanks for the feedback, Bruce.
--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)

November 9, 2007 at 5:13 pm

#750017
RE: is there any difference between != and <>

Heh... also notice that the != gets converted to a <> in the query plan output 😉
--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)

November 9, 2007 at 5:07 pm

#750015
RE: Best practice for applying set based updates

Matt is correct... even if you're using SSIS, 2000 rows should be processed in the proverbial blink of an eye... even faster if you use Bulk Insert, instead 😉 ...
--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)

November 9, 2007 at 5:03 pm

#750014
RE: Querying remote database

SQLcommando (11/9/2007)
I'm not using the product "MYSQL" ... I just happened to name my server that. I'm using MSSQL 2000. Sorry for the misleading server name.
Heh......
--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)

November 9, 2007 at 4:53 pm

#750013
RE: Script

Susan S (11/8/2007)
I mean the above script will produce.
Name of database
Logical file name of .MDF
.Mdf File location drive
Size of the file in MB
Physical file location(full path of .mdf file)
Maxsize
Growth
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)

November 9, 2007 at 4:48 pm

#750012
RE: Transactions

Correct... for more info, lookup "table hints, locking hints" 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)

November 9, 2007 at 8:25 am

#749878
RE: Case Stmt with multiple "when" params and one "then" stmt

Ummm... rather than struggling with syntax, do you know what Books Online is? Comes free with SQL Server and, although it sometimes takes a bit to find what you're...
--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)

November 9, 2007 at 8:22 am

#749875
RE: Most efficient way to get data from custom software into SQL server?

Do you have control over what the custom app does? For example, could you modify the custom app to write to a table in the server?
Otherwise, using BULK INSERT...
--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)

November 9, 2007 at 8:20 am

#749874
RE: Recursive query for a Bill of Materials table

I don't know what is wrong, but I can neither open or save the attachement.
However, my recommendation was to look at "Expanding Hierarchies" in Books Online... that recommendation still stands......
--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)

November 9, 2007 at 8:05 am

#749861
RE: Import

I guess that means they're on the same server... so...
1) where can i have a predefined table with DBName,EMail as fields in it. either in each 5 DB's or just...
--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)

November 9, 2007 at 7:54 am

#749854

Viewing 15 posts - 54,196 through 54,210 (of 59,072 total)