Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,021 through 40,035 (of 59,072 total)

RE: Database Design- IS NOT NULL always better choice?

True enough. If you define "X" as being unknown and compare the same two unknowns, they are equally unknown... by definition. If SQL Server really knew what Unknown...
--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)

January 30, 2010 at 10:53 am

#1111211
RE: query taking a lot of time.

Was that the actual execution plan or the estimated execution plan attached in the first post? The reason why I ask is because all of the rows have been...
--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)

January 30, 2010 at 10:40 am

#1111210
RE: xp_cmdshell

Sounds silly but did you hit "refresh" when you looked in the destination folder?
--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)

January 30, 2010 at 10:35 am

#1111206
RE: Extract X and Y coordinates out of a string and check if within range

Since this is going to be a stored procedure, my recommendation would be to peel just on potato at a time. Let's split the coordinate pairs into a more...
--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)

January 30, 2010 at 10:15 am

#1111199
RE: Date Range

forum member (1/30/2010)
Hi ,
I have start date and finish date range inputted as a parameter into the report,how can i extract each month start and finish date range from...
--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)

January 30, 2010 at 8:37 am

#1111188
RE: Index Where Name = NULL

Heh... sorry Jason... I don't know what you mean by "PC" in this case. I get the jist but not the meaning. 🙂
Sounds like your design philosophy and mine...
--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)

January 30, 2010 at 7:46 am

#1111184
RE: TempDB into Memory

GilaMonster (1/30/2010)
Jeff Moden (1/29/2010)
There are a couple of things you can try like making sure TempDB is on it's own harddrive(s), has 1 file for each CPU (up to 8...
--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)

January 30, 2010 at 7:36 am

#1111183
RE: Patern Matching

UT- (1/30/2010)
@jeff:
Thanks for this new idea, i am really looking forward to see the results BUT in your post you did not include the code to generate the tally table...
--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)

January 30, 2010 at 7:33 am

#1111182
RE: Exceptional DBA Voting

GilaMonster (1/30/2010)
There's something odd going on with the forum. Suddenly lots of old announcements,podcasts, etc are pitching up in the forums with recent dates. I mean, this announcement dates back...
--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)

January 30, 2010 at 7:16 am

#1111181
RE: Is There A Script To List Tables & Number Of Records In Each

As a bit of a side bar, the number of rows from the system tables can go a bit astray at times. If you want them to be 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)

January 30, 2010 at 12:37 am

#1111137
RE: A Dearth of Comments

Hey Steve! What's up with all these article discussions showing up with none of the posts they used to have?
--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)

January 30, 2010 at 12:33 am

#1111136
RE: Are the posted questions getting worse?

Adam Machanic (1/29/2010)
Jeff Moden (1/29/2010)
Grant Fritchey (1/29/2010)
Don't let Adam Machanic hear you say that. He's pretty convinced he's created a killer app with CLR at some investment firm he's been...
--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)

January 29, 2010 at 11:21 pm

#1111131
RE: query taking a lot of time.

Here... update your stats, defrag your indexes, and try this out...
WITH
ctePreCondition AS
(
SELECT DATEADD(dd,DATEDIFF(dd,0,log_date),0) AS Date,
event_duration
FROM dbo.log_event WITH(NOLOCK)
WHERE log_date >= CAST('2009-12-16'...
--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)

January 29, 2010 at 11:08 pm

#1111130
RE: query taking a lot of time.

I would think the text conversion in the SELECT list and GROUP BY is killing you. Use the DATEADD/DATEDIFF trick to get whole dates.
--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)

January 29, 2010 at 11:01 pm

#1111127
RE: Query Table1 takes result rows and create Table2 columns Dynamically

Dynamically...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

January 29, 2010 at 10:54 pm

#1111124

Viewing 15 posts - 40,021 through 40,035 (of 59,072 total)