Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,811 through 39,825 (of 59,072 total)

RE: Time Bomb Coding

nicholasw (2/10/2010)
Instead of:
IF EXISTS(SELECT 1 FROM ......WHERE....)
Would the following be quicker still?
IF EXISTS(SELECT TOP 1 1 FROM ......WHERE....)
Why not just test it to be sure or not? 😉
--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)

February 10, 2010 at 7:57 pm

#1117320
RE: Single column to multiple columns

Jeff Moden (2/10/2010)
Yes there is. Does the table with this data in it have a Primary Key?
Never mind... can't wait. This will work with or without a primary...
--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)

February 10, 2010 at 7:52 pm

#1117317
RE: Single column to multiple columns

Yes there is. Does the table with this data in it have a Primary Key?
--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)

February 10, 2010 at 6:10 pm

#1117298
RE: Democratizing the Microsoft MVP Award

Steve Jones - Editor (2/10/2010)
Nooooooooo, I was hoping not to manage anyone but myself.
Cool... makes us even. I was hoping to not be managed by anyone but myself. ...
--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)

February 10, 2010 at 5:24 pm

#1117291
RE: Democratizing the Microsoft MVP Award

CirquedeSQLeil (2/10/2010)
So, does that make Steve our working manager?
Heh... for me, that's at least partially true. He tells me to shutup when I get out of line, occasionally tries...
--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)

February 10, 2010 at 1:10 pm

#1117157
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

RBarryYoung (2/10/2010)
Tom.Thomson (2/10/2010)
...There just isn't any way (that I've found) inside T-SQL of reading multiple rowsets returned by a stored procedure; multiple result sets can be passed from one SP...
--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)

February 10, 2010 at 1:05 pm

#1117109
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

m.ehrt (1/8/2010)
Great article! An eye-opener in every possible way ... even in the 'not recommended loops' code snippets I found stuff I had never seen before.
Cheers
Michael
Sorry for the really late...
--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)

February 10, 2010 at 7:11 am

#1116793
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

True enough and even though I quoted what was said, I missed the "ADO" part because I tend to think in terms of "large batches" on the T-SQL side and...
--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)

February 10, 2010 at 7:00 am

#1116781
RE: Democratizing the Microsoft MVP Award

GilaMonster (2/9/2010)
Steve Jones - Editor (2/9/2010)
Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly...
--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)

February 10, 2010 at 6:52 am

#1116771
RE: Democratizing the Microsoft MVP Award

Steve Jones - Editor (2/9/2010)
Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly technical...
--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)

February 9, 2010 at 7:46 pm

#1116539
RE: Democratizing the Microsoft MVP Award

Steve Jones - Editor (2/9/2010)
The other problem is that the MVP is a community service award, but perceived as a technical one. I know a lot about SQL Server, 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)

February 9, 2010 at 5:50 pm

#1116483
RE: Can stats be auto-updated at less than 20%

Very cool! Thanks for the feedback.
--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)

February 9, 2010 at 5:08 pm

#1116474
RE: DBCC Timewarp

Alvin Ramard (2/9/2010)
GSquared (2/9/2010)
Lowell (2/8/2010)
you guys have show some great examples of using a future backup to fix todays data, but I've got a question along a similar vein:
somehow I've...
--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)

February 9, 2010 at 4:53 pm

#1116465
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

Just to clarify a bit... Andrew's question was more on why I used "hh" instead of "dd" and he was right... it should have been "dd" where I made 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)

February 9, 2010 at 3:45 pm

#1116440
RE: Query designer, some options are greyed out

Heh... I use Query Designer about 0nce every 8 years whether I need to or not. I've not ever used the Query Designer in 2k5 before. No 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)

February 9, 2010 at 8:50 am

#1116171

Viewing 15 posts - 39,811 through 39,825 (of 59,072 total)