Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,426 through 37,440 (of 59,098 total)

RE: Two Useful Hierarchy Functions

Jack-408956 (8/3/2010)
None of this "with" stuff is working for us on MSSQL 2000...
Server: Msg 156, Level 15, State 1, Procedure subordinates, Line 2
Incorrect syntax near the keyword 'with'.
Is it 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)

August 3, 2010 at 7:09 am

#1201489
RE: Two Useful Hierarchy Functions

Jack-408956 (8/3/2010)
None of this "with" stuff is working for us on MSSQL 2000...
Server: Msg 156, Level 15, State 1, Procedure subordinates, Line 2
Incorrect syntax near the keyword 'with'.
Is it 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)

August 3, 2010 at 7:03 am

#1201486
RE: When not to use a temporary table?

velsy.thomas (8/2/2010)
Hi All,
Iam using a global temporary table and iam facing performance issue.
Please let me know how to solve the performance issue with teh global temporary table.
Please help me..
Viva
I second...
--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)

August 3, 2010 at 6:55 am

#1201480
RE: Tally Table Uses - Part I

Smendle (8/2/2010)
The real answer here is that it doesn't really matter if a Tally table contains 10,000 rows or a million rows. It it's used properly and if it has...
--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)

August 3, 2010 at 6:50 am

#1201476
RE: Deterministic UDF slower than Non-Deterministic?

dant12 (8/2/2010)
yeah sure ill send you a .csv if your willing to play with it, but i wouldnt bother so much. you already gave me lots of ideas with both...
--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)

August 3, 2010 at 6:38 am

#1201472
RE: TSQL or SSIS

A "staging table" can be a real table (usually not recommended but ok sometimes, won't help you with privs, though), a Temp Table, a Global Temp Table (NOT RECOMMENDED), or...
--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)

August 2, 2010 at 5:12 pm

#1201307
RE: Tally Table Uses - Part I

alen teplitsky (8/2/2010)
i always prefer CTE's and table variables. i've had a few issues with temp tables where the query ran but for some reason the temp table doesn't get...
--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)

August 2, 2010 at 5:07 pm

#1201306
RE: Tally Table Uses - Part I

Stefan Krzywicki (8/2/2010)
Smendle (8/2/2010)
Notice your taking 'Fisc' information and from the tally table determining the Y W D information. But what if your tally table was just Y W...
--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)

August 2, 2010 at 5:03 pm

#1201305
RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

Ah... changed my mind. See the next post.
--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)

August 2, 2010 at 4:57 pm

#1201304
RE: how to update millions of records quickly........

ssis learner__ (8/2/2010)
Thanks a lot...
@jeff..
but by loop I can divide my 50 million into 10 parts and update them one by one ...Is that right?
@Bhuvnesh
I have never used batches...how...
--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)

August 2, 2010 at 4:54 pm

#1201303
RE: Deterministic UDF slower than Non-Deterministic?

dant12 (8/2/2010)
dunno whats wrong with your function but it performed way slower than the old one
Heh... dunno what's wrong with your machine, db, or table, but the function I wrote...
--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)

August 2, 2010 at 4:51 pm

#1201302
RE: Snoops

Steve Jones - Editor (8/2/2010)
Dimbulbz (8/2/2010)
... I don't know where you have taken your sample from, but that is scary and perhaps I need to do my own polling...
--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)

August 2, 2010 at 4:40 pm

#1201299
RE: Tally Table Uses - Part I

Stefan Krzywicki (8/2/2010)
I do appreciate the suggestion, but I'm going to let it stand. I can't count the number of times I've read code or a coding technique and thought...
--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)

August 2, 2010 at 7:12 am

#1200989
RE: Are the posted questions getting worse?

Gianluca Sartori (8/2/2010)
What exactly are you americans doing at work that makes you worth all that money?
Heh... we don't get to keep all that. Most of us work 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)

August 2, 2010 at 7:07 am

#1200983
RE: TSQL or SSIS

KBSK (8/1/2010)
Jeff Moden (7/28/2010)
If the structure of the text file is known, BULK INSERT would probably be your best bet. Doesn't require ad hoc queries to be enabled.
Thank you.
I...
--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)

August 2, 2010 at 6:59 am

#1200972

Viewing 15 posts - 37,426 through 37,440 (of 59,098 total)