Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,531 through 34,545 (of 59,099 total)

RE: SQL Query taking long time

TheSQLGuru (3/21/2011)
Simple solution: do ALL of your math in a SINGLE PASS over the table. Do not have umpteen hits on the table (views or no views).
Gosh, Kevin. ...
--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)

March 22, 2011 at 8:25 pm

#1302255
RE: Searching Functions, Procedures and Tables

FredS-1001785 (3/21/2011)
The original problem I was trying to solve was that I wanted to make sure that I was dropping temporary tables after using them. Hence, searching for '#'...
--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)

March 22, 2011 at 8:22 pm

#1302254
RE: Are the posted questions getting worse?

Brandie Tarvin (3/22/2011)
<groan> Why oh why do the same "bad" solutions keep popping up when there are tons and tons and tons of articles telling people why it's a bad...
--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)

March 22, 2011 at 8:11 pm

#1302252
RE: Looping through a directory for sub-directories' names

I usually keep my ETL machines separate and isolated. They are not public facing and they're normally setup to only "pull" data from various sites/providers. Even then, I'll...
--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)

March 22, 2011 at 8:02 pm

#1302248
RE: Looking for Elegant Efficient T-SQL Code

P Jones (3/22/2011)
I'd rather cobble it together myself though, so I really understand it, especially when it needs modifying a year down the line!.
Can't ask for a better attitude than...
--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)

March 22, 2011 at 4:19 pm

#1302212
RE: Looping through a directory for sub-directories' names

irfanshaukat999 (3/22/2011)
Hi
Many thakns for your reply:)
yes I can use xp_CmdShell or sp_OACreate.
No I am not restricted to T-SQL solution. Actually I dnt know much about SSIS. I did serach about...
--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)

March 22, 2011 at 4:18 pm

#1302211
RE: Covering Index for a view.

I wouldn't use a view for this. If I had to continue with an Adjaceny List, I'd create two UDF's as iTVF's (Inline Table Valued Functions) so I could...
--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)

March 22, 2011 at 6:57 am

#1301844
RE: Looking for Elegant Efficient T-SQL Code

I have to agree with Dixie... although my tendency is cringe at the mere mention of "Cursor" or "While Loop" and I really do understand the "code artist" in 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)

March 22, 2011 at 6:52 am

#1301840
RE: Looping through a directory for sub-directories' names

Can you use xp_CmdShell or sp_OACreate?
Also, considering the good information others have posted about how to do this with SSIS, are you sure you want a T-SQL only solution?
--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)

March 22, 2011 at 6:06 am

#1301817
RE: Inserting Datetime field into a update statement to update a nvarchar field

Good. As a side bar, though, I wouldn't store the calculated column as a VARCHAR(MAX) because the full message is only required at display 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)

March 21, 2011 at 4:44 pm

#1301637
RE: Insert random numbers into a column

Heh... but Tiger Lilly just isn't a Rose. 😛
--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)

March 21, 2011 at 4:22 pm

#1301630
RE: Insert random numbers into a column

Rao.V (3/21/2011)
you also can use option called "SEQUENCE" for that column so that it generates number automatically when u insert a new row
Rao.V (3/21/2011)
yes i mean identity
???:blink: 😛
--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)

March 21, 2011 at 11:45 am

#1301452
RE: Group by

GSquared (3/21/2011)
We're going to have to agree to disagree on this one.
Heh... agreed. 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)

March 21, 2011 at 11:42 am

#1301451
RE: Change header names dynamically in the tabular report SSIS 2008

I don't use SSRS but I have people that do nearby. What they do under such cirumstances is they get the data from a stored procedure and they typically...
--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)

March 20, 2011 at 9:36 pm

#1301103
RE: Are there tools to capture query cost in dev and test environment?

I certainly do use the execution plans to give me an idea of where potential trouble spots are concerned especially when it comes to index usage and possible many-to-many joins...
--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)

March 20, 2011 at 9:31 pm

#1301102

Viewing 15 posts - 34,531 through 34,545 (of 59,099 total)