Showing posts with label hit. Show all posts
Showing posts with label hit. Show all posts

Tuesday, March 27, 2012

Hit Outlook contacts database (API?)

I am not really sure what an API is and am about to do some research. However, I think the solution to my problem will include some knowledge of APIs.

I need to be able to access Outlook's contacts with my web app. Can someone point me into the right direction to instructions on how to do this?

ThanksYou could create a linked server and go from there (or use ADO/Active X script in DTS). Check this link out:

http://www.slipstick.com/dev/database.htmsql

hit locations in full text

I'm working on an aplication that could benefit from having the hit
location inside of a column. For example
A Column has
"United Stated Education System : Educational Stuff"
The full text search might match Education and Edicational from the
word eudcation. But I can not see any clear way to determine what
word(s) were matches and how they were used in the ranking. Is there
any known way to do this?
Thanks,
madmike
No, you have to implement a version of Porter Stemming algorithm to do
something like this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<madmik3@.gmail.com> wrote in message
news:1159463316.911169.56710@.e3g2000cwe.googlegrou ps.com...
> I'm working on an aplication that could benefit from having the hit
> location inside of a column. For example
> A Column has
> "United Stated Education System : Educational Stuff"
>
> The full text search might match Education and Edicational from the
> word eudcation. But I can not see any clear way to determine what
> word(s) were matches and how they were used in the ranking. Is there
> any known way to do this?
> Thanks,
> madmike
>

Hit highlight

Hi,
Does anyone know a simple way to highlight matches using full text indexes
in SQL Server 2005?
[]s
Jos
I responded to you on the private newsgroup - you may also want to look at
this http://www.indexserverfaq.com/sqlhithighlighting.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jos Antonio Farias" <jalf@.infocon.com.br> wrote in message
news:OACAh4eIGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Does anyone know a simple way to highlight matches using full text indexes
> in SQL Server 2005?
> []s
> Jos
>
|||Thanks Hilary.
"Hilary Cotter" <hilary.cotter@.gmail.com> escreveu na mensagem
news:OV4lrEqIGHA.3700@.TK2MSFTNGP15.phx.gbl...
>I responded to you on the private newsgroup - you may also want to look at
>this http://www.indexserverfaq.com/sqlhithighlighting.htm
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Jos Antonio Farias" <jalf@.infocon.com.br> wrote in message
> news:OACAh4eIGHA.3984@.TK2MSFTNGP14.phx.gbl...
>

hit counters

WHy can I not get the hit counter to work on my website. I used WebEasy6 program.

What was it about this forum that made you think your question could be answered here?

Without wanting to sound too rude, go somewhere else! I doubt anyone on this forum will be able to help you.

-Jamie

Friday, March 23, 2012

High Performance in Mirror

In this mode, I get that it's asynchronous. Does that just mean it sends the TX over and what happens, happens? Do I at least know it hit the comms stack, or the wire or anything? Or just it will do its est. Thanks.

You are referring to the mode when transaction safety is OFF. In this case, the principal sends the log to the mirror but does not wait for acknowledgement from the mirror. So Mirror can lag the Principal under heavy load. However, if mirror is down or if Principal is not receiving the response to the periodic ping (i.e. communication stack has a problem), the principal takes database offline.

Thanks,

|||When you say 'the principal takes database offline' you mean the MIRROR right, not the Principal database which could still live and service TXs, right?

Monday, March 12, 2012

High buffer cache hit ration but low page life expectancy

I've noticed that I have a buffer cache hit ratio consistently around
99% but a page life expectancy chronically below the 300 second level.
I'm wondering how this is possible? Presumably the page life
expectancy is low because the buffer pool needs to clear out pages to
make room for new pages but why would it need to do this if the cache
hit ratio is around 100%?
ThanksHow about the read-ahead manager putting asked for data into ram (thus
forcing out 'old' data) before it is actually needed by various SELECT
statements? Also buffer cache hit ratio and page life expectancy could be
calculated on different time schedules internally which could account for
their apparent disparity.
TheSQLGuru
President
Indicium Resources, Inc.
<pshroads@.gmail.com> wrote in message
news:1177626752.644290.325550@.s33g2000prh.googlegroups.com...
> I've noticed that I have a buffer cache hit ratio consistently around
> 99% but a page life expectancy chronically below the 300 second level.
> I'm wondering how this is possible? Presumably the page life
> expectancy is low because the buffer pool needs to clear out pages to
> make room for new pages but why would it need to do this if the cache
> hit ratio is around 100%?
> Thanks
>|||Hi
"pshroads@.gmail.com" wrote:

> I've noticed that I have a buffer cache hit ratio consistently around
> 99% but a page life expectancy chronically below the 300 second level.
> I'm wondering how this is possible? Presumably the page life
> expectancy is low because the buffer pool needs to clear out pages to
> make room for new pages but why would it need to do this if the cache
> hit ratio is around 100%?
> Thanks
>
Check out
http://download.microsoft.com/downl...aits_Queues.doc
A low page life expectancy with a high checkpoint pages/sec and lazy
write/sec values would indicate memory pressure. Also check for missing
indexes.
John

High buffer cache hit ration but low page life expectancy

I've noticed that I have a buffer cache hit ratio consistently around
99% but a page life expectancy chronically below the 300 second level.
I'm wondering how this is possible? Presumably the page life
expectancy is low because the buffer pool needs to clear out pages to
make room for new pages but why would it need to do this if the cache
hit ratio is around 100%?
ThanksHow about the read-ahead manager putting asked for data into ram (thus
forcing out 'old' data) before it is actually needed by various SELECT
statements? Also buffer cache hit ratio and page life expectancy could be
calculated on different time schedules internally which could account for
their apparent disparity.
--
TheSQLGuru
President
Indicium Resources, Inc.
<pshroads@.gmail.com> wrote in message
news:1177626752.644290.325550@.s33g2000prh.googlegroups.com...
> I've noticed that I have a buffer cache hit ratio consistently around
> 99% but a page life expectancy chronically below the 300 second level.
> I'm wondering how this is possible? Presumably the page life
> expectancy is low because the buffer pool needs to clear out pages to
> make room for new pages but why would it need to do this if the cache
> hit ratio is around 100%?
> Thanks
>|||Hi
"pshroads@.gmail.com" wrote:
> I've noticed that I have a buffer cache hit ratio consistently around
> 99% but a page life expectancy chronically below the 300 second level.
> I'm wondering how this is possible? Presumably the page life
> expectancy is low because the buffer pool needs to clear out pages to
> make room for new pages but why would it need to do this if the cache
> hit ratio is around 100%?
> Thanks
>
Check out
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc
A low page life expectancy with a high checkpoint pages/sec and lazy
write/sec values would indicate memory pressure. Also check for missing
indexes.
John

Sunday, February 19, 2012

hide warning from query analyser

When I renaming tables,columns below message comes to Query Analayaser
Result Window.
Is there any way to hide it,
because this may hit performance if there are 1000's of columns updated
Thanks
Caution: Changing any part of an object name could break scripts and stored
procedures.
The COLUMN was renamed to 'F28'.
Caution: Changing any part of an object name could break scripts and stored
procedures.
The COLUMN was renamed to 'F27'.
Caution: Changing any part of an object name could break scripts and stored
procedures.
The COLUMN was renamed to 'F26'.
Caution: Changing any part of an object name could break scripts and stored
procedures.
The COLUMN was renamed to 'F31'.Did you try SET ANSI_WANRINGS OFF? I forget the list of warnings that this
suppresses, I know it's not all of them...
"Abraham" <binu_ca@.yahoo.com> wrote in message
news:OP9FBW1ODHA.3700@.tk2msftngp13.phx.gbl...
> When I renaming tables,columns below message comes to Query Analayaser
> Result Window.
> Is there any way to hide it,
> because this may hit performance if there are 1000's of columns updated
> Thanks
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F28'.
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F27'.
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F26'.
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F31'.
>|||that one's a raiserror, so no. Why would performance of an object rename
process be a concern?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:Oj3WJb1ODHA.704@.tk2msftngp13.phx.gbl...
> Did you try SET ANSI_WANRINGS OFF? I forget the list of warnings that
this
> suppresses, I know it's not all of them...
>
> "Abraham" <binu_ca@.yahoo.com> wrote in message
> news:OP9FBW1ODHA.3700@.tk2msftngp13.phx.gbl...
> > When I renaming tables,columns below message comes to Query Analayaser
> > Result Window.
> > Is there any way to hide it,
> > because this may hit performance if there are 1000's of columns updated
> > Thanks
> >
> > Caution: Changing any part of an object name could break scripts and
> stored
> > procedures.
> > The COLUMN was renamed to 'F28'.
> > Caution: Changing any part of an object name could break scripts and
> stored
> > procedures.
> > The COLUMN was renamed to 'F27'.
> > Caution: Changing any part of an object name could break scripts and
> stored
> > procedures.
> > The COLUMN was renamed to 'F26'.
> > Caution: Changing any part of an object name could break scripts and
> stored
> > procedures.
> > The COLUMN was renamed to 'F31'.
> >
> >
>|||I don't know of any way to turn off this message.
> because this may hit performance if there are 1000's of columns updated
If you are frequently renaming lots of columns then maybe you should rethink
whether that is really the best solution. I can't think of a reason why you
would want to do this regularly.
--
David Portas
--
Please reply only to the newsgroup
--
"Abraham" <binu_ca@.yahoo.com> wrote in message
news:OP9FBW1ODHA.3700@.tk2msftngp13.phx.gbl...
> When I renaming tables,columns below message comes to Query Analayaser
> Result Window.
> Is there any way to hide it,
> because this may hit performance if there are 1000's of columns updated
> Thanks
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F28'.
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F27'.
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F26'.
> Caution: Changing any part of an object name could break scripts and
stored
> procedures.
> The COLUMN was renamed to 'F31'.
>