Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,061 through 30,075 (of 59,101 total)

RE: Columns to Rows

Now that you've been shown the principle of how it works, how about showing us your try?
--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 13, 2012 at 9:13 am

#1486856
RE: Managing Transaction Logs

best_yunus (5/12/2012)
Can we do point in time recovery in Bulk loged recovery model?
If yes then how?
Yes but only if there were no minimally logged transactions in the final log file...
--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 13, 2012 at 12:15 am

#1486840
RE: usage of joins

Perhaps a bit of a join tutorial is in order.
http://www.w3schools.com/sql/sql_join.asp
--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 13, 2012 at 12:12 am

#1486839
RE: trimming a text string

Ummmm.... if the first character is always a backslash (and I think it will be), you could really shorten up the code by starting the charindex search at character #2....
--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, 2012 at 11:50 pm

#1486838
RE: How to split Delimited text

MaverickMan (4/30/2012)
Performance is not the need for our problem so it will work with any of the solutions presented above.
BWAAA-HAAAA!!!! So! Did you pick the slowest 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)

May 12, 2012 at 11:42 pm

#1486836
RE: usage of joins

selvakumar.sms (5/12/2012)
hi
please explain me where to use right outer join and left outer join.
i referred many articles but i couldn't get clear...
--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, 2012 at 11:02 pm

#1486833
RE: Is Software Engineering Dead?

Good article, Steve. I believe that you've hit the nail on the head. So many managers think that Hours worked = Hours wisely spent = Good lines of...
--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, 2012 at 10:55 pm

#1486832
RE: Display Estimated Execution Time - Client Execution Time

To the best of my knowledge, no such tool exists. Certainly, not an accurate one. Even the actual execution plan is frequently wrong when comparing things such as...
--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, 2012 at 10:43 pm

#1486831
RE: transpose rows into columns without aggregate

nitin_456 (5/12/2012)
Thanks for the reply !!
But there can be thousand of Comid , is there any other way to to do this...
Understood on there being thousands of Comids...
--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, 2012 at 10:21 pm

#1486830
RE: Columns to Rows

Heh... I took too long and CC beat me.
--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, 2012 at 10:09 pm

#1486827
RE: Columns to Rows

Ya just gotta love non-ansi joins for correlation. 😉
SELECT tyn.IdNum,ca1.Pnum,ca1.YN,ca2.Value
FROM #TempYesNo tyn
INNER JOIN #TempValue tv
ON tyn.IdNum = tv.IdNum
...
--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, 2012 at 10:07 pm

#1486826
RE: primary keys

erics44 (5/12/2012)
The vast majority of primary keys I see in all databases are on the id identity fields, I suppose because they are sequbtial and used in joins more often...
--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, 2012 at 9:52 pm

#1486824
RE: Where are the good Senior Level DBA's?

Lynn Pettis (5/12/2012)
Jeff Moden (5/12/2012)
Elliott Whitlow (5/12/2012)
As a further point, I dislike most aspects of technical interviews purely because in MANY cases they are very subjective and if you don't...
--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, 2012 at 9:41 pm

#1486822
RE: procedure help

I've not checked it for performance but it does avoid a full cross join and it does work.
WITH
cteUnPivot AS
(
SELECT ex.[Drawn Date], ca.Number
FROM dbo.Example ex
...
--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, 2012 at 9:14 pm

#1486820
RE: Where are the good Senior Level DBA's?

Elliott Whitlow (5/12/2012)
As a further point, I dislike most aspects of technical interviews purely because in MANY cases they are very subjective and if you don't give them the answer...
--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, 2012 at 2:05 pm

#1486790

Viewing 15 posts - 30,061 through 30,075 (of 59,101 total)