Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,636 through 34,650 (of 59,099 total)

RE: Why Sql Server fails to use index?

Boy, do I need some sleep or what. You're, of course, spot on, Gail. I'm not sure where my comment came from. :blush:
--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)

March 13, 2011 at 3:26 pm

#1298154
RE: Group by

Hey! Looki there! Haven't seen you in a while. How ya doin', Seth?
--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)

March 13, 2011 at 3:23 pm

#1298152
RE: Trouble with CTE

pietlinden (3/13/2011)
Now all I gotta do is get my head around how it all works. Thanks, Jedi master!
Me too. I always seem to lose my mind on non-DAG...
--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)

March 13, 2011 at 3:19 pm

#1298151
RE: Serialising tabular and relational data.

Phil Factor (3/13/2011)
Do I think we should keep looking for a more universal, metadata and format rich format? Absolutely because, right now, you can't even just copy and paste between...
--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)

March 13, 2011 at 11:26 am

#1298129
RE: Export from SQL to Excel 2007 format

Ken Davis (3/11/2011)
Sushant, Gosta,
Thanks for the ideas. In this case the business users are used to opening the output Excel files on a fileshare. I don't want 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)

March 13, 2011 at 12:38 am

#1298085
RE: Statements that involve temp tables (#) are not properly reusing plans

Did you test 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)

March 13, 2011 at 12:25 am

#1298081
RE: Statements that involve temp tables (#) are not properly reusing plans

jfong-786685 (3/12/2011)
We are submitting multiple dynamic sqls that are using temp tables. For example, let say we submit the 3 below statements which are identical and parameterized:
INSERT INTO #DATAMART_DBO_PERF_TOTAL_EXTENDED...
--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)

March 12, 2011 at 10:56 pm

#1298078
RE: How to know when to run FreeProcCache

Hmmmm... I'm thinking it may be something else. Perhaps the explicit CROSS JOIN in the ORM code is causing a wee bit of a performance problem?
--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)

March 12, 2011 at 10:24 pm

#1298075
RE: Trouble with CTE

Ah, fooii. The data doesn't form a "DAG" or "Directed Acyclic Graph". Instead, it has "cycles" in it... in other words, "children with more than one parent" 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)

March 12, 2011 at 10:19 pm

#1298074
RE: Trouble with CTE

Ah! I may have figured it out.
--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)

March 12, 2011 at 10:11 pm

#1298073
RE: Trouble with CTE

Pieter,
Using the data you were kind enough to provide in a readily comsumable format, what do you expect for output?
--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)

March 12, 2011 at 10:10 pm

#1298072
RE: index:predicate:converrt_implicit? after changing code performance improved

sqldba_icon (3/12/2011)
we had index seek on 12 million records table. The cost was 14 on this table. Mentioned below is the predicate:
CONVERT_IMPLICIT(int,[MyDB].[dbo].[RTE].[RKey] as [r1].[RKey],0)=[@RId]
This was joining on a column like...
--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)

March 12, 2011 at 10:01 pm

#1298071
RE: NoSQL is Not the Answer

NoSQL types of databases may, in fact, be the answer. Now, lets figure out what the question is. 😛
If you need a database that is essentially nothing but 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)

March 12, 2011 at 9:57 pm

#1298070
RE: Why Sql Server fails to use index?

But there is no obvious advantage for this query btw clustered and nonclustered index.
Maybe not. But you're really going to hate yourself if this table get's any depth...
--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)

March 12, 2011 at 8:04 pm

#1298066
RE: Displaying Sorted Hierarchies (SQL Spackle)

Very cool compliment. :blush: Thanks Mishaluba!
I aim to please. I sometimes miss but I'm always aiming. 😀
--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)

March 12, 2011 at 7:30 pm

#1298061

Viewing 15 posts - 34,636 through 34,650 (of 59,099 total)