Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,171 through 40,185 (of 59,072 total)

RE: How to display a columns current row and next row value in single select query?

It looks like the data already has an "auto-increment" column but just has a couple of gaps. Use ROW_NUMBER() to establish a "gapless" self join and go from there.
--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 20, 2010 at 9:41 pm

#1106468
RE: Best Overall Certification Right Now

kevin.wohlwend (1/20/2010)
Not sure what your asking there Dugi. To clarify I am curious which MS certifications have the most value right now.
I've interviewed many people for SQL Developer, DBA, 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)

January 20, 2010 at 9:19 pm

#1106463
RE: Is there any justification for really using SQL CLR

Lowell (1/20/2010)
CLR is much faster with string manipulations. there are some things that cannot be done in TSQL
Regular expressions is one of the most common example, where it cannot be...
--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 20, 2010 at 9:00 pm

#1106459
RE: Pattern Search

Ok... I put your two files in C:\Temp on my home computer. The following imports, rips, and strips the MOVIES.Txt file. About the only thing you need 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)

January 20, 2010 at 8:18 pm

#1106453
RE: Are the posted questions getting worse?

Gianluca Sartori (1/20/2010)
David Burrows (1/20/2010)
CirquedeSQLeil (1/19/2010)
Gianluca Sartori (1/19/2010)
What are writing about, Paul?
I started writing my first article 9 months ago and it isn't finished yet.:crying:
Similar situation for me, only 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 20, 2010 at 7:53 pm

#1106449
RE: Are the posted questions getting worse?

Alvin Ramard (1/20/2010)
Dave Ballantyne (1/20/2010)
This has the potential for fun.... 😉
http://www.sqlservercentral.com/Forums/Topic850261-8-1.aspx
That one really boggles the mind, eh? I'd like to talk that that OP's manager. Stay tuned folks;...
--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 20, 2010 at 7:50 pm

#1106447
RE: Are the posted questions getting worse?

Heh... I've found a sure-fire way to keep from having problems with MySQL ODBC drivers... don't use them or MySQL. 😛
--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 20, 2010 at 7:46 pm

#1106445
RE: Perfect is the Enemy of Good

GabyYYZ (1/20/2010)
See signature... 🙂
Heh... see previous post. 😉
--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 20, 2010 at 7:21 pm

#1106442
RE: Help Others, Help Yourself

rick-507511 (1/20/2010)
I still believe in delivering MORE than is expected and sleeping well at night.
The "Law of Success", "Lesson Nine", Napoleon Hill.
--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 20, 2010 at 7:12 pm

#1106439
RE: Help Others, Help Yourself

David Korb (1/20/2010)
This is why the one-room schoolhouse is a superior model for education: the older kids solidify their knowledge as they pass it on to the younger.
I actually went...
--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 20, 2010 at 7:10 pm

#1106438
RE: Help Others, Help Yourself

José.Cruz (1/20/2010)
Hi there,
First of all i'll like to say that i complettly agree with your article, i've been helped so many times in this public forums, that now, a little...
--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 20, 2010 at 7:05 pm

#1106436
RE: Pattern Search

Perfect... I'm on my way to work. I'll bang out my version tonight when I get home. It'll be interesting to see what other folks do in 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 20, 2010 at 6:00 am

#1105975
RE: Pattern Search

If I can get an accurate copy of the file, I'll show you how to do this without a cursor. 😉
--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 20, 2010 at 12:27 am

#1105862
RE: Power Outage

I'd recommend spending a some bucks on an uninteruptable power supply for the server that has the ability to do a soft shutdown after xx minutes of power outage. ...
--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 19, 2010 at 11:19 pm

#1105850
RE: cursor performance

Step 1: Document what the requirements are for each cursor at a business level.
Step 2: Write new set based code as if you never saw the cursor... just...
--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 19, 2010 at 11:16 pm

#1105849

Viewing 15 posts - 40,171 through 40,185 (of 59,072 total)