Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,531 through 31,545 (of 59,101 total)

RE: Query Tuning

Steve updated the explanation with the lessons learned from this thread for me yesterday.
--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 3, 2012 at 4:43 am

#1427631
RE: help in logic

No offense taken. The XML method will take pretty much anything that you can throw at it. You just have to remember about entitization of characters. Hmmmm......
--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 3, 2012 at 4:37 am

#1427629
RE: Quirky Update query...works on server ...fails on PC.

Interesting conclusions. I wonder why it runs just fine on a box with only 500 MB? I'll load it back up tonight after work and take a look...
--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 3, 2012 at 4:31 am

#1427628
RE: Pros and cons of six SQL table tools

Toby Harman (1/2/2012)
I was surprised and disappointed to see that the inability to use SELECT... INTO was a disadvantage.
Anything which takes that option away from developers is a good thing...
--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 2, 2012 at 10:00 pm

#1427545
RE: Quirky Update query...works on server ...fails on PC.

J Livingston SQL (1/2/2012)
Hi Jeff
I am not surprised that you cannot replicate....I have used quirky update on several db's , all without errors...and the purpose behind this was to build...
--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 2, 2012 at 9:44 pm

#1427544
RE: help in logic

Gianluca Sartori (1/2/2012)
There's nothing wrong with COALESCE, it's the assignment in the SELECT list that makes the code unreliable.
Here's a couple of articles on the subject:
http://www.sqlmag.com/article/tsql3/row-concatenation-solutions-aren-t-all-equal
http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
Whup! Be careful 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 2, 2012 at 5:37 pm

#1427521
RE: Voluntary Constraint?

The article sounded a bit like a rant...
... I only wish I'd thought of it first! 🙂
Well said, Phil.
--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 2, 2012 at 3:46 pm

#1427499
RE: Censoring the Internet

I've not read the whole bill, yet, but my initial impression is that it's not trying to suppress "free speech". My impression is that it's trying to suppress copywrite...
--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 2, 2012 at 3:10 pm

#1427498
RE: all columns in parent

rajugnt (1/2/2012)
i need all columns in parent table and primary key as well as a foreign key AND DATATYPE,LENGTN sql 2008
This is report for one...
--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 2, 2012 at 2:51 pm

#1427497
RE: Quirky Update query...works on server ...fails on PC.

I couldn't get it to fail on two different boxes.
Box 1 is a 9 year old desktop w/single 32 bit CPU, 1GB ram, running 2k5 Dev Edition and Windows XP.
Box...
--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 2, 2012 at 1:55 pm

#1427492
RE: Do a project needs a seperate team for SQL?

DBA Rafi (1/1/2012)
we the development team in our project works both in dot-net and SQL server.
I am encouraging people here to have a separate team for SQL Server.
Can you please...
--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 2, 2012 at 12:30 pm

#1427487
RE: Query Tuning

Tom Brown (12/31/2011)
My word Jeff! A lot of thinking for a single point, considering I got 7 points for counting Santa's reindeer.
Keep 'em coming. I 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)

January 1, 2012 at 7:35 am

#1427272
RE: Select phone numbers depending on priority

manoj0134 (12/30/2011)
sorry for posting a reply for such an old thread, I am sql server newbie recently starting to learn the ropes of Sql querying.I have found...
--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)

December 31, 2011 at 8:58 am

#1427222
RE: Primary Keys are necessary for good database design

Michael Valentine Jones (12/30/2011)
Jeff Moden (12/30/2011)
...
And, yeah... there's nothing wrong with having a surrogate key as the PK and a natural key as an AK. 😉
Especially when the value...
--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)

December 31, 2011 at 8:07 am

#1427218
RE: Problem with a simple Scalar UDF

SQL Kiwi (12/30/2011)
Jeff Moden (12/30/2011)
SQL Kiwi (12/30/2011)
drew.allen (12/30/2011)
Naming conventions are simply conventions. There is no right or wrong. As long as they are consistent and meaningful, it doesn't...
--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)

December 31, 2011 at 8:01 am

#1427217

Viewing 15 posts - 31,531 through 31,545 (of 59,101 total)