Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

jcrawf02 (9/16/2010)
Stefan Krzywicki (9/16/2010)
Brandie Tarvin (9/16/2010)
Maybe. Cat just went in for surgery, so if I come across as witchy today, my apologies in advance. However, the bolded underlined part of...
--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 1:52 pm

#1222559
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/16/2010)
Steve Jones - Editor (9/16/2010)
WayneS (9/15/2010)
Steve Jones - Editor (9/15/2010)
And on an unrelated note. Who wants this job?
http://www.youtube.com/watch?v=txdv_oNq81I&feature=youtu.be
Darn it! Finally get a chance to look at 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)

September 16, 2010 at 1:49 pm

#1222555
RE: Advice on importing multiple txt files with different file structures

jcrawf02 (9/16/2010)
Just to make it interesting 😛 my DBAs have deigned not to grant BULK INSERT, so swell though your solution seems to be Wayne, it no workey.
In light...
--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 1:41 pm

#1222544
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

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