check if im reading cached data or hitting disks

I am running a query that returns more than 15 million rows.. If i run it
more than once, I want to know if the second run is being accessed directly
from cache or am I still hitting the disks just in case I am short of memory
or a combination of both ?
The query is a select statement and nothing more..
Look in BOL for SET STATISTICS IO ON / OFF
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Hassan" <fatima_ja@.hotmail.com> schrieb im Newsbeitrag
news:O7Y$wCLRFHA.508@.TK2MSFTNGP12.phx.gbl...
>I am running a query that returns more than 15 million rows.. If i run it
> more than once, I want to know if the second run is being accessed
> directly
> from cache or am I still hitting the disks just in case I am short of
> memory
> or a combination of both ?
> The query is a select statement and nothing more..
>

check if im reading cached data or hitting disks

I am running a query that returns more than 15 million rows.. If i run it
more than once, I want to know if the second run is being accessed directly
from cache or am I still hitting the disks just in case I am short of memory
or a combination of both ?
The query is a select statement and nothing more..Look in BOL for SET STATISTICS IO ON / OFF
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Hassan" <fatima_ja@.hotmail.com> schrieb im Newsbeitrag
news:O7Y$wCLRFHA.508@.TK2MSFTNGP12.phx.gbl...
>I am running a query that returns more than 15 million rows.. If i run it
> more than once, I want to know if the second run is being accessed
> directly
> from cache or am I still hitting the disks just in case I am short of
> memory
> or a combination of both ?
> The query is a select statement and nothing more..
>

check if im reading cached data or hitting disks

I am running a query that returns more than 15 million rows.. If i run it
more than once, I want to know if the second run is being accessed directly
from cache or am I still hitting the disks just in case I am short of memory
or a combination of both ?
The query is a select statement and nothing more..Look in BOL for SET STATISTICS IO ON / OFF
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Hassan" <fatima_ja@.hotmail.com> schrieb im Newsbeitrag
news:O7Y$wCLRFHA.508@.TK2MSFTNGP12.phx.gbl...
>I am running a query that returns more than 15 million rows.. If i run it
> more than once, I want to know if the second run is being accessed
> directly
> from cache or am I still hitting the disks just in case I am short of
> memory
> or a combination of both ?
> The query is a select statement and nothing more..
>sql

Charts placement

I have two charts for a report page, I just introduced second one next to the
first already there and it seems like the new one is going to the right most
side of the page after the matrix below it finishes. I need it to be placed
next to the previous one but cant seem to understand what seems to be the
problem.
Did anyone had this kind of problem here?
Thanks
AsimAdd a rectangle to the report and move the two charts inside that rectangle.
Make sure the charts are really moved inside the rectangle and not just
overlap with the rectangle.
Most likely, the reason why the second chart gets "pushed" to the right
while the matrix grows is that the Left position of the matrix is lower than
the Left position of the second chart, but higher than the Left position of
the first chart. By moving both charts inside a rectangle - either the
entire rectangle will get moved or not.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Asim" <Asim@.discussions.microsoft.com> wrote in message
news:868D2184-2841-4088-A348-654D80D23A2B@.microsoft.com...
>I have two charts for a report page, I just introduced second one next to
>the
> first already there and it seems like the new one is going to the right
> most
> side of the page after the matrix below it finishes. I need it to be
> placed
> next to the previous one but cant seem to understand what seems to be the
> problem.
> Did anyone had this kind of problem here?
> Thanks
> Asim

Chart Interlacing Colors

For a given axis I can select to enable interlaced colors.
How do I select what the second, interlacing color is?
It appears to always be gray.
This is not ideal for the custom colors we have selected.
Thank you in advance.
JerryThe interlacing color is automatically determined based on the chart's
backgroundcolor or plotarea color (if they are explicitly set).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410111518.7670c91f@.posting.google.com...
> For a given axis I can select to enable interlaced colors.
> How do I select what the second, interlacing color is?
> It appears to always be gray.
> This is not ideal for the custom colors we have selected.
> Thank you in advance.
> Jerry