Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,961 through 36,975 (of 59,102 total)

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
RE: Are the posted questions getting worse?

BrainDonor (9/8/2010)
Apparently tomorrow will be the 65th anniversary of the first computer bug:
http://www.history.navy.mil/photos/images/h96000/h96566kc.htm
From that point on all developers had a job for life.
Those types of trivia are always interesting. ...
--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:42 am

#1217833
RE: Tips for writing queries needed

Lynn Pettis (9/7/2010)
With respect, the fact that you say you will run it tells me you did dismiss my suggested query out of hand without even giving it a try...
--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:33 am

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

Data this type of thing is stored as the Least Significant Byte First (on the "left"). That's why it appears to be backwords. Then, within each byte, 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 7, 2010 at 3:36 pm

#1217649
RE: Need high resource expensive sql queries

Madhivanan-208264 (9/7/2010)
Have a million row table and do running total using a triangular join
select col,
(select sum(col) from table as t1 where t1.pkcol<=t2.pkcol) as run_sum
from table as t2
Heh... ya beat me...
--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 7, 2010 at 3:20 pm

#1217640
RE: Recursive select using UDF against a table?

rschaeferhig (9/7/2010)
Jeff,
Thanks for all your work on this.
I already have a function similar to your dbo.GetEmployeeDownLine(ID) function. My end use case is that I need a table of all 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 7, 2010 at 1:31 pm

#1217568
RE: Table pivot

Abhijit More (9/6/2010)
trying doing it by using PIVOT operator. below is the example
DECLARE @Params AS TABLE
(
ParameterID NVARCHAR(8) NOT NULL,
...
--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 7, 2010 at 11:54 am

#1217513
RE: Circular reference

the_rutter (9/6/2010)
Is it valid design for TableA to reference TableB (foreign key) and TableB to reference back to TableA (foreign key)? Or is this circular reference *always* bad?
Ok... your turn....
--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 7, 2010 at 11:52 am

#1217512
RE: Increment by 10 Column Value in select Query

shankaran_sraj (9/7/2010)
Hi everyone,
I having a table Tran_Id in that table two columns Id and Sno.
ID SNO
1 5124
2 ...
--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 7, 2010 at 11:44 am

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

Paul White NZ (9/7/2010)
WayneS (9/7/2010)
Have you got some references you can pass on about how the optimizer works?
For sure:
Craig Freedman: http://blogs.msdn.com/b/craigfr/
SQL Server Storage Engine: http://blogs.msdn.com/b/sqlserverstorageengine/
CSS: http://blogs.msdn.com/b/psssql/
Query Processing: http://blogs.msdn.com/b/sqlqueryprocessing/
White Papers: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx
SQLCAT:...
--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 7, 2010 at 11:16 am

#1217476
RE: Hidden or Unknown Job Perks

Steve Jones - Editor (9/5/2010)
Jeff Moden (9/4/2010)
...
So walking in with a hank of beef jerky hanging out of your mouth would be frowned upon? 😛
like pentagram tatoos at an interview...
--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 6, 2010 at 2:33 pm

#1217046
RE: Increase buffer size programmatically in SQL 2000 using T-SQL

SQL_Quest-825434 (9/6/2010)
Jeff,
Can you quote the how this can be done.. just curious to know ..:-)
There's an undocumented stored procedure that you can use to write to the registry for...
--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 6, 2010 at 2:27 pm

#1217044

Viewing 15 posts - 36,961 through 36,975 (of 59,102 total)