Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,046 through 33,060 (of 59,099 total)

RE: Except vs. Left Join vs. Not Exists

There's another thing to consider. IIRC, both INTERSECT and EXCEPT essentially do a NULL = NULL comparison without any special considerations. If such a thing is required by...
--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 30, 2011 at 8:42 pm

#1361275
RE: Are the posted questions getting worse?

ALZDBA (7/30/2011)
Normally Jeff always test stuff 😉
I certainly blew a pork chop bone out of my nose on that one. :blush:
He must have the shivers experiencing all 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)

July 30, 2011 at 6:33 pm

#1361270
RE: Are the posted questions getting worse?

Gianluca Sartori (7/30/2011)
Jeff Moden (7/29/2011)
Gianluca Sartori (7/29/2011)
I'm inaugurating my "Vote for Jeff" signature. 😎
BWAA-HAAAA!!!! VERY cool, Gianluca. And, Uncle Sam is my favorite patriotic character to boot!
The only...
--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 30, 2011 at 4:45 pm

#1361267
RE: Using xp_cmdshell to copy files to a sql server on a different domain

Heh... understood. Someday, we'll have to sit down, have a beer or two together, and I'll try to explain it all. It won't change your mind (nor 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)

July 30, 2011 at 2:10 pm

#1361260
RE: indexing a converted datetime column

opc.three (7/29/2011)
In this case, sure, I am up for defending a decision like this. It may be unappealing, but after thinking it through I don't have a problem with it.
Understood....
--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 30, 2011 at 12:48 pm

#1361256
RE: Issue on Flat Files to tables with fixed positioning: Thanks

varun_2003 (7/30/2011)
For example I am declaring a var at the package level and reading the rows from the flat file into the variable like "1000,200,01/01/2011"(which is actually (Orderid,cost,date). How 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)

July 30, 2011 at 8:19 am

#1361224
RE: Issue on Flat Files to tables with fixed positioning: Thanks

varun_2003 (7/29/2011)
@jeff - Thanks for your response and I do understand the reason behind why you had mentioned.. I am in the learning process and correct myself as needed 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)

July 29, 2011 at 7:15 pm

#1361183
RE: Create Random Generated Primary Key

PaulB-TheOneAndOnly (7/29/2011)
Sean Lange (7/27/2011)
I often tell business people (which are the ones that usually ask for this kind of silliness) that primary keys are used by the system and therefore...
--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 29, 2011 at 6:37 pm

#1361181
RE: indexing a converted datetime column

Orlando, can you honestly say that the format of a date stored in a database should actually matter for a user that's apparently set to writing queries against something 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 29, 2011 at 6:26 pm

#1361180
RE: how to find ASCII characters in a table?

Heh... also... why on Earth does it have to be a "single query"? You doing something for a contest or what? 😉
--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 29, 2011 at 6:09 pm

#1361178
RE: how to find ASCII characters in a table?

ranuganti (7/29/2011)
I have this type of ASCii characters in the column how do i find all in a single query other than [font="Arial Black"]alphanumarics[/font].
Let's peel one potato at a time......
--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 29, 2011 at 6:08 pm

#1361177
RE: Using xp_cmdshell to copy files to a sql server on a different domain

opc.three (7/29/2011)
Why do you insist on using T-SQL to turn SQL Server into a sys admin scripting platform when there are better tools out there to do the job?
Because 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 29, 2011 at 6:01 pm

#1361176
RE: Are the posted questions getting worse?

Gianluca Sartori (7/29/2011)
I'm inaugurating my "Vote for Jeff" signature. 😎
BWAA-HAAAA!!!! VERY cool, Gianluca. And, Uncle Sam is my favorite patriotic character to boot!
The only thing that would make...
--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 29, 2011 at 5:49 pm

#1361172
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (7/29/2011)
Interesting rant here: http://www.insanit.net/technology/smartphone-rants-3-what-do-i-want-a-real-windows-smartphone-when-do-i-want-it-now/
Anyone else see the need/value here? I'm struggling to see if this is something that has value.
Heh... yeah... that's what I want......
--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 29, 2011 at 5:39 pm

#1361171
RE: Are the posted questions getting worse?

Ninja's_RGR'us (7/29/2011)
I'm working on a PIT restore script demo and those messages are a little annoying and ad no (very little) value.
I haven't done a deep dive on it (against...
--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 29, 2011 at 5:32 pm

#1361170

Viewing 15 posts - 33,046 through 33,060 (of 59,099 total)