Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,746 through 44,760 (of 59,095 total)

RE: tempDB filled 140GB HDD in under 2 days?

I recently went through such a thing... for the second time...
It was simply "bad" code where a developer didn't understand the relationship between a few tables and created what amounts...
--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 7, 2009 at 2:07 pm

#955553
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

Actually, in SQL Server 2k5, we don't need to solve the running total problem for this because it's just a ranking problem... this should do it...
;WITH
cteGroup AS
(
SELECT...
--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 7, 2009 at 12:38 pm

#955537
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

And, sorry... the running total article I wrote is in the process of being rewritten.
--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 7, 2009 at 12:23 pm

#955534
RE: Text Parsing TSQL code

Bob Hovious (3/7/2009)
I do it strictly in self-defense.
BWAA-HAA!!! Me too! Let's get together and burn some ISO's sometime! 🙂
--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 7, 2009 at 11:41 am

#955529
RE: Lets help the experts help themselves

Steve Jones - Editor (3/7/2009)
I used to think we should disclose discussions from there that aren't NDA. I still think there's value in having someone summarize and put the notes...
--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 7, 2009 at 11:34 am

#955527
RE: Text Parsing TSQL code

Bob Hovious (3/7/2009)
By an odd coincidence, I just did that. It doesn't seem to make a significant difference.
I just knew you would... that's one of 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 7, 2009 at 10:41 am

#955512
RE: Are the posted questions getting worse?

Roy Ernest (3/7/2009)
Flash Gordon...Brings back old memories. I have never seen the series but I used to read the comics back then. Flash with the Doc. Mandrake with Luthor nd...
--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 7, 2009 at 10:35 am

#955508
RE: Are the posted questions getting worse?

Lynn Pettis (3/6/2009)
Of course, there are areas where egos are strong, RBAR solutions for one (right Jeff!).
Heh... no ego there... I let the code do the talking, as all should.
Funny...
--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 7, 2009 at 10:34 am

#955506
RE: Text Parsing TSQL code

Bob Hovious (3/6/2009)
a WHILE loop may actually perform better than a Tally table on function like these
Jeff, do you know if the size of the tally table make any...
--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 7, 2009 at 9:06 am

#955483
RE: PIVOT query

Bob Hovious (3/6/2009)
As a former attorney...
Heh... now I know where you get that wonderful sense of humor... 😀
--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 7, 2009 at 7:35 am

#955453
RE: Table design

So, Narendra... are you all set?
--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 6, 2009 at 10:43 pm

#955410
RE: Bulk insert won't skip the column header in the .csv file

qzhu (2/5/2009)
So how should I define my format file to define the column header corretcly? Is there a way to do that?
There is a nasty little fault in BCP...
--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 6, 2009 at 10:41 pm

#955409
RE: Repeatable Query

Shuaib (3/6/2009)
Thanks lot for you info.
I also found the Numbers table details.
If you want to know how a Numbers or Tally table actually works to get jobs like these done,...
--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 6, 2009 at 10:31 pm

#955407
RE: nth WeekDayName of a month

robert.mason (3/6/2009)
Yes, I am using 23:59:59 as the end date for the reports. Any results that occurred after that time are for the following day, and should not be...
--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 6, 2009 at 10:23 pm

#955405
RE: T-SQL

metro17 (3/6/2009)
SELECT MYDATE AS year, DATENAME(mm, MYDATE) AS month, SUM(number) AS totalnumber, SUM(amount)
AS totalamount
FROM MYTABLE
GROUP BY MYDATE, DATENAME(mm, MYDATE)
ORDER BY MYDATE, DATENAME(mm, MYDATE)
year month totalnumber totalamount
2004-08-26 10:39:00 August 2199...
--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 6, 2009 at 10:14 pm

#955404

Viewing 15 posts - 44,746 through 44,760 (of 59,095 total)