Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,846 through 37,860 (of 59,072 total)

RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

davec-640463 (6/30/2010)
Hi MutlyP,
It also sounds like table variables could help you out here. You could possibly subset your data into table variables perfoming some of the logic you describe....
--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)

June 30, 2010 at 7:17 am

#1187045
RE: T-SQL for creating a text file with with this filename format - Month(MM)Day(dd)Year(yyyy).Log

As a sidebar, I'd use format 112 so the file names are sortable.
--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)

June 30, 2010 at 7:11 am

#1187037
RE: Problem with query on indexed computed column

Duncan Pryde (6/30/2010)
Banging my head for a while, I finally found this page, where someone suggests looking at the SET options.
Heh... I plain forgot about that possibility because we have...
--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)

June 30, 2010 at 7:06 am

#1187033
RE: Generating a Distinct Delimited List Using XML

Mike C (6/29/2010)
How's this for data? 🙂
CREATE TABLE #Role
(
RoleName VARCHAR(100)
);
GO
INSERT INTO #Role
(
RoleName
)
VALUES ('Accounting'), ('Approver'), ('Developer'), ('International Sales Manager'), ('Marketing'), ('System Administrator'),
('Technical Customer'), ('Technical Director'), ('Training');
GO
CREATE TABLE #UserRole
(
UserID INT 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)

June 30, 2010 at 6:53 am

#1187023
RE: create row for comma seperate

gideon.kahl (6/29/2010)
WayneS (6/29/2010)Out of curiousity, did you use the first solution as it's written, or did you follow the recommendation to build your very own tally table with a clustered...
--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)

June 30, 2010 at 6:42 am

#1187019
RE: Function in Joining column degrades performance in 2008

Heh... I finally beat Grant to the punch for a change. 😀
--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)

June 30, 2010 at 6:35 am

#1187015
RE: Function in Joining column degrades performance in 2008

aravind-305595 (6/29/2010)
Hi,
I have an existing code in sql server 2000, which after migrating to sql server 2008 the performance has become poor.
The query inside the code have a select statement...
--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)

June 30, 2010 at 6:32 am

#1187010
RE: Trying to use a variable as input in SQLStatement within a ForEach Loop

I don't use SSIS so I have no clue but let my post serve as a "bump" to someone who may. 🙂
--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)

June 29, 2010 at 9:13 pm

#1186831
RE: Insert 10,000 records in one second (LogFile??)

Eugene Elutin (6/29/2010)
Morteza,
Hornestly, I believe that your question is not really for a forum discussion. It is too many factors which would determine the best solution for your company....
--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)

June 29, 2010 at 9:10 pm

#1186828
RE: Problem with query on indexed computed column

Duncan Pryde (6/29/2010)
Does anyone have any ideas what I should try looking at to get this working?
Yes... Google for "Parameter Sniffing" for the reason caused by multiple causes and repaired...
--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)

June 29, 2010 at 9:01 pm

#1186823
RE: Kudos to the Community

Michael Valentine Jones (6/29/2010)
Dan.Humphries (6/29/2010)
...I have never gotten the snarky type of responce that is so normally typical on other IT boards...
It's not all love and kisses around here; Check...
--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)

June 29, 2010 at 8:57 pm

#1186821
RE: create row for comma seperate

lmu92 (6/29/2010)
WayneS (6/28/2010)
lmu92 (6/28/2010)
Ok, kinda funny I had to go back to this post within just a few hours...
The first person who "forced" me to do it actually...
--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)

June 29, 2010 at 8:42 pm

#1186819
RE: need some help on a pivot

lmu92 (6/29/2010)
torpkev (6/29/2010)
That worked perfectly, thanks so much..
I was pretty close in what I had but wasn't quite there.. and the link on dynamic cross tab sounds pretty interesting -...
--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)

June 29, 2010 at 8:28 pm

#1186816
RE: Replace single or multiple hyphen(-) with a space.

Dohsan (6/29/2010)
Having a read of this article should help you:
http://www.sqlservercentral.com/articles/T-SQL/68378/
Actually, I have to admit, my really cool (or so I thought :blush: )method got the pants beat off it by...
--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)

June 29, 2010 at 8:22 pm

#1186814
RE: Variable Table Names in SP ?

All good ideas, Wayne. Thanks for the feedback.
--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)

June 29, 2010 at 7:49 pm

#1186810

Viewing 15 posts - 37,846 through 37,860 (of 59,072 total)