Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,316 through 54,330 (of 59,089 total)

RE: how to remove numbers from strings?

We don't have a single report that takes longer than 30 seconds to retrieve (typically they're in the 0-2 second range), thanks to some careful marting...
...Once I've gotten the 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)

November 6, 2007 at 10:49 am

#748775
RE: distinct keyword

karthikeyan (11/6/2007)
If we take any performance related article or document, definetely it highlight the below point ' don't use distinct keyword in your query.It decrease your performance'.
Thats why i posted...
--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 6, 2007 at 10:04 am

#748761
RE: how to remove numbers from strings?

David McFarland (11/6/2007)
Do you use covering indexes to optimize all of your reports? I don't, as I don't have the terabytes of extra storage I'd need to do so. 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)

November 6, 2007 at 9:44 am

#748750
RE: Difference between Work Tables and TempTables

karthikeyan (11/6/2007)
I agreed all your experts answer. But in memory level where worktable will be stored ?
For example if i create # table then it will be stored in TempDatabase.
But...
--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 6, 2007 at 8:35 am

#748711
RE: Inserting random order of numbers between defined range

Matt Miller (11/6/2007)
Well - the test was for 3,540,000 records, and it ran in 34 secs...
Perfect... I'm at work right now... I'll try to set something up tonight... thanks, Matt!
--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 6, 2007 at 8:31 am

#748707
RE: bulkinsert need idea/help

Sure, John... kind of... hope you don't mind a bit of psuedo code because I don't ever use DTS except for ad-hoc transfers...
Create two identical tables to hold the 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)

November 6, 2007 at 8:25 am

#748699
RE: Inserting random order of numbers between defined range

Kewl! Anyone interested in a million row duration test on this? 😀 I'd need some help 'cause I don't have 2k5...
--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 6, 2007 at 8:11 am

#748686
RE: Does the location of the AND part of a join clause affect the data returned

Thanks, Antares!
--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 6, 2007 at 8:06 am

#748680
RE: Check a table exist and Delete

IF OBJECT_ID('sometablename,'U') IS NOT NULL
DROP TABLE sometablename
Lookup OBJECT_ID in Books Online... it's worth the read. 😉
--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 6, 2007 at 7:37 am

#748663
RE: Speeding up query in a VBScript file

Heh... you've basically pulled the wings off of any chance of performance by using outside code to do something inside the database... you said that you want to import 26MB...
--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 6, 2007 at 7:36 am

#748662
RE: maximum row size exceeds the allowed maximum of 8060 bytes

Heh... Michael, thank you for the high compliment! Made my day... 🙂
o1000, Michael is correct... what you want to do just seems tremedously odd and I want to see...
--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 6, 2007 at 7:20 am

#748648
RE: Does the location of the AND part of a join clause affect the data returned

Heh... if you're worried that it will affect the data returned, you need to test!
And the position of the AND somecol = someval code does make a difference...
--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 6, 2007 at 7:14 am

#748645
RE: Inserting random order of numbers between defined range

Since the numbers you want are 1 to 354 and not 0 to 353, you'll probably have to change John's code just a bit...
UPDATE Random_region_lookup_table
SET Place_key = Entry_key%354
... should probably...
--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 6, 2007 at 7:09 am

#748640
RE: help need writing a query

This is a fairly common request and it always amazes me that folks would have two identical tables and be worried about synching up their contents. The only time...
--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 6, 2007 at 6:55 am

#748633
RE: Table Hints

Catcha,
Someone tried to force some serious tuning on that query... the FORCE ORDER tells the optimizer to only consider the tables in the same order as they appear in 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)

November 6, 2007 at 6:48 am

#748630

Viewing 15 posts - 54,316 through 54,330 (of 59,089 total)