Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,016 through 33,030 (of 59,099 total)

RE: Performance problem.

srinath.vanama (8/1/2011)
Hi Folks,
am facing a performance problem in one server like there are so many blockings are occured on the server which becomes SQL server is using more CPU memory...
--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)

August 2, 2011 at 7:37 am

#1362149
RE: Funny calculation and grouping problem

Ninja's_RGR'us (8/2/2011)
Nope, I was going with round 2.
I always wait 24H before actually posting anything in case this is an exam or cert or late homework.
I was hoping for an...
--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)

August 2, 2011 at 7:13 am

#1362131
RE: Binary Tree Node Counting Problem Please Help Me!

Same message, talktosivas... lots of people want and need help and lots of good people on the forums want to test their answer against some data before posting their coded...
--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)

August 2, 2011 at 7:05 am

#1362128
RE: Funny calculation and grouping problem

johnsonchase7 (8/1/2011)
Very great point Jeff. here is a DDL that should be fine for all versions.
CREATE TABLE #TEMP
(ID INT, VALUE INT)
INSERT INTO #TEMP
select 0, 21 union all
select 1, 98...
--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)

August 2, 2011 at 6:58 am

#1362119
RE: Funny calculation and grouping problem

Ninja's_RGR'us (8/2/2011)
Ignoring the <uselessly> complexe query by peso... so what did you come up with?
Ummm... did you miss it, Remi?
I tried the following but the group by makes 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)

August 2, 2011 at 6:49 am

#1362108
RE: No Parallelism When using Row level function

Leo.Miller (8/1/2011)
I can't see any real benefit of using an iTVF, since as far as I can see, [font="Arial Black"]you can still only pass it a single paramater[/font], even though...
--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)

August 2, 2011 at 6:34 am

#1362095
RE: No Parallelism When using Row level function

Leo.Miller (8/1/2011)
Since an iTVF is typically only called once it would be much like Vijay's original solution with the case statement, it would just be moved to the iTVF.
Hmmm......
--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)

August 2, 2011 at 6:31 am

#1362093
RE: Funny calculation and grouping problem

As a side bar, I think it's really cool that you have 2K8. I also think it's really cool that you've learned to use the "new" Insert/Values. 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)

August 1, 2011 at 7:48 pm

#1361931
RE: What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?

Pagan DBA (8/1/2011)
-- Which is FASTER?
Do what any of us would do... TEST IT and see! 😉
--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)

August 1, 2011 at 7:40 pm

#1361930
RE: simple question

Heh... Joe who? 😉
--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)

August 1, 2011 at 7:37 pm

#1361929
RE: No Parallelism When using Row level function

Leo.Miller (8/1/2011)
In line functions aren't actually compliled into the code, they are still external functions that need to be called.
I agree that's true about Scalar and mTVF's (multi-line Table Valued...
--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)

August 1, 2011 at 6:56 pm

#1361922
RE: Binary Tree Node Counting Problem Please Help Me!

If you really want help, post the data in a readily consumable format. See the first link in my signature line below for how to do that correctly.
As a...
--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)

August 1, 2011 at 6:52 pm

#1361921
RE: CAREER ADVICE : From DBA to the world of BI

Buy a copy of the SQL Server Developer's Edition (which will run fine on most home machines without Window's Server) and practice on your own. Buy a book on...
--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)

August 1, 2011 at 6:48 pm

#1361920
RE: indexing a converted datetime column

opc.three (8/1/2011)
Somewhere along the line I think you zigged and I zagged.
BWAAA-HAAA!!! No... it's not you. I just went back and reread the original post and see 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)

August 1, 2011 at 5:32 pm

#1361905
RE: binary tree calculation

HLogic (8/1/2011)
Jeff,
I have tested the HierarchyID and associated functions against Adjacency Lists using CTE's, Nested Sets (a la Celko) and Nested Intervals (Hazel's implemetation) and found it to be lacking...
--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)

August 1, 2011 at 6:58 am

#1361513

Viewing 15 posts - 33,016 through 33,030 (of 59,099 total)