Viewing 15 posts - 4,441 through 4,455 (of 5,843 total)
1)
You can index it, but it's completely useless to do so.
That is incorrect. While you cannot do an index SEEK, a query can...
November 10, 2009 at 8:08 am
but please may i ask about the tools you used??
In this particular case I think Chris mentioned that the query plan xml actually contains missing index...
November 10, 2009 at 8:02 am
My advice is that you get a consultant to help you transition your app to effectively use sql server and to mentor you in how to better use and monitor...
November 10, 2009 at 7:57 am
That is a VERY limited and fragmented description of the problem you seek to solve, but if I read correctly I would recommend dropping the output to a file and...
November 10, 2009 at 7:53 am
Paul White (11/10/2009)
TheSQLGuru (11/9/2009)
I think we answer quite a few exam/homework type questions. Sometimes they do evoke a good learning discourse though.
Oh absolutely - the discussions are probably what...
November 10, 2009 at 7:40 am
I have said this before and will say it again here: SQL Server continually amazes me with how well it keeps on chugging despite INCREDIBLY bad design, code, setup,...
November 10, 2009 at 7:39 am
If the statistics problems is because a bad clustered index choice, instead of doing recompiles every time, is not better if we avoid that problem changing the current index to...
November 9, 2009 at 8:46 pm
Grant Fritchey (11/9/2009)
Paul White (11/9/2009)
Grant,86? :w00t:
Paul
Not my design, man, not my design.
Yeah - this was your IMPROVED design, right?? LOL
November 9, 2009 at 7:13 pm
Boy, where to start with this:
1)
The recompile option will force SQL to forget about the query plan and generates a new one each time the store procedure is gonna...
November 9, 2009 at 7:12 pm
See the earlier reply by richardd. It has a link to a script by Paul Nielson that not only identifies FKs missing indexes but will actually generate CREATE INDEX...
November 9, 2009 at 4:18 pm
Paul White (11/9/2009)
TheSQLGuru (11/9/2009)
I will go with the others at posit parameter sniffing/plan caching as the culprit here. OPTION (RECOMPILE) or dynamic sql as a solution.
Good to see you...
November 9, 2009 at 4:01 pm
I think we answer quite a few exam/homework type questions. Sometimes they do evoke a good learning discourse though.
November 9, 2009 at 3:57 pm
CirquedeSQLeil (11/9/2009)
rshm35 (11/9/2009)
The query has 12 joins in that 2 views are there...i can not use indexed view..help me out..
We need more information to help. Some great comments have...
November 9, 2009 at 3:55 pm
sqlpro (11/9/2009)
thanks for the reply. probably i misunderstood but following is the link i got my understanding from.its here http://www.informit.com/library/content.aspx?b=STY_Sql_Server_7&seqNum=145
In general, nonclustered indexes (and the associated bookmark lookup to...
November 9, 2009 at 3:52 pm
sqlpro (11/9/2009)
November 9, 2009 at 2:45 pm
Viewing 15 posts - 4,441 through 4,455 (of 5,843 total)