Viewing 15 posts - 151 through 165 (of 1,825 total)
Hi ,
The difference will be shown in the execution plan.
Try this article for starters
http://www.simple-talk.com/sql/performance/execution-plan-basics/
BTW this syntax 'year(p.created_date)<=2010' is non-sargable. Basically this means that sqlserver will be unable to...
November 28, 2011 at 12:01 am
Hmm , Indeterminate i would say.
It does sound as if your design is wrong, why have you two identity columns ?
November 21, 2011 at 12:00 am
Obviously homework,
Can you show us what you have attempted so far.
November 20, 2011 at 11:58 pm
niteen2009 (10/20/2011)
Thank you sir for reply.Plz find attached query execution plan.
the database is in oracle.
Thanks.
Then im afraid, im not going to be able to help you...
October 20, 2011 at 12:23 am
Please see this article on how to post performance problems, thanks.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 20, 2011 at 12:00 am
vince_sql (10/6/2011)
You can do cumulative totals using a correlated subquery.
SELECT id,dt,amt,(SELECT SUM(amt) FROM #t b WHERE a.id = b.id AND a.dt >= b.dt)
FROM #t a
I would very much advise against...
October 6, 2011 at 11:33 pm
Hi ,
Running totals can be solved but are quite inefficient,
You have 3 options :
Triangular join ( Very Slow)
Quirky Update ( Lot of hoops to jump through)
Cursor (blurgh and slow)
In Denali...
October 5, 2011 at 5:49 am
Ok ......
Sounds like a good enough reason then.
October 3, 2011 at 7:54 am
Sounds like it *could* have been using an old cached plan.
After you created the NC index did you flush the cache (DBCC FREEPROCACHE) ?
October 3, 2011 at 7:26 am
Thx, shame you cant make it, keep an ear out for the next one
October 3, 2011 at 7:05 am
First off , look at the execution plan to see what has happened rather than guessing.
If you are not upto speed , then i would recommend Grants free , yes...
October 3, 2011 at 6:52 am
Nope , you would of had to of put any logging in place before the event occured.
SQLServer does not keep track of this by default.
October 3, 2011 at 4:35 am
It would be easier for everyone involved if you kept to one thread per subject.
http://www.sqlservercentral.com/Forums/Topic1184288-391-1.aspx
October 3, 2011 at 4:34 am
rams.prsk (10/3/2011)
Thanks for your valuable suggestion Dave. You Made my day really..Could you give me some good example on this..
So...
My 'Roles' table would be...
RoleID integer PK,
IsRoleAdmin char(1) Not null,
IsRoleAccounts char(1)...
October 3, 2011 at 3:39 am
They are an *indicator* as are Reads Writes and Cpu usage in a trace session.
But those durations are quite short , so
A) is the quantity of data the expected...
October 3, 2011 at 2:59 am
Viewing 15 posts - 151 through 165 (of 1,825 total)