Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,736 through 30,750 (of 59,101 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Actually, there is a good reason for the MAX datatypes to have a performance problem with such splitters. They're simply handled differenently even when they're "in row" and because...
--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 15, 2012 at 7:31 am

#1459832
RE: how to convert seconds to time in sql

Sorry... post withdrawn... posted code for the wrong problem.
--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 15, 2012 at 7:05 am

#1459809
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/15/2012)
Jeff, did you receive any news regarding the performance characteristics of the code (or variations) on SQL Server 2012?
And on the extra bright side, in a few months I...
--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 15, 2012 at 6:47 am

#1459796
RE: Constraint to prevent UPDATE after row is committed

Jayanth_Kurup (3/15/2012)
I wud go with the instead of trigger [font="Arial Black"]if this wasnt a frequent activity[/font]. else i wud create a new column called is modifiable. and update it with...
--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 15, 2012 at 6:38 am

#1459787
RE: "Divide by zero error encountered." in where clause on SQL 2008 and working OK on SQL 2000

I believe the answer is simple. You have two different servers. Are you absolutely sure the data is on the new server doesn't have a "0" in it...
--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 15, 2012 at 12:20 am

#1459649
RE: Constraint to prevent UPDATE after row is committed

wiseman82 (3/13/2012)
Hi,
I'm wanting to prevent updates to a certain table after the row has been committed to the database.
Keep it simple, then. Put an "INSTEAD OF" trigger on the...
--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 15, 2012 at 12:15 am

#1459646
RE: Was This Week A Good Week?

What constitutes a good week for you?
Finishing a week on this side of the grass is a great start. 😉
I think a week is what you make of it. ...
--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 14, 2012 at 11:29 pm

#1459637
RE: Large Size of TempDB

SQL_By_Chance (3/14/2012)
Thanks all for your valuable inputs. As lowell pointed out yeah in past we did create #tmptable with million-billion rows. And one of the servers with (1TB- TempDB) had...
--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 14, 2012 at 11:22 pm

#1459635
RE: Parsing tab selimited text into SQL table

Thanks, Orlando.
--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 14, 2012 at 11:20 pm

#1459633
RE: how to convert seconds to time in sql

dastagiri16 (3/14/2012)
hi,
Could you please give any formula for that to convert seconds to time...
Thanks,
Giri
SELECT DATEADD(ss,someseconds,0)

That will give you a date/time and you probably won't like the looks 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 14, 2012 at 11:13 pm

#1459632
RE: Recursion - find last child

Hmmm... I've been thinking about this off and on. Does the return need to be in the precise format that you specified or could you use the whole history...
--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 14, 2012 at 11:02 pm

#1459631
RE: How to convert some columns into rows with the first two columns still retained as columns

Hmmm... Ok, moving 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 14, 2012 at 11:00 pm

#1459630
RE: Great Developers

Gary Varga (3/13/2012)
Jeff Moden (3/12/2012)
Gary Varga (3/12/2012)
Give an interviewee enough rope and they will hang themselves 😉
Heh... "It Depends". I normally spend most of my time in an interview...
--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 14, 2012 at 10:50 pm

#1459629
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

It's never a waste of time to suggest possible improvements and I thank you for them. Actually, I'm sorry you may have wasted some of your time but the...
--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 14, 2012 at 10:29 pm

#1459627
RE: Parsing tab selimited text into SQL table

Ummmm... that class has a batch size parameter to it. I'm not a C# programmer but wouldn't that prevent the whole 9 yards from being loaded at once?
--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 14, 2012 at 10:20 pm

#1459626

Viewing 15 posts - 30,736 through 30,750 (of 59,101 total)