Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,201 through 40,215 (of 59,098 total)

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
RE: Pattern Search

The listing is missing the directory information for season 1. Any chance of you attaching the actual file so I can take a look-see and maybe come up with...
--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:11 pm

#1105848
RE: select top 1 accross a whole set

lmu92 (1/19/2010)
When adding the following three samples to your data, which one should be displayed (each one has values in two out of three columns)?
select 'fred', 'unsure', 33716, 'test@here.com','444.75.224.23', null
union
select...
--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:05 pm

#1105846
RE: A "TOP 10" Query - puzzled as to why this does not work

Richard McSharry (1/19/2010)
PS Here's another great puzzle:
"Why does posting a question to forums so often result in the answer popping into one's head immediately after posting?" :ermm:
BWAA-HAA!!! For 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 19, 2010 at 11:02 pm

#1105845
RE: indexing online vs offline, and setting a database offline

And just so you know, rebuilding indexes using the "Online" option is only an option in the Enterprise and Developer's (Enterprise with very limited licensing) Editions.
--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 10:57 pm

#1105843

Viewing 15 posts - 40,201 through 40,215 (of 59,098 total)