Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,771 through 37,785 (of 59,098 total)

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
RE: Convert CSV values in three columns to rows

Thank you for the test harness and your good code, Oleg. I'll check it out.
--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 6, 2010 at 9:24 pm

#1189402
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/6/2010)
WayneS (7/5/2010)
Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of the Threadizens...
I've been contemplating making...
--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 6, 2010 at 9:18 pm

#1189401
RE: Are the posted questions getting worse?

Paul White NZ (7/6/2010)
Jeff Moden (7/6/2010)
Oddly enough, I'd heard that Forward_Only Read_Only was faster than Fast_Forward. Heh.... guess what I'm NOT going to test. :hehe:
Yep, but you also need...
--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 6, 2010 at 12:14 pm

#1189262
RE: SSRS rendering limits?

Heh... not to worry. Didn't take it the wrong way. I was truly sorry for being short on the subject.
So far as SSAS being a "good GUI".... it'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)

July 6, 2010 at 11:14 am

#1189224

Viewing 15 posts - 37,771 through 37,785 (of 59,098 total)