Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,811 through 45,825 (of 59,101 total)

RE: Need output as 1,2,3,...10

arup_kc (1/15/2009)
Hi Gail,
This is actualy a question, which I have faced in an interview. I have tried with ROW_Number function later but no result.
That's why I have posted 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)

January 17, 2009 at 7:31 pm

#928809
RE: how many db's on one server

I agree with Gus... it doesn't matter how many databases you have on a given instance of SQL Server... it's resource usage that matters. How many users are logged...
--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 17, 2009 at 7:25 pm

#928807
RE: SQL Bulk Insert

Yes... Select/Into will do minimal logging under the right conditions. But, it also builds the table... you would have to drop the target table first.
--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 17, 2009 at 7:22 pm

#928806
RE: Cursor

Simon,
I wonder if you'd do me a favor... I realize it's been about 4 months since the last post, but I need to ask... why did you need to do...
--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 17, 2009 at 7:00 pm

#928803
RE: Evaluate a string Expression

rog pike (1/17/2009)
Jeff Moden (1/16/2009)
Heh... Come on folks. "We don need no stinkin' CLR!" 😛 This is a simple problem and it doesn't need a CLR. ...
--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 17, 2009 at 6:29 pm

#928799
RE: Select Where_Min()

Correct. But even the estimated execution plan is "wonky" in that respect. I don't have the code example to prove it, but I've seen where a Loop...
--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 17, 2009 at 6:19 pm

#928798
RE: SQL or Oracle

Heh... my first program was using punchcards on Unit Record equipment that was "programmed" by putting banana plug wires into a rather large phenolic board that got insert into 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)

January 17, 2009 at 6:10 pm

#928795
RE: Are the posted questions getting worse?

Sushila's last login and post was on 2008-11-27. Last I heard from her, she was just incredibly busy. I sure do miss her good nature... makes the rest...
--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 17, 2009 at 6:06 pm

#928794
RE: Top N sub query workaround - Does it exist?

krypto69 (1/17/2009)
The method I posted above worked...but gives me fewer records...so I'm stuck..
Heh... we are too... you've not posted the CREATE TABLE statements I asked for and you've not posted...
--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 17, 2009 at 5:55 pm

#928793
RE: Hidden RBAR: Triangular Joins

Jeff Moden (1/17/2009)
TheSQLGuru (1/17/2009)
1) http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx. Don't forget to examine the original post mentioned at the top.
Thanks Kevin, and will do.
Oh... those... I've read those before... and, I don't get...
--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 17, 2009 at 5:50 pm

#928792
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/17/2009)
1) http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx. Don't forget to examine the original post mentioned at the top.
Thanks Kevin, and will do.
--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 17, 2009 at 4:54 pm

#928788
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/17/2009)
2) to Joe: there are several implementations for regex that developers (both XP-based and CLR-based) can download and install from the web that work just fine on sql...
--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 17, 2009 at 4:53 pm

#928787
RE: Are the posted questions getting worse?

Matt Miller (1/17/2009)
Say it with me: "ricochet"....:)
Heh... DUDE! Did you just call me a hard head? 😛
Anyone remember the ol' "Ricochet Rabbit" cartoons? Or, how about "Quickdraw McGraw"...
--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 17, 2009 at 4:43 pm

#928786
RE: Are the posted questions getting worse?

RBarryYoung (1/17/2009)
Hey, I just read it. That is a great article!
Awesome... thanks for looking it up, Barry. Her mastery of the written word is just an absolute pleasure...
--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 17, 2009 at 4:39 pm

#928785
RE: Are the posted questions getting worse?

GilaMonster (1/17/2009)
Jeff Moden (1/17/2009)
how can you possibly think he's wrong?
Well, it's not that he's wrong. That's a perfectly correct answer, just to a different question. It's the same...
--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 17, 2009 at 4:17 pm

#928782

Viewing 15 posts - 45,811 through 45,825 (of 59,101 total)