Jeff Moden

Forum Replies Created

Viewing 15 posts - 58,276 through 58,290 (of 59,099 total)

RE: Cursors? Variable Tables and Temp Tables?

Sorry, Mirko... I missed your post from way back in February...
You wrote "I don't need statistics on temp tables, because I usually know enough about their structure and data that...
--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)

May 11, 2006 at 7:46 pm

#637425
RE: Loading a Series of Flat Files

Andy,
THANK YOU, THANK YOU, THANK YOU!!!!!
In the bowels of your code, I finally found what I've not been able to find anywhere else... a replacement for using xp_CmdShell (security risk)...
--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)

May 9, 2006 at 1:18 pm

#636864
RE: In SQL Server is there any Alternative of Oracle ROWID

Interesting...
I may have a method that might even beat ASP.Net for performance but I need to know, does your table have an auto-numbering IDENTITY column? And, it doesn't matter if...
--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)

May 8, 2006 at 9:28 pm

#636652
RE: small but dificult ms sql select count, group by, top @var

Too bad... I think this was homework and didn't see where Paul tried...
--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)

May 7, 2006 at 4:46 pm

#636438
RE: INSERT INTO returns the IDENTITY value

I don't believe it's returning the the latest identity value unless someone put a trigger on the table that does so. Check to see if there are any triggers on...
--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)

May 5, 2006 at 9:40 pm

#636392
RE: Extracting Numeric values from addresses

Sorry Kenneth... didn't exactly return the favor.
My Tally table is 9999 rows, single "n" column is INT with a Clustered PK.
The million row test table is made up of 6...
--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)

May 5, 2006 at 7:19 am

#636210
RE: Extracting Numeric values from addresses

Yep... I'd test it... "it depends" and the age old adage of "one measurement is worth a thousand speculations" still holds true. It's especially true in the world of multi-processors......
--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)

May 5, 2006 at 7:05 am

#636198
RE: Date issue in Query

The following is wrong because it leaves out one entire second of the day...
BETWEEN '2006-05-01 00:00:00.000' AND '2006-05-01 23:59:59.000'
...depending on the source of the data, there could be thousands...
--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)

May 4, 2006 at 10:12 pm

#636140
RE: Extracting Numeric values from addresses

The reason I ask is because I DO have a Clustered Primary Key on the N column of my Tally table and here's the results I got from the 3...
--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)

May 4, 2006 at 9:00 pm

#636131
RE: Extracting Numeric values from addresses

Kenneth,
Does your Tally table have a Primary 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)

May 4, 2006 at 8:09 pm

#636128
RE: Extracting Numeric values from addresses

Jeff,
Great use of a Tally/Numbers table... is more than twice as fast as the WHILE LOOP method...
Shifting gears.... in your code, change this...
select @address = '1300 teseter 234'
...to this...
select @address...
--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)

May 3, 2006 at 9:05 pm

#635826
RE: Cell Phone GPS tracking

Nope, no experience with GPS phone providers here, either. But what you have planned not only sounds very feasible, it sounds like a hell of a lot of fun, too! ...
--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)

May 3, 2006 at 7:10 am

#635587
RE: How can you tell if a file has finished downloading?

Here's the example xp_CmdShell code I will sometimes use... note that I always include the hardcoded DOS command DIR and I always include the path in double quotes to help...
--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)

May 3, 2006 at 7:05 am

#635581
RE: How can you tell if a file has finished downloading?

Not sure exactly how you would do it in DTS but I'm thinking that if you built some error logic around the fact that the files are empty and that...
--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)

May 3, 2006 at 6:56 am

#635575
RE: Hierarchical data in resultset

Another country hear from! Also, very neat, David. Interesting use of SIGN as a "lump detector".
Juliano... has one of these 3 solutions provided you with the answer you needed? 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)

May 3, 2006 at 6:50 am

#635571

Viewing 15 posts - 58,276 through 58,290 (of 59,099 total)