Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,946 through 36,960 (of 59,098 total)

RE: Are the posted questions getting worse?

Heh... and HELLLLLL NOOOO!!!! There's no way I'm setting up a Twitter account.
--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 8, 2010 at 10:06 pm

#1218344
RE: Are the posted questions getting worse?

Speaking of bull... I just signed up to do 2 sessions for SQL Saturday #60. What's up with the SQL Saturday site, anyway? The "blog" link goes 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 8, 2010 at 10:05 pm

#1218342
RE: Are the posted questions getting worse?

Alvin Ramard (9/8/2010)
Jeff Moden (9/8/2010)
Withdrawn... it was just a little too racy...
Too much bull? 😛
Yep... sometimes I forget that even though this is a water cooler forum, there are...
--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 8, 2010 at 10:00 pm

#1218341
RE: Columns_Updated() in update trigger reverses the bitmask?

Craig Farrell (9/8/2010)
Please note the sample build code in the original post, where it shows that the first set of columns (for more then 8 fields) are in the most...
--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 8, 2010 at 9:51 pm

#1218340
RE: Are the posted questions getting worse?

Withdrawn... it was just a little too racy...
--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 8, 2010 at 9:45 pm

#1218338
RE: Columns_Updated() in update trigger reverses the bitmask?

Your test code is working with Varbinary... not with Columns_Updated.
--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 8, 2010 at 12:27 pm

#1218165
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/8/2010)
I think more interesting is will The Thread beat me to 30k
I'm still trying to catch you as well. 😉
--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 8, 2010 at 11:57 am

#1218139
RE: An Informal Look at Database Performance

Well done, Timothy. Definitely "brief case" time for this article. Thanks for taking the time to make it so complete.
The idea of having a baseline and the idea...
--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 8, 2010 at 6:45 am

#1217888
RE: An Informal Look at Database Performance

mortenmaate (9/8/2010)
Thanks a lot for the great overview !
One thing I would like to mention additionally: Look a the SQL Server version. In my experience many companies upgrade their SQL...
--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 8, 2010 at 6:32 am

#1217883
RE: Table pivot

ioani (9/7/2010)
The solution I found for the problem:
-- Input data--
IF OBJECT_ID('#Params') IS NOT NULL
DROP TABLE #Params
CREATE TABLE #Params
(
ParameterID NVARCHAR(8) NOT NULL,
ParameterValue SQL_VARIANT...
--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 8, 2010 at 5:39 am

#1217856
RE: Table pivot

LutzM (9/7/2010)
Quite a while ago I thought using PIVOT would be, well... "cool".
After I figured how the syntax needs to be I was surprised that it didn't provide any performance...
--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 8, 2010 at 5:22 am

#1217847
RE: Need high resource expensive sql queries

Madhivanan-208264 (9/8/2010)
The avatar you used is very good
Are you a designer too? 🙂
No... someone else did most of the work. I just overlaid the word "RBAR" and converted 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)

September 8, 2010 at 5:17 am

#1217845
RE: Please don’t Tweet this, but…

suriqx (9/8/2010)
SQLBill (9/7/2010)
BTW-Privacy is just about gone. The latest loss of privacy is with pictures. New cameras (even those on smart phones) are starting to include GeoTagging. ...
--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 8, 2010 at 5:14 am

#1217844
RE: Inside the Optimizer: Constructing a Plan - Part 1

Anam Verma (9/7/2010)
Paul,
In the part1, you have mentioned about SELonJN operation, how it can be enabled?
It will be really handly if you'll also post the changes you made to 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 8, 2010 at 5:04 am

#1217842
RE: Columns_Updated() in update trigger reverses the bitmask?

Craig Farrell (9/7/2010)
or I'm misunderstanding what you're saying.
That may be true... from BOL 2k (had a handy reference there)...
F. Use COLUMNS_UPDATED to test more than 8 columns
If you must test...
--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 8, 2010 at 4:51 am

#1217835

Viewing 15 posts - 36,946 through 36,960 (of 59,098 total)