Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,561 through 31,575 (of 59,101 total)

RE: Query Tuning

SQL Kiwi (12/28/2011)
For anyone wondering about the cryptic comment in the UPDATE statement:
UPDATE dbo.Event
SET EndDate = DATEADD(dd,
...
--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)

December 28, 2011 at 4:40 am

#1426023
RE: Query Tuning

Sorry... bad post withdrawn. Hugo and Paul are correct. I missed my own NOT NULL constraint on the StartDate column. I'm sending an email to SSC to...
--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)

December 27, 2011 at 4:32 pm

#1425900
RE: Insert Millions of rows into a table at a time

1Ankit1 (12/27/2011)
Jeff and Dev,
It was intended to present one more possible way 😛 . You got that right, with just 400K rows, it might be calling for more efforts. My...
--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)

December 27, 2011 at 2:25 pm

#1425871
RE: Query Tuning

On my way to work... I'll have to answer your questions tonight.
--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)

December 27, 2011 at 7:37 am

#1425700
RE: Are the posted questions getting worse?

Thanks for the feedback. Yeah, I know. I sound like a real wire-head trying to explain why I didn't want to publish such a thing and it's a...
--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)

December 26, 2011 at 12:42 pm

#1425525
RE: Pros and cons of six SQL table tools

fahey.jonathan (12/26/2011)
Please notice that the "Females" CTE has been used twice in the outer query, once to list the details and once to provide summary records by job description, something...
--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)

December 26, 2011 at 12:35 pm

#1425524
RE: Are the posted questions getting worse?

I have a serious question for my fellow Threadizens...
Background:
A couple of years ago, one of our own asked me if he could publish an article on how to build scads...
--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)

December 26, 2011 at 9:54 am

#1425512
RE: Question on index column ordering

Dev (12/25/2011)
dfrome (12/25/2011)
The date's aren't unique, if the datapoint is minute data, then it's possible to have 65 (or more) dates in an hour, a 1 hour (00:00),...
--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)

December 26, 2011 at 8:57 am

#1425506
RE: Pros and cons of six SQL table tools

Good article on showing that there's more than one way to accomplish the same thing.
I do have a couple of comments though...
It's a shame that you didn't include any actual...
--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)

December 26, 2011 at 8:27 am

#1425501
RE: Equivalant of "Left Join" but in XML

Gosh, Lutz... you're too kind. :blush: Considering that that "Anonymous" fellow over on BeyondRelational set the tone on that post for everyone else with format, quantity, accuracy, and...
--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)

December 26, 2011 at 6:34 am

#1425489
RE: One of the worst examples of 3rd party SQL I've ever seen

Lowell (12/23/2011)
ok, it's time to play...
NAME...THAT...VENDOR!
Heh... Let's start with a category... ORM? Ok... Hibernate? NHibernate? LINQ? Any other suggestions?
--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)

December 25, 2011 at 5:26 pm

#1425444
RE: If your employer stops paying for your cert

{Edit} Never mind... Post withdrawn. It wasn't going to help. 😉
--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)

December 25, 2011 at 5:20 pm

#1425443
RE: Are the posted questions getting worse?

bitbucket-25253 (12/24/2011)
Lowell your posting of this link to assist an OP
TallyCalendar_Complete_With_DST.txt
Lowell -Fantastic amount of work - from a IT standpoint thanks for sharing - Glad you were willing to...
--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)

December 25, 2011 at 4:55 pm

#1425442
RE: Question on index column ordering

Dev (12/25/2011)
Jeff Moden (12/23/2011)
Dev (12/23/2011)
Gail I agree to you on SEEK operation but I care about following.
Clustered indexes are not a good choice for the following...
--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)

December 25, 2011 at 4:53 pm

#1425441
RE: merge statement and cte(common table expression)

Dang... I didn't even see that David posted a full answer before I did. I wouldn't have even posted had I seen it. I guess I had 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)

December 25, 2011 at 4:46 pm

#1425440

Viewing 15 posts - 31,561 through 31,575 (of 59,101 total)