Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,611 through 50,625 (of 59,091 total)

RE: Is this a mad idea?

born2bongo (5/12/2008)
It's an appealing idea, but I think it means either giving ODBC access to the user base, or someone opening the workbook and running the macro prior to delivering...
--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 12, 2008 at 8:14 pm

#814195
RE: How do I get rid of this correlated sub-query and avoid the RBAR?

Kinda what I was getting at but couldn't do so in my coffee deprived state... thanks, Gus.
--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 12, 2008 at 8:12 pm

#814194
RE: Convert ASCII to time format

Peso (5/12/2008)
They were not using Windows, right?
I don't think : and ? are valid characters for a Windows filename.
HourCharASCII
--------------
0- 1048
1- 2159
2- 3250
3- 4351
4- 5452
5-...
--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 12, 2008 at 8:10 pm

#814193
RE: How do you handle la arge amount of characters?

It would appear that you're trying to write everything as a single line using SP_OA... instead of trying to jamb everything into a single line of text, why not continue...
--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 12, 2008 at 8:02 pm

#814191
RE: How do you handle la arge amount of characters?

karthikeyan (5/12/2008)
Jeff,
Just i am thinking, will Tally table be a good replacement for this cursor ?
Hi Karthik,
I could be wrong, but I'm pretty sure the answer is "No"....
--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 12, 2008 at 7:56 pm

#814189
RE: SQL Query Tuning

GSquared (5/12/2008)
Jeff, there's a reference to the location table in the Where clause, "WHERE t2.Location='PRK'".
Sharul, the first thing I'd do for performance, is get rid of the conversion functions in...
--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 12, 2008 at 7:46 pm

#814186
RE: null or not exists

Jeff Moden (5/12/2008)
How many rows are being output by the query? Also, are you outputing the query to the screen? If so, why?
Still haven't answered the question above...
--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 12, 2008 at 7:39 pm

#814183
RE: Convert Text to varchar

I know it sounds strange, but the first thing I'd try is dropping and recreating the function.
--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 12, 2008 at 7:37 pm

#814182
RE: Putting all your data in one column of one table

Matt Miller (5/12/2008)
Jeff Moden (5/12/2008)
Instead of bailing from the company, you have a huge opportunity... set up a multi-million row test and show them why it's a bad idea. ...
--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 12, 2008 at 7:26 pm

#814180
RE: How do I get rid of this correlated sub-query and avoid the RBAR?

RyanRandall (5/12/2008)
Jeff Moden (5/12/2008)
Heh... not my blog, Ryan. I think that's Jeff Smith's, but I'm not sure.
LOL - yes I know it's not your blog. I guess you missed...
--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 12, 2008 at 6:37 am

#813736
RE: Row_Number and Union query

ahsansharjeel (5/12/2008)
Your Solution is here, Please change the SELECT Queries with your Query
SELECT * , ROW_NUMBER() OVER(ORDER BY ID) AS MY_ROW_NUM FROM
(
SELECT ID, FirstName, LastName, JoinDate FROM Table1
UNION
SELECT ID, FirstName,...
--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 12, 2008 at 6:34 am

#813733
RE: Putting all your data in one column of one table

Instead of bailing from the company, you have a huge opportunity... set up a multi-million row test and show them why it's a bad idea. Challenge those that support...
--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 12, 2008 at 6:26 am

#813729
RE: How do I get rid of this correlated sub-query and avoid the RBAR?

RyanRandall (5/12/2008)
Jeff Moden (5/12/2008)
Isn't CROSS APPLY just another name for "correlated sub-query"?
😛
It sure is, but if it's the fastest method, who cares? 🙂
It's something else to try, anyway, and I'm...
--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 12, 2008 at 6:23 am

#813726
RE: How do you handle la arge amount of characters?

How did you intend to place the results in a file? Also, can you use xp_CmdShell or not?
--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 12, 2008 at 6:16 am

#813720
RE: Convert ASCII to time format

AT&T used to have whacky date/time codes like this so they could fit date/time in 8.3 file names.
--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 12, 2008 at 5:38 am

#813704

Viewing 15 posts - 50,611 through 50,625 (of 59,091 total)