Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,381 through 52,395 (of 59,072 total)

RE: Performance problem... how can I prevent it?

Oh yeah... and, of course, it works just fine. But, any idea on how to make it work without being dynamic though? Seems the optimizer is making 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)

February 22, 2008 at 12:36 pm

#781220
RE: Set or Select

Edward (2/22/2008)
have a look at this
http://ryanfarley.com/blog/archive/2004/03/01/390.aspx
Hope it helps
Pretty good explanation of SET vs SELECT... horrible method of creating a split function. Use a Tally table, 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)

February 22, 2008 at 6:36 am

#781070
RE: BCP Command out/queryout Issue.

1. I just have modified my select statement a bit like iam just taking all now
means...
bcp "Select * from CurveTempDB.dbo.tLoanVectors where cusip='86359B6G1' " queryout C:\Sample.txt -T -c
for which am still...
--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)

February 22, 2008 at 6:31 am

#781065
RE: Multiple E-L tasks. Any other ways of doing it?

VALEK (2/21/2008)
I am thinking about it, but the management would argue that I am distorting/abusing the concept of ETL, SSIS and all the rest of it.
It would be great 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)

February 22, 2008 at 5:44 am

#781053
RE: CLR and UDF

Muhammad Furqan (2/21/2008)
oh man ! you are missing a point.
i know about that simple query that you hace written, but problem with me is that the "table_name" and "column_name" are...
--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)

February 22, 2008 at 5:40 am

#781051
RE: BCP Command out/queryout Issue.

Ok... first, we have to determine precisely what the problem is... correct identification of the problem will be 90% of the solution....
1. Are you still using this exact syntax?...
--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)

February 22, 2008 at 5:35 am

#781050
RE: deployment documentation

It was easy for us... we had a great junk yard dog for a DBA who said "Sure... I can keep anything out that doesn't have a signed off ticket"....
--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)

February 21, 2008 at 8:49 pm

#780945
RE: Lookup Parametrization

I'd recommend that you post the code that doesn't work along with any error messages you may receive...
--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)

February 21, 2008 at 7:56 pm

#780938
RE: deployment documentation

One more thing... the ticketing system should have the concept of "Parent Tickets" and "Projects" associated with it. Seriously, this is the only way to keep a handle 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)

February 21, 2008 at 7:12 pm

#780935
RE: deployment documentation

Eric Peterson (2/21/2008)
Does anyone have some standard forms for deployment of SQL DBs, DTS, Etc.
We need to better document user requests comming into the system and a good...
--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)

February 21, 2008 at 7:10 pm

#780934
RE: Multiple E-L tasks. Any other ways of doing it?

Gosh... can't you just make a linked server and write a proc that would maybe use a little dynamic SQL to just copy everything it sees on the linked server...
--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)

February 21, 2008 at 7:02 pm

#780933
RE: Corruption Detection Issue

Yes, you can save the result set in a table by using a kind of "back door" way using a call to OSQL....
--===== Create a temp table to hold 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)

February 21, 2008 at 6:51 pm

#780932
RE: Passing table into stored procedure

Yeah... I know, I know... thanks guys...
Sticknyn... don't let them scare you off, Man... if you know a way to pass a table variable in 2k5, you've just gotta tell...
--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)

February 21, 2008 at 6:25 pm

#780931
RE: Passing table into stored procedure

stricknyn (2/21/2008)
I can pass a table variable into a stored procedure that has a table variable as a parameter.
You can? And it works? Would you mind...
--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)

February 21, 2008 at 5:43 pm

#780924
RE: Problem with Select Top x Percent?

All I can say is, CRAP!!!!!
As pjancicka states, it works fine on 2K SP3a, and doesn't work correctly on anything after that!
Hey! Some of you MVP's...
--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)

February 21, 2008 at 5:20 pm

#780919

Viewing 15 posts - 52,381 through 52,395 (of 59,072 total)