Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,381 through 34,395 (of 59,099 total)

RE: Average of Average in a matrix

It's my understanding that calculating an average-of-an-average is one of those Mathematical "no-nos". You might want to Google it and find out all the reasons why its mostly an...
--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)

April 4, 2011 at 10:15 pm

#1307281
RE: Work Experience - What work would you give someone?

I think a lot of people miss a real opportunity to make a difference in a young person's life during "work experience". Let them "belt loop" you which 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)

April 4, 2011 at 10:09 pm

#1307278
RE: SET ANSI NULLS OFF

There's no automated way unless you affect the entire session or database. You can add the setting to individual procs but that will affect the entire proc.
Setting ANSI NULLS...
--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)

April 4, 2011 at 8:20 pm

#1307268
RE: SET ANSI NULLS OFF

sankar.jayavelu (4/4/2011)
Hi,
Is there an automated way to SET ANSI NULLS OFF for a specific object type ?. For example, if i want to SET ANSI NULLS OFF for all 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)

April 4, 2011 at 11:12 am

#1307081
RE: Are the posted questions getting worse?

Dang... Johan beat me to the punch on the target thing. Since more than one of us said it, it must be true. 😛
--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)

April 4, 2011 at 8:01 am

#1306984
RE: Are the posted questions getting worse?

Roy Ernest (4/4/2011)
Jeff, I have been having some bad time with accidents during the past one and a half years. One car was totaled and bought this new one. 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)

April 4, 2011 at 7:59 am

#1306982
RE: How should ORM tools perform SQL actions?

Grant Fritchey (4/4/2011)
WayneS (4/1/2011)
I'd like to start a discussion for how ORM tools (Entity-Framework, nHibernate, etc.) should perform SQL actions.
I'm specifically interested in the use of stored procedures.
1. Should...
--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)

April 4, 2011 at 7:49 am

#1306975
RE: How should ORM tools perform SQL actions?

Oh yeah... I almost forgot. If you're going to use an ORM so the "developers" don't have to work with the DBA and don't really have to understand anything...
--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)

April 3, 2011 at 8:11 pm

#1306841
RE: How should ORM tools perform SQL actions?

My opinion is that Grant and the fellow that Grant cited are pretty much spot on and it all boils down to the following; Every tool has a proper...
--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)

April 3, 2011 at 7:55 pm

#1306840
RE: Analytical Interview Questions

Ah... got it. Thanks, Gail.
--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)

April 3, 2011 at 11:45 am

#1306823
RE: Are the posted questions getting worse?

Grant Fritchey (4/3/2011)
SQLkiwi (4/1/2011)
Hi everyone. Just to confirm it officially: I am now a SQL Server MVP (yay!)
Thanks to everyone for their kinds words and encouragement.
Paul
Congratulations again Paul. Extremely...
--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)

April 3, 2011 at 10:30 am

#1306817
RE: Analytical Interview Questions

GilaMonster (4/3/2011)
Please note: 3 year old thread.
It doesn't matter on such timeless subjects.
--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)

April 3, 2011 at 10:23 am

#1306816
RE: Is any built in function availble in SQL Server 2008 which handle comma seperated values and return as table?

Heh... SPAM SPAM reported. 😉
{edit} They removed the SPAM I reported so please disregard this message.
--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)

April 2, 2011 at 10:47 pm

#1306800
RE: Are the posted questions getting worse?

SQLkiwi (4/2/2011)
What an amazing day at SQL Saturday #71 in Boston today.
Got to meet heaps of great people including Grant and Stefan K!
If anyone would like to see the slides...
--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)

April 2, 2011 at 10:40 pm

#1306799
RE: Is any built in function availble in SQL Server 2008 which handle comma seperated values and return as table?

CirquedeSQLeil (4/2/2011)
WayneS (4/2/2011)
Mark-101232 (4/2/2011)
There's nothing built in, but you can use this function
http://www.sqlservercentral.com/Forums/FindPost944589.aspx
FYI - I have it on good authority that a newer, faster version of this is 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)

April 2, 2011 at 3:27 pm

#1306794

Viewing 15 posts - 34,381 through 34,395 (of 59,099 total)