Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,681 through 40,695 (of 59,098 total)

RE: Coincidence or Causality

Paul White (12/13/2009)
There is at least one case where the written order of the tables does matter.
Man... very, very well done. Thanks, Paul.
--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 14, 2009 at 8:48 pm

#1092324
RE: Coincidence or Causality

Heh... wow... Paul beat me to it and, for once, I'm glad so that I'm not the first to say something that most other people will disagree with. I...
--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 14, 2009 at 8:46 pm

#1092323
RE: Coincidence or Causality

Paul White (12/13/2009)
Steve Jones - Editor (12/13/2009)
Paul, that's interesting. I've not seen people writing joins as groups like you have. I think those parens are affecting things.
No parentheses version:
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)

December 14, 2009 at 8:22 pm

#1092319
RE: Values from row to columns as indicator

I just can't resist helping someone who took the time to make it so easy for me to help. Well done on the original post.
This will do 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)

December 14, 2009 at 8:18 pm

#1092317
RE: Looking for Sample Data set of US States, Cities, Zip codes

Do you need accurate data for this or just a large amount of data to play 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)

December 14, 2009 at 8:09 pm

#1092315
RE: Extracting from a very wide table

aaa-322853 (12/14/2009)
I need to extract and stage a mainframe table which has 1000+ columns into SQL Server. Do you guys have ANY advice on the most efficient method to do...
--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 14, 2009 at 8:05 pm

#1092314
RE: Inserting Next Row

I have to ask... what if someone needs a 4th WBS code?
--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 14, 2009 at 8:03 pm

#1092313
RE: Need help to find hard-coded IP in Stored Procedures

I suppose you can trim down the WHERE clause in Paul's good code with the minor risk of finding things you didn't intend to...
WHERE
definition LIKE '%[0-9].[0-9].[0-9]%'...
--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 14, 2009 at 7:51 pm

#1092310
RE: How Does SQL Reuse Data Pages?

First, the temporal clustered index you mention will help a lot. There's another trick associated with this type of "rolling delete" but I have a couple of questions, first.
1....
--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 14, 2009 at 7:45 pm

#1092309
RE: Running T-SQL statement on all Databases

To go along with what Bru said, if you want folks to give you a coded answer, please see the first link in my signature below to help you help...
--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 14, 2009 at 7:41 pm

#1092306
RE: Convert String to a Table using CTE

Paul White (12/14/2009)
I don't think it set out to provide the most performant solution, just an interesting technique, which I guess it is.
Heh... true enough... almost like that whacko 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)

December 14, 2009 at 4:26 pm

#1092291
RE: Convert String to a Table using CTE

Paul White (12/14/2009)
sam.walker (12/14/2009)
Paul White, I am certain this is not correct.
One of the longest threads ever on SSC was devoted to this: http://www.sqlservercentral.com/Forums/Topic695508-338-17.aspx
There is a handy summary of 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)

December 14, 2009 at 3:19 pm

#1092264
RE: Convert String to a Table using CTE

Fatal Exception Error (12/14/2009)
Based on my earlier question
Fatal Exception Error (12/14/2009)
Why should I use this method versus using a good old fashioned Numbers table?
It is safe to say that 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)

December 14, 2009 at 1:03 pm

#1092188
RE: Convert String to a Table using CTE

Adam Haines (12/14/2009)
Jeff Moden (12/14/2009)
Aaron Gonzalez-394690 (12/14/2009)
I second Roland's comment.
I was involved in a similar situation before and since we were working with sql server 2005 I had the developer...
--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 14, 2009 at 11:45 am

#1092128
RE: Convert String to a Table using CTE

Roland Howard Boorman (12/14/2009)
I simply use XML.
Using XML whole complex structures can be passed to SQL and treated as Tables.
You can use Functions with the XML to render these...
--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 14, 2009 at 11:20 am

#1092116

Viewing 15 posts - 40,681 through 40,695 (of 59,098 total)