Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,596 through 41,610 (of 59,098 total)

RE: query optimizing

Let's take this one step further. In a lot of cases, if an index is used by the sort, the sort operation in the execution plan will frequently not...
--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)

October 8, 2009 at 10:48 am

#1063603
RE: query optimizing

Ah... got it. If you gen the actual execution plans for both queries, you'll see that the INDEX SEEK is used to resolve the predicate "WHERE itemcode = 'Apples'"...
--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)

October 8, 2009 at 10:40 am

#1063600
RE: query optimizing

Heh... you've confused me, as well. 😛 I'll have to study that a bit... I'll be 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)

October 8, 2009 at 10:31 am

#1063591
RE: How I can make look like I expert on SQL Server?

I'd rather not give this troll such hints, Gus. Kill this thread.
--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)

October 8, 2009 at 9:00 am

#1063518
RE: CPU Usage Reported By Profiler

Outstanding. Thanks for taking the time to write all of that up, Chris. This is definitely a "keeper" for me.
--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)

October 8, 2009 at 8:54 am

#1063511
RE: Generic SPROC to write data to text file.

npatel0130 (10/8/2009)
Jeff Moden (10/7/2009)
What format shall the text file be in? CSV? TSV? Fixed Length Fields? Space Delimited? True CSV? Text Qualified CSV? Other...
--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)

October 8, 2009 at 8:51 am

#1063510
RE: Age Banding (for a beginner, please!)

Aye. Thank you for the feedback. I just wish I was the one that thought 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)

October 8, 2009 at 8:40 am

#1063503
RE: How I can make look like I expert on SQL Server?

Silverfox (10/8/2009)
being a dba is a position of immense trust and responsibility, if you make a mistake you can bring the company to its knees.
Truer words never spoken. Even...
--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)

October 8, 2009 at 8:30 am

#1063493
RE: Are the posted questions getting worse?

Jan Van der Eecken (10/7/2009)
Hehe, join the club. Last time we played I hit a marshal by mistake coz his gear was indistinguishable from the other players. He wasn't too...
--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)

October 8, 2009 at 8:13 am

#1063478
RE: Are the posted questions getting worse?

Grant Fritchey (10/7/2009)
As far as targets go, there are two types of vehicles on the ocean. Targets and submarines.
Heh... I was scrolling "up" through the thread when I saw this......
--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)

October 8, 2009 at 8:12 am

#1063476
RE: SQL & the JOIN Operator

Andy DBA (10/7/2009)
Jeff Moden (10/7/2009)
Now, there's a suggestion for a follow up article.
Sure, hint hint. I think it's old ground, though.
http://www.sqlservercentral.com/blogs/tim_mitchell/archive/2008/05/29/using-in-with-possible-null-values.aspx
http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/
http://www.sqlservercentral.com/articles/Advanced+Querying/2829/
Wow... thanks for the reminder especially about Michael Cole's...
--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)

October 8, 2009 at 8:01 am

#1063469
RE: SQL & the JOIN Operator

davidpenton (10/7/2009)
Jeff Moden (10/7/2009)
Heh... of course, I will admit that, no matter which method someone uses to identify the column/table relationships, just about anything would be better than a format...
--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)

October 8, 2009 at 7:07 am

#1063415
RE: CPU Usage Reported By Profiler

Chris Howarth-536003 (10/7/2009)
In our case the problem turned out to be a memory leak associated with the sp_OAMethod and the sp_OAGetProperty extended procedures which were being called every few minutes...
--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)

October 8, 2009 at 6:52 am

#1063400
RE: Date Range Parameters (between)

Excellent tip/reminder on the "next day" thing, Jack.
--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)

October 7, 2009 at 8:07 pm

#1063213
RE: Creating a listener to update another database

What do you want to do about UPDATEs?
Also, I recommend that provide the CREATE TABLE statement along with any existing keys and indexes. Some test data would be helpful,...
--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)

October 7, 2009 at 8:04 pm

#1063211

Viewing 15 posts - 41,596 through 41,610 (of 59,098 total)