Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,741 through 37,755 (of 59,072 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (7/9/2010)
Alvin will soon be making a christmas soon that involves flux capacitors, pork chops, and bears
Do forget the hampster poo... flux capacitor just isn't the same without 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)

July 9, 2010 at 3:22 pm

#1191043
RE: Try Catch alters behaviour of existing procedures

doobya (7/8/2010)
Thanks all for your comments
as long as the point is clear - mixing TRY with @@error can cause subtle problems
and this point is not made in BOL, breaking changes,...
--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)

July 8, 2010 at 6:17 am

#1190185
RE: Leanring from Experts

william-700725 (7/7/2010)
Jeff Moden (7/7/2010)
william-700725 (7/7/2010)
[font="Courier New"]Andy, one of the first lessons I learned in journalism is that, until you send your copy off to the typesetters, it's never to late...
--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)

July 8, 2010 at 6:13 am

#1190181
RE: Best Approach To Enable and Allow Use xp_cmdshell Non sysAdmin Users

shoffman-569213 (7/7/2010)
I have some developers that are using xp_cmdshell and to get it to work I had to grant administer bulk operations for a network group. What does this...
--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)

July 7, 2010 at 7:56 pm

#1189958
RE: output of SQL query in mail format

It's a real shame that they're doing away with it. Lookup "sp_MakeWebTask" in Books Online. With the advent of VARCHAR(MAX) in 2k5, it's an awesome tool and you...
--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)

July 7, 2010 at 7:45 pm

#1189956
RE: Leanring from Experts

So, I’m curious, have you had a time at work where you learned a lesson about productivity or technique by watching someone, a light bulb moment?
Heh... my favorite moments are...
--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)

July 7, 2010 at 7:26 pm

#1189951
RE: Leanring from Experts

william-700725 (7/7/2010)
[font="Courier New"]Andy, one of the first lessons I learned in journalism is that, until you send your copy off to the typesetters, it's never to late to check your...
--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)

July 7, 2010 at 7:12 pm

#1189947
RE: Are the posted questions getting worse?

Tom.Thomson (7/7/2010)
bteraberry (7/7/2010)
The Dixie Flatline (7/7/2010)
You're not going to explain this in a such a way as to make him happy.
I didn't believe you. Now I do.
I've been 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)

July 7, 2010 at 7:06 pm

#1189945
RE: More fun with ISNUMERIC()

Olga B (7/7/2010)
I also noticed that converting a string of numbers with a comma anywhere in it (e.g., '12,345') to a numeric value results in an error, even though ISNUMERIC...
--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)

July 7, 2010 at 6:14 pm

#1189937
RE: Try Catch alters behaviour of existing procedures

Gosh... just adding my 2 cents... I don't understand what all the controversy is. The original post returns the results exactly the way I'd expect such code to return...
--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)

July 7, 2010 at 5:54 pm

#1189930
RE: Creating Clustered index on a large table

TheSQLGuru (7/7/2010)
One had autoshrink on and neither had ANY index maintenance or statistics update jobs.
BWAA-HAAA!!!! C'mon now, Kevin! Everyone knows that having autoshrink turned on is...
--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)

July 7, 2010 at 5:20 pm

#1189924
RE: Want to Calculate Business Working hours

Ken Klaft-381933 (7/7/2010)
<LOL>
I didn't see the entire second page of replies.
My apologies to Jeff and the group.
😛
--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)

July 7, 2010 at 5:09 pm

#1189921
RE: like operator problem

msimone (7/7/2010)
In [font="Arial Black"]developer edition[/font], a select with like operator the function is good, but in [font="Arial Black"]developer edition[/font], is bad, less rows.
???? :blink:
--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)

July 7, 2010 at 5:04 pm

#1189920
RE: Planning for growth -oltp - what strategies are people using?

KarenD (7/7/2010)
We have about 25 million customers. The number of distinct visits to our sites each day varies between 25,000 and 30,000.
We are only using about 600 Gig of database...
--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)

July 7, 2010 at 4:59 pm

#1189918
RE: Split string using Tally Table

Oleg Netchaev (7/6/2010)
Jeff Moden (7/2/2010)
BWAA-HAA!!!! First, this is NOT a good example of Tally Table code. It doesn't use a Tally Table and it doesn't use anything that...
--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)

July 7, 2010 at 12:36 am

#1189441

Viewing 15 posts - 37,741 through 37,755 (of 59,072 total)