Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,646 through 30,660 (of 59,101 total)

RE: Remove GUID within a String Field

Eugene Elutin (3/23/2012)
...
Let's have a race and see how much of a difference there is.
...
NO Jeff! You don't want to do this!
BWAAA-HAAA!!!! Of course I do. But...
--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 24, 2012 at 11:46 am

#1463927
RE: Dealing with custom date formats in T-SQL

Gianluca, my ol' and trusted friend,
Very nice and well written article with lots of well fomatted, easy to read, documented code. Nicely done.
Shifting gears, I have a couple 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)

March 23, 2012 at 7:29 pm

#1463878
RE: Dealing with custom date formats in T-SQL

Lisa Slater Nicholls (3/23/2012)
charles.southey (3/23/2012)
Yes - it's relevant to the article and provides a possible solution for those grappling with the problem under discussion that they may be looking 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 23, 2012 at 6:37 pm

#1463872
RE: Pivots using Tally Table

NuB2Sql (3/23/2012)
WOW!!!!!!!! Amazing!!!
Thank you SOOOOOOOOOOOOOOOOOOOOOOOOO much!
it worked. if you didn't figure that out already there, i said it, it worked! 🙂
You are awesome! I have been fighting...
--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 23, 2012 at 1:45 pm

#1463762
RE: Query help

ColdCoffee (3/22/2012)
Order by NEWID and take the TOP 400 🙂
I have to say that I agree with that. If the rows are in the random order provided by NEWID(),...
--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, 2012 at 11:02 pm

#1463158
RE: Variable not getting reset inside the loop

Sean Lange (3/22/2012)
capn.hector (3/22/2012)
Sean Lange (3/22/2012)
capn.hector (3/22/2012)
Sean Lange (3/22/2012)
Even better, don't use loops. :hehe:
i was waiting for that one. :w00t:
Somebody had to say it...and I was kind of surprised...
--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, 2012 at 10:13 pm

#1463152
RE: Triangle Join - Can I do it right or a replacement?

Ah... there you are. Had accidently deleted this thread from my email chain and lost track of it.
I've been thinking about what you say folks are going to do...
--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, 2012 at 8:54 pm

#1463141
RE: Storing Year only in SQL Server 2008

Nadrek (3/18/2012)
Jeff, I must respectfully disagree with using DATETIME for date of birth in 2008 at all, unless there will be valid and meaningful times to record, as well 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)

March 22, 2012 at 7:46 pm

#1463133
RE: Index rebuild suddenly takes 5 times as long ?!?

SS999 (3/15/2012)
You are releasing space to the OS from tempdb, which might get ur indexes rebuild little faster than usual when you are doing online.
Oh, be careful now... that would...
--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, 2012 at 7:31 pm

#1463131
RE: Index rebuild suddenly takes 5 times as long ?!?

Ah! I just remembered what the cause of this slowdown may be. Did you (or someone) recently change the database from either the "Simple" or "Bulk Logged" recovery...
--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, 2012 at 7:27 pm

#1463130
RE: Get month names ordered using recursion

ChrisM@Work (3/19/2012)
This is pretty fast too:
SELECT n = (n1 + n2 + n3 + n4)
FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t3 (n3)
CROSS JOIN (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) t1...
--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, 2012 at 7:20 pm

#1463129
RE: Remove GUID within a String Field

Eugene Elutin (3/22/2012)
...
It's actually what scalar UDF's were invented for and one of the few places where RBAR actually has the advantage. Of course, I threw 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)

March 22, 2012 at 7:07 pm

#1463127
RE: Cannot bulk import CSV file with double quotes

support 23368 (12/11/2009)
Hi Jeff,
Yes I will most definately let you know how long it takes. I am going to start on it tonight.
Wow! It's taking a very long 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 22, 2012 at 7:01 pm

#1463126
RE: rows into columns

justforgroups2004 (3/22/2012)
🙁
Look like it doesn't work inside the OLE DB Source of SSIS (?)
Ummmm... why are you doing this type of stuff in SSIS? And, if you absolutely...
--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, 2012 at 6:55 pm

#1463123
RE: clarification in query

faroz2003 (3/16/2012)
Hi All,
Pls explain me the below query
select * from xyz
where year(created_on) <2010
if i give date instead of year it will work?
note: "xyz" is a table and "created_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)

March 22, 2012 at 6:51 pm

#1463122

Viewing 15 posts - 30,646 through 30,660 (of 59,101 total)