Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,781 through 36,795 (of 59,099 total)

RE: To get a DBA Job

PaulB-TheOneAndOnly (9/16/2010)
Ali Tailor (9/15/2010)
I'm a MCTS SQL server 2008,on 10th sept 2010, Having 5 + years working experience in IT as 'Software Support Engineer' my Job involve Software (my company'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)

September 16, 2010 at 7:45 am

#1222194
RE: Finding the two highest values for a criteria

FelixG (9/16/2010)
Thanks a lot Jeff, I'm coming from SQL Server 2000 and did not have knowledge about rownumber().
I said "performance is vital" to avoid the use of temp tables...
--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)

September 16, 2010 at 7:06 am

#1222148
RE: To get a DBA Job

Ali Tailor (9/16/2010)
Hi
Jeff Moden
Actually Its an other topics the DBA line, but right now my question is to get a Job in any DBA line , Coz I'm new 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)

September 16, 2010 at 5:53 am

#1222095
RE: simple SELECT query takes ten seconds to return 5000 rows - can I optimize?

Craig Farrell (9/16/2010)
8kb (9/15/2010)
CREATE INDEX X_IX1 ON X (ObjID)
Note, non-covering, non-clustered index, so we're going here, to the PrimaryKey:
|--Index Scan(OBJECT ([LoadTest].[dbo].[X].[X_IX1]), ORDERED FORWARD)
|--Clustered Index Seek(OBJECT...
--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)

September 16, 2010 at 5:44 am

#1222091
RE: Searching for Plans

CirquedeSQLeil (9/15/2010)
Jeff Moden (9/15/2010)
The Dixie Flatline (9/15/2010)
Jeff, you really have to let me buy you a drink at the PASS summit.
That would be both a pleasure and an honor. ...
--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)

September 16, 2010 at 5:40 am

#1222086
RE: Populate large data

Paul Swinfield (9/16/2010)
In addition to trying everything else posted you could try this.
Having been through a similar problem years ago using a poorly specified machine I had to resort...
--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)

September 16, 2010 at 5:34 am

#1222079
RE: Patients who come in within 14 days

farouqdin (9/16/2010)
His one of my staff....i asked him to search on the forums. Just pot luck that he came to the same forum. I'm more of apps developer and 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)

September 16, 2010 at 5:28 am

#1222076
RE: Concatenate Results in Row

Thanks for taking the time to write that up, Christy. It actually does make sense and, to be very honest, I'm quite relieved for you because you came right...
--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)

September 16, 2010 at 5:21 am

#1222073
RE: Changing from INSERT INTO...SELECT (with a UNION) to SELECT INTO

LutzM (9/15/2010)
I think the best I can recommend at this point is to get someone in to help those 3rd party folks improving their software asap. If there is such...
--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)

September 16, 2010 at 5:13 am

#1222070
RE: Are the posted questions getting worse?

Dave Ballantyne (9/16/2010)
Its not all bad though...
http://www.sqlservercentral.com/Forums/Topic987019-1292-1.aspx
Paul certainly is psychic. What a nice post that was. Thanks for pointing it out, Dave. Those types of things make...
--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)

September 16, 2010 at 5:02 am

#1222057
RE: What a nice place to be

What an incredibly thoughtful post. Thanks for starting my day off right, Mike! 😛 I hope a lot of the frequent posters get to see this one 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)

September 16, 2010 at 5:00 am

#1222054
RE: Are the posted questions getting worse?

GilaMonster (9/16/2010)
WayneS (9/16/2010)
But Gail, you know that there are so many other people that truly appreciate you. Just ignore the ID 10 T's and help those that appreciate it.
Yeah. Still...
--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)

September 16, 2010 at 4:53 am

#1222050
RE: Critical issues detected by SQL Server BPA

Mark Enloe (9/15/2010)
Manu-J... thanks for your straightforward, helpful response. Some others on the site appear to be more interested in providing condescending, pompous replies that do nothing 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)

September 16, 2010 at 4:41 am

#1222039
RE: Are the posted questions getting worse?

Paul White NZ (9/16/2010)
The final part of my optimizer series is up today. As expected, the page views have been lower than normal, but it has been good 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)

September 16, 2010 at 4:27 am

#1222029
RE: Are the posted questions getting worse?

Paul White NZ (9/15/2010)
Jeff Moden (9/15/2010)
Despite the "lol" in the post, I really didn't like this one. Maybe it's just because I've only got one nerve left today 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)

September 16, 2010 at 4:26 am

#1222027

Viewing 15 posts - 36,781 through 36,795 (of 59,099 total)