Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,751 through 36,765 (of 59,099 total)

RE: Converting a table variable into a permanent table

I'll second 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)

September 17, 2010 at 5:29 pm

#1223394
RE: Are the posted questions getting worse?

Tom.Thomson (9/17/2010)
Jeff Moden (9/17/2010)
... DBAs and DBA's are both acceptable ...
Surely not socially?
Unless perhaps it's a case of Angelic possession.
Heh... you tell me... they let Steve out to...
--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)

September 17, 2010 at 5:18 pm

#1223389
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/17/2010)
GilaMonster (9/17/2010)
Jeff Moden (9/17/2010)
GilaMonster (9/17/2010)
Steve Jones - Editor (9/17/2010)
Too slow! Removing a lot of SPAM this morning, and disabling some accounts.
Yeah, there was quite a collection this morning....
--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)

September 17, 2010 at 5:16 pm

#1223388
RE: Are the posted questions getting worse?

Heh... this place is going to hell in a handbasket. I got a shirt for going over 3k. I got a shirt for going over 5k. 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)

September 17, 2010 at 5:11 pm

#1223387
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/17/2010)
Has anybody else noticed how close SSC is to 1 million posts overall?
Any bets on if we could get that done by the end of the year?
Only ~12000 posts...
--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)

September 17, 2010 at 5:07 pm

#1223385
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/17/2010)
Trey Staker (9/17/2010)
CirquedeSQLeil (9/17/2010)
Just curious if anybody here has ever walked out of an interview...What would be your justifications for doing so?
I've never walked out on an interview but...
--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)

September 17, 2010 at 5:04 pm

#1223384
RE: Temp Tables and Tuning Advisor

rickK_ (9/17/2010)
Does anyone know why various #temp tables fail the analyzer and \or Display Estimated Execution Plan with an Invalid object name error. The proc works fine, 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)

September 17, 2010 at 2:11 pm

#1223313
RE: Usually never get good answers on this forum but here it goes

"Usually never get good answers on this forum but here it goes"
We're even then. We usually never get good questions on this forum, either. 😉
--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)

September 17, 2010 at 12:11 pm

#1223254
RE: How to Post Performance Problems

I'll go one step further... This article and its T-SQL Equivalent should be sticky noted to the beginning of most of the forum selections.
--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)

September 17, 2010 at 11:57 am

#1223247
RE: Are the posted questions getting worse?

Jeff Moden (9/17/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
'postro-fees are also used to show a bit o' an accent.
Still a contraction (left out letters)
Where they should NOT be used..
In fantasy/sci-fi 'languages...
--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)

September 17, 2010 at 10:49 am

#1223188
RE: Are the posted questions getting worse?

GilaMonster (9/17/2010)
Steve Jones - Editor (9/17/2010)
Too slow! Removing a lot of SPAM this morning, and disabling some accounts.
Yeah, there was quite a collection this morning. I think I made like...
--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)

September 17, 2010 at 10:46 am

#1223187
RE: Are the posted questions getting worse?

GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
'postro-fees are also used to show a bit o' an accent.
Still a contraction (left out letters)
Where they should NOT be used..
In fantasy/sci-fi 'languages to persuade...
--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)

September 17, 2010 at 10:41 am

#1223179
RE: XML "CSV" Splitter

Yep... sorry, Peter. I meant to say that I tested that method, as well. It's not nearly as bad as the original dot version but, you're correct, it's...
--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)

September 17, 2010 at 6:18 am

#1222917
RE: Using a common seed generation for multiple tables.

I'm curious... Why do the folks that imposed this requirement think that it's a good idea 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)

September 16, 2010 at 10:01 pm

#1222729
RE: Query help -employee

SSISLearner (9/16/2010)
Is there any way to get this list from a single query using CTE's.
The query that Wayne wrote will certainly do the "single query" thing correctly. Just be...
--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)

September 16, 2010 at 9:57 pm

#1222727

Viewing 15 posts - 36,751 through 36,765 (of 59,099 total)