Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,906 through 46,920 (of 59,101 total)

RE: Results is doulbe the real results

Not sure why they're exactly doubled because you've created an "accidental cross-join" and they should be a lot more than just doubled. Moot point, though. Let's fix...
--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)

November 30, 2008 at 8:44 am

#905250
RE: Can someone explain / point me to any article that explains how SQL Server performs joins

Yes... all joins basically fall into 3 categories behind the scenes... Hash, Merge, or Looping. A 10,000 foot overview for each is availbable in Books Online (BOL) and 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)

November 30, 2008 at 8:23 am

#905248
RE: appropriate use of triggers

I agree with Gail... those are about the only things I use triggers for. That includes the ability to keep people from changing DateCreated/Modified or CreatedBy/ModifiedBy columns. Other...
--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)

November 30, 2008 at 8:02 am

#905245
RE: Using a variable to form part of a table name in stored procedure

The cool part about your solution, Chris, is...
... it's not dynamic SQL... just good, clean, hard-coded concatenation.
--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)

November 30, 2008 at 7:45 am

#905244
RE: temp table vs subquery

GilaMonster (11/30/2008)
Jeff Moden (11/29/2008)
Your good explanation is, of course, the most accurate... I was just trying to give a 30,000 ft overview.
No prob. I was just worried 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)

November 30, 2008 at 7:43 am

#905243
RE: CLR Stored procedure without visual studio?

Great information, one and all... but I still want to know what the CLR(s) the op wants to write do. We all know that too many people give up...
--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)

November 30, 2008 at 7:42 am

#905242
RE: stored procedure---finding all tables that contain a specific column

Chris Morris (11/30/2008)
Jeff Moden (11/29/2008)
Heh... not to worry... it's not as bad as that dummy that thought the sum of the differences between two points could be used to determine...
--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)

November 30, 2008 at 7:39 am

#905241
RE: Are the posted questions getting worse?

Grant Fritchey (11/30/2008)
The broke chain wipped around and touch my face & shirt.
Wow... last guy I heard of that happening to had to have major reconstructive surgery... you're a lucky...
--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)

November 30, 2008 at 7:36 am

#905240
RE: Are the posted questions getting worse?

Jonathan Kehayias (11/29/2008)
Jeff Moden (11/29/2008)
Jonathan Kehayias (11/29/2008)
I'll never understand the attitude that I see people take, when the post a simple question and someone posts a BOL reference instead of...
--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)

November 30, 2008 at 7:31 am

#905239
RE: Are the posted questions getting worse?

What's really amazing to me is that this thread has taken over 5,000 hits. D'ya s'pose anyone is actually learning anything for this? We can only hope.
Good chattin'...
--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)

November 29, 2008 at 7:32 pm

#905202
RE: CLR Stored procedure without visual studio?

brijbmishra (11/28/2008)
Can we develop a CLR based Stored Procedure without using Visual Studio?
What do you intend the CLR 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)

November 29, 2008 at 7:17 pm

#905201
RE: What do you use to copy large backups

Heh... not trying to be a smart guy here... FEDEX overnight. Works great.
--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)

November 29, 2008 at 7:00 pm

#905199
RE: Are the posted questions getting worse?

Lynn Pettis (11/29/2008)
Sometimes even those of us with lots of points to left need help. Heck, I think I even have seen Jeff post a question or two here.
Yep......
--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)

November 29, 2008 at 6:54 pm

#905197
RE: Using a variable to form part of a table name in stored procedure

Either that, or a partitioned view.
--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)

November 29, 2008 at 6:11 pm

#905194
RE: remove sql server date time default value

Charles Kincaid (11/29/2008)
Best to store unknown dates as NULL anyway.
I agree... if you don't know a date, store it as a NULL and convert it in the GUI.
Some folks store...
--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)

November 29, 2008 at 5:52 pm

#905190

Viewing 15 posts - 46,906 through 46,920 (of 59,101 total)