Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,041 through 35,055 (of 59,102 total)

RE: How to summarise, listing on same line

timotech (2/15/2011)
Thanks for your reply, how do i use the FOR PATH XML?
Thanks
Sorry. I'm at work right now and can't do a detailed example until I get home tonight....
--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 15, 2011 at 12:25 pm

#1287265
RE: Tuning on parallel processing

sql_butterfly (2/15/2011)
Any help ?
Did you make the corrections I suggested?
--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 15, 2011 at 12:23 pm

#1287264
RE: Understanding Indexes

GilaMonster (2/15/2011)
Jeff Moden (2/15/2011)
Since I'm not an expert on indexes that you good folks are, can you confirm that the bolded statements in the above quote are, depending...
--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 15, 2011 at 12:19 pm

#1287261
RE: Understanding Indexes

Grant Fritchey (2/15/2011)
Jeff Moden (2/15/2011)
Grant Fritchey (2/15/2011)
Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT
statements.
But not in JOIN criteria? No,...
--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 15, 2011 at 12:16 pm

#1287258
RE: Abnormal growth of temp db

ganeshkumar005 (2/15/2011)
I can see abnormal growth of temp db during a update query:
UPDATE tlstagingdb.dbo.tbltlxyz SET lImpStatus = 10 where limpidentity in ( select xxxxxxxxxxxxxxxxxxxxx)
select subquery works excellent 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)

February 15, 2011 at 8:14 am

#1287103
RE: whether really any column gets changed in updated row?

karthimca07 (2/15/2011)
checksum uses more resources in my case.
as i have to check more than 20 columns off different types.
how columns_updated works?
if want random columns means how do i please help
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)

February 15, 2011 at 8:08 am

#1287100
RE: Understanding Indexes

Grant Fritchey (2/15/2011)
Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT
statements.
But not in JOIN criteria? No, no way. The basic...
--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 15, 2011 at 7:46 am

#1287082
RE: Understanding Indexes

Gail and Grant (or anyone else that can jump in),
The article also has the following statements:
...[font="Arial Black"]whereas, with a nonclustered index the leaf level contains the address to the data...
--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 15, 2011 at 7:30 am

#1287062
RE: Datewise Cummulative total for particular customer

chintalagiriprakash (2/14/2011)
hi Jeff
i donot know why it is not working i wrote the query as u mention in the link but i could not get the result
thanks...
--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 15, 2011 at 12:11 am

#1286878
RE: parse XML using sql

nadabadan (2/14/2011)
http://technet.microsoft.com/en-us/library/ms345122(SQL.90).aspx is a good white paper on XQuery that you may want to look at.
At the bottom of this white paper are links to three other decent xml...
--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 14, 2011 at 11:12 pm

#1286868
RE: Tuning on parallel processing

sql_butterfly (2/14/2011)
Gail, I read your article again and again. That's interesting but still I'm not able to get solution. Can you check for example the attached execution plan and Statistics...
--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 14, 2011 at 11:08 pm

#1286866
RE: How do I return data as subset of another table?

darryljm (2/14/2011)
Example I have two tables "Labor" and "Parts" need to return as follows
Labor field 1
Part1
Part2
Part3
Labor field2
Part1
Part2
Part3
Any help would be appreciated
I believe you should only have 1 labor field in...
--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 14, 2011 at 10:02 pm

#1286847
RE: Cursor and case function

frecapi (2/14/2011)
No I didn't think about that. Something like:
Select ID, apn, (select permit_1 from #mytable), from #mytable union all
Select ID, apn, (select permit_2 from #mytable), from #mytable....
Yep... kind 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)

February 14, 2011 at 10:00 pm

#1286845
RE: Proc runs slow only during business hours?

You might also want to do a server side trace and find out what's using most of the CPU time.
--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 14, 2011 at 9:54 pm

#1286842
RE: Cursor and case function

frecapi (2/14/2011)
There can only be a maximum of 8 permits per record. There can be more than 8 records per APN in which case the permitnum would equal permit_8...
--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 14, 2011 at 9:01 pm

#1286834

Viewing 15 posts - 35,041 through 35,055 (of 59,102 total)