Delayed stored procedure

We have a SQL Server 2000 database on my PC running WinXP Pro with a GUI
interface/application provided by a third party. We're recruiters and this i
s
the “Applicant Tracking System”/database we use to track our
candidates/resumes and clients.
This software was installed on my machine by others and I do not have the
technical expertise to diagnose problems when they occur.
There is a button within the application we click to search the (indexed)
resumes based on keywords.
Apparently this button runs a stored command thru SQL Server:
sp_help_fultext_columns 'consultants"
It used to be that when we clicked on the button a window (GUI) would open
instantly with fields where we enter our key words and then execute the
search.
However… for unknown reasons it now takes approximately 40 seconds after w
e
click for the search window to open. Our software provider does not know why
.
They logged on to my machine today and used Enterprise Manager and I think
Query Analyzer to run the query above. It also took 40 seconds to open and
they said this indicated we have a problem with SQL Server... not their
application... and sent us off to find our own solution.
We live in the country and there are no SQL Server experts within miles.
Does this sound like a problem that could be diagnosed/fixed by someone who
accesses my machine remotely?
Or better yet... does anyone have a clue how to fix the problem simply based
on my question above?Jeff,
If somebody can remote desktop in , they should be able to identify
the issue.
I don't want to sound presumptous but I somehow find it hard to believe that
just sp_help_fultext_columns 'consultants' is taking 40 seconds. This system
stored proc only brings back a list of columns that have full text index on
them in a particular table(or table-column),
If you can run trace and make sure that is the only thing running in the
backend when you click that button, that might help you narrow it down a
little more.
To run a trace just click sql profiler from the Sql server program menu and
click File-New Trace & Hit run. go back and click the Button on the
Application. and see the list of sql commands being executed as a result.
HTH,
RA
"Jeff Ingman" wrote:

> We have a SQL Server 2000 database on my PC running WinXP Pro with a GUI
> interface/application provided by a third party. We're recruiters and this
is
> the “Applicant Tracking System”/database we use to track our
> candidates/resumes and clients.
> This software was installed on my machine by others and I do not have the
> technical expertise to diagnose problems when they occur.
> There is a button within the application we click to search the (indexed)
> resumes based on keywords.
> Apparently this button runs a stored command thru SQL Server:
> sp_help_fultext_columns 'consultants"
> It used to be that when we clicked on the button a window (GUI) would open
> instantly with fields where we enter our key words and then execute the
> search.
> However… for unknown reasons it now takes approximately 40 seconds after
we
> click for the search window to open. Our software provider does not know w
hy.
> They logged on to my machine today and used Enterprise Manager and I think
> Query Analyzer to run the query above. It also took 40 seconds to open and
> they said this indicated we have a problem with SQL Server... not their
> application... and sent us off to find our own solution.
> We live in the country and there are no SQL Server experts within miles.
> Does this sound like a problem that could be diagnosed/fixed by someone wh
o
> accesses my machine remotely?
> Or better yet... does anyone have a clue how to fix the problem simply bas
ed
> on my question above?|||Rocky...
Thanks for your comments. But I'm not confident enough in my SQL expertise
to understand/follow thru on your recommendations.
(One small point... I mispelled the query in my original post... it should
be "fulltext" not "fultext").
I think I'll need to find a DBA who can logon to my machine remotely to
diagnose this.
I'd have done this by now except we only access this command a couple times
daily and I haven't wanted to hire an expensive consultant.
Would Microsoft paid incident support be a good route to go?
........................
"Rocky A" wrote:
[vbcol=seagreen]
> Jeff,
> If somebody can remote desktop in , they should be able to identify
> the issue.
> I don't want to sound presumptous but I somehow find it hard to believe th
at
> just sp_help_fultext_columns 'consultants' is taking 40 seconds. This syst
em
> stored proc only brings back a list of columns that have full text index o
n
> them in a particular table(or table-column),
> If you can run trace and make sure that is the only thing running in the
> backend when you click that button, that might help you narrow it down a
> little more.
> To run a trace just click sql profiler from the Sql server program menu an
d
> click File-New Trace & Hit run. go back and click the Button on the
> Application. and see the list of sql commands being executed as a result.
> HTH,
> RA
> "Jeff Ingman" wrote:
>|||Jeff,
I would suggest going through a consultant rather than a MS paid
incident, I am guessing this is not an issue with Sql server as a product, i
t
is more of a day-to-day technical issue, i would go the DBA route. I can
take a look at it if you are interested.
thanks,
RA
"Jeff Ingman" wrote:
[vbcol=seagreen]
> Rocky...
> Thanks for your comments. But I'm not confident enough in my SQL expertise
> to understand/follow thru on your recommendations.
> (One small point... I mispelled the query in my original post... it should
> be "fulltext" not "fultext").
> I think I'll need to find a DBA who can logon to my machine remotely to
> diagnose this.
> I'd have done this by now except we only access this command a couple time
s
> daily and I haven't wanted to hire an expensive consultant.
> Would Microsoft paid incident support be a good route to go?
> ........................
> "Rocky A" wrote:
>|||I would like help Rocky... how do we arrange? You can find my email address
at www.ingmancompany.com.
jeff
"Rocky A" wrote:
[vbcol=seagreen]
> Jeff,
> I would suggest going through a consultant rather than a MS paid
> incident, I am guessing this is not an issue with Sql server as a product,
it
> is more of a day-to-day technical issue, i would go the DBA route. I can
> take a look at it if you are interested.
> thanks,
> RA
> "Jeff Ingman" wrote:
>

Delayed stored procedure

We have a SQL Server 2000 database on my PC running WinXP Pro with a GUI
interface/application provided by a third party. We're recruiters and this is
the â'Applicant Tracking Systemâ'/database we use to track our
candidates/resumes and clients.
This software was installed on my machine by others and I do not have the
technical expertise to diagnose problems when they occur.
There is a button within the application we click to search the (indexed)
resumes based on keywords.
Apparently this button runs a stored command thru SQL Server:
sp_help_fultext_columns 'consultants"
It used to be that when we clicked on the button a window (GUI) would open
instantly with fields where we enter our key words and then execute the
search.
Howeverâ?¦ for unknown reasons it now takes approximately 40 seconds after we
click for the search window to open. Our software provider does not know why.
They logged on to my machine today and used Enterprise Manager and I think
Query Analyzer to run the query above. It also took 40 seconds to open and
they said this indicated we have a problem with SQL Server... not their
application... and sent us off to find our own solution.
We live in the country and there are no SQL Server experts within miles.
Does this sound like a problem that could be diagnosed/fixed by someone who
accesses my machine remotely?
Or better yet... does anyone have a clue how to fix the problem simply based
on my question above?Jeff,
If somebody can remote desktop in , they should be able to identify
the issue.
I don't want to sound presumptous but I somehow find it hard to believe that
just sp_help_fultext_columns 'consultants' is taking 40 seconds. This system
stored proc only brings back a list of columns that have full text index on
them in a particular table(or table-column),
If you can run trace and make sure that is the only thing running in the
backend when you click that button, that might help you narrow it down a
little more.
To run a trace just click sql profiler from the Sql server program menu and
click File-New Trace & Hit run. go back and click the Button on the
Application. and see the list of sql commands being executed as a result.
HTH,
RA
"Jeff Ingman" wrote:
> We have a SQL Server 2000 database on my PC running WinXP Pro with a GUI
> interface/application provided by a third party. We're recruiters and this is
> the â'Applicant Tracking Systemâ'/database we use to track our
> candidates/resumes and clients.
> This software was installed on my machine by others and I do not have the
> technical expertise to diagnose problems when they occur.
> There is a button within the application we click to search the (indexed)
> resumes based on keywords.
> Apparently this button runs a stored command thru SQL Server:
> sp_help_fultext_columns 'consultants"
> It used to be that when we clicked on the button a window (GUI) would open
> instantly with fields where we enter our key words and then execute the
> search.
> Howeverâ?¦ for unknown reasons it now takes approximately 40 seconds after we
> click for the search window to open. Our software provider does not know why.
> They logged on to my machine today and used Enterprise Manager and I think
> Query Analyzer to run the query above. It also took 40 seconds to open and
> they said this indicated we have a problem with SQL Server... not their
> application... and sent us off to find our own solution.
> We live in the country and there are no SQL Server experts within miles.
> Does this sound like a problem that could be diagnosed/fixed by someone who
> accesses my machine remotely?
> Or better yet... does anyone have a clue how to fix the problem simply based
> on my question above?|||Rocky...
Thanks for your comments. But I'm not confident enough in my SQL expertise
to understand/follow thru on your recommendations.
(One small point... I mispelled the query in my original post... it should
be "fulltext" not "fultext").
I think I'll need to find a DBA who can logon to my machine remotely to
diagnose this.
I'd have done this by now except we only access this command a couple times
daily and I haven't wanted to hire an expensive consultant.
Would Microsoft paid incident support be a good route to go?
........................
"Rocky A" wrote:
> Jeff,
> If somebody can remote desktop in , they should be able to identify
> the issue.
> I don't want to sound presumptous but I somehow find it hard to believe that
> just sp_help_fultext_columns 'consultants' is taking 40 seconds. This system
> stored proc only brings back a list of columns that have full text index on
> them in a particular table(or table-column),
> If you can run trace and make sure that is the only thing running in the
> backend when you click that button, that might help you narrow it down a
> little more.
> To run a trace just click sql profiler from the Sql server program menu and
> click File-New Trace & Hit run. go back and click the Button on the
> Application. and see the list of sql commands being executed as a result.
> HTH,
> RA
> "Jeff Ingman" wrote:
> > We have a SQL Server 2000 database on my PC running WinXP Pro with a GUI
> > interface/application provided by a third party. We're recruiters and this is
> > the â'Applicant Tracking Systemâ'/database we use to track our
> > candidates/resumes and clients.
> >
> > This software was installed on my machine by others and I do not have the
> > technical expertise to diagnose problems when they occur.
> >
> > There is a button within the application we click to search the (indexed)
> > resumes based on keywords.
> >
> > Apparently this button runs a stored command thru SQL Server:
> >
> > sp_help_fultext_columns 'consultants"
> >
> > It used to be that when we clicked on the button a window (GUI) would open
> > instantly with fields where we enter our key words and then execute the
> > search.
> >
> > Howeverâ?¦ for unknown reasons it now takes approximately 40 seconds after we
> > click for the search window to open. Our software provider does not know why.
> > They logged on to my machine today and used Enterprise Manager and I think
> > Query Analyzer to run the query above. It also took 40 seconds to open and
> > they said this indicated we have a problem with SQL Server... not their
> > application... and sent us off to find our own solution.
> >
> > We live in the country and there are no SQL Server experts within miles.
> > Does this sound like a problem that could be diagnosed/fixed by someone who
> > accesses my machine remotely?
> >
> > Or better yet... does anyone have a clue how to fix the problem simply based
> > on my question above?|||Jeff,
I would suggest going through a consultant rather than a MS paid
incident, I am guessing this is not an issue with Sql server as a product, it
is more of a day-to-day technical issue, i would go the DBA route. I can
take a look at it if you are interested.
thanks,
RA
"Jeff Ingman" wrote:
> Rocky...
> Thanks for your comments. But I'm not confident enough in my SQL expertise
> to understand/follow thru on your recommendations.
> (One small point... I mispelled the query in my original post... it should
> be "fulltext" not "fultext").
> I think I'll need to find a DBA who can logon to my machine remotely to
> diagnose this.
> I'd have done this by now except we only access this command a couple times
> daily and I haven't wanted to hire an expensive consultant.
> Would Microsoft paid incident support be a good route to go?
> ........................
> "Rocky A" wrote:
> > Jeff,
> > If somebody can remote desktop in , they should be able to identify
> > the issue.
> >
> > I don't want to sound presumptous but I somehow find it hard to believe that
> > just sp_help_fultext_columns 'consultants' is taking 40 seconds. This system
> > stored proc only brings back a list of columns that have full text index on
> > them in a particular table(or table-column),
> >
> > If you can run trace and make sure that is the only thing running in the
> > backend when you click that button, that might help you narrow it down a
> > little more.
> >
> > To run a trace just click sql profiler from the Sql server program menu and
> > click File-New Trace & Hit run. go back and click the Button on the
> > Application. and see the list of sql commands being executed as a result.
> >
> > HTH,
> > RA
> >
> > "Jeff Ingman" wrote:
> >
> > > We have a SQL Server 2000 database on my PC running WinXP Pro with a GUI
> > > interface/application provided by a third party. We're recruiters and this is
> > > the â'Applicant Tracking Systemâ'/database we use to track our
> > > candidates/resumes and clients.
> > >
> > > This software was installed on my machine by others and I do not have the
> > > technical expertise to diagnose problems when they occur.
> > >
> > > There is a button within the application we click to search the (indexed)
> > > resumes based on keywords.
> > >
> > > Apparently this button runs a stored command thru SQL Server:
> > >
> > > sp_help_fultext_columns 'consultants"
> > >
> > > It used to be that when we clicked on the button a window (GUI) would open
> > > instantly with fields where we enter our key words and then execute the
> > > search.
> > >
> > > Howeverâ?¦ for unknown reasons it now takes approximately 40 seconds after we
> > > click for the search window to open. Our software provider does not know why.
> > > They logged on to my machine today and used Enterprise Manager and I think
> > > Query Analyzer to run the query above. It also took 40 seconds to open and
> > > they said this indicated we have a problem with SQL Server... not their
> > > application... and sent us off to find our own solution.
> > >
> > > We live in the country and there are no SQL Server experts within miles.
> > > Does this sound like a problem that could be diagnosed/fixed by someone who
> > > accesses my machine remotely?
> > >
> > > Or better yet... does anyone have a clue how to fix the problem simply based
> > > on my question above?|||I would like help Rocky... how do we arrange? You can find my email address
at www.ingmancompany.com.
jeff
"Rocky A" wrote:
> Jeff,
> I would suggest going through a consultant rather than a MS paid
> incident, I am guessing this is not an issue with Sql server as a product, it
> is more of a day-to-day technical issue, i would go the DBA route. I can
> take a look at it if you are interested.
> thanks,
> RA
> "Jeff Ingman" wrote:
> > Rocky...
> >
> > Thanks for your comments. But I'm not confident enough in my SQL expertise
> > to understand/follow thru on your recommendations.
> >
> > (One small point... I mispelled the query in my original post... it should
> > be "fulltext" not "fultext").
> >
> > I think I'll need to find a DBA who can logon to my machine remotely to
> > diagnose this.
> >
> > I'd have done this by now except we only access this command a couple times
> > daily and I haven't wanted to hire an expensive consultant.
> >
> > Would Microsoft paid incident support be a good route to go?
> > ........................
> > "Rocky A" wrote:
> >
> > > Jeff,
> > > If somebody can remote desktop in , they should be able to identify
> > > the issue.
> > >
> > > I don't want to sound presumptous but I somehow find it hard to believe that
> > > just sp_help_fultext_columns 'consultants' is taking 40 seconds. This system
> > > stored proc only brings back a list of columns that have full text index on
> > > them in a particular table(or table-column),
> > >
> > > If you can run trace and make sure that is the only thing running in the
> > > backend when you click that button, that might help you narrow it down a
> > > little more.
> > >
> > > To run a trace just click sql profiler from the Sql server program menu and
> > > click File-New Trace & Hit run. go back and click the Button on the
> > > Application. and see the list of sql commands being executed as a result.
> > >
> > > HTH,
> > > RA
> > >
> > > "Jeff Ingman" wrote:
> > >
> > > > We have a SQL Server 2000 database on my PC running WinXP Pro with a GUI
> > > > interface/application provided by a third party. We're recruiters and this is
> > > > the â'Applicant Tracking Systemâ'/database we use to track our
> > > > candidates/resumes and clients.
> > > >
> > > > This software was installed on my machine by others and I do not have the
> > > > technical expertise to diagnose problems when they occur.
> > > >
> > > > There is a button within the application we click to search the (indexed)
> > > > resumes based on keywords.
> > > >
> > > > Apparently this button runs a stored command thru SQL Server:
> > > >
> > > > sp_help_fultext_columns 'consultants"
> > > >
> > > > It used to be that when we clicked on the button a window (GUI) would open
> > > > instantly with fields where we enter our key words and then execute the
> > > > search.
> > > >
> > > > Howeverâ?¦ for unknown reasons it now takes approximately 40 seconds after we
> > > > click for the search window to open. Our software provider does not know why.
> > > > They logged on to my machine today and used Enterprise Manager and I think
> > > > Query Analyzer to run the query above. It also took 40 seconds to open and
> > > > they said this indicated we have a problem with SQL Server... not their
> > > > application... and sent us off to find our own solution.
> > > >
> > > > We live in the country and there are no SQL Server experts within miles.
> > > > Does this sound like a problem that could be diagnosed/fixed by someone who
> > > > accesses my machine remotely?
> > > >
> > > > Or better yet... does anyone have a clue how to fix the problem simply based
> > > > on my question above?sql

Defining your own Functions in XQuery

Hi Kent -
There are third party implementations (for example, DataDirect XQuery)
that support XQuery functions on SQL Server 2005. Microsoft SQL Server
has a lot of partner software vendors.
Sincerely,
The Stylus Studio Team
http://www.stylusstudio.comHello Stylus,
SS> There are third party implementations (for example, DataDirect
SS> XQuery) that support XQuery functions on SQL Server 2005. Microsoft
SS> SQL Server has a lot of partner software vendors.
Sure, but I don't see them edu-advertising their products here, do you?
Look, I understand -- you have a good product, no problems with that. And
does it work with SQL Server 2005? Sure, at least at some level. And I think
that the works of Dr. Kay's that your hosted on your site are helpful to
the XQuery community in general. All I'm taking exception with is that your
potentially setting the exceptation that you're product "magically" enables
UDFs within SQL Server 2005 processed XQueries, or worse yet, that they are
natively supported. So people take time and effort to do that. You've help
set an faulty expecation. When those expectations get upset we're the ones
left to clean up the "damage" -- frustration over wasted time and effort.
That I don't really appreciate.
So if you would, do us a favor -- when your posting something to this group
that isn't natively supported by SQL Server 2005 -- include that in your
post. Then let the customer decide for themselves if what your offering is
really relativant to them not before they expend their time and ours on some
thing
that isn't. It doesn't seem like its asking too much, is it?
If you like somebody help you with that task, I'm more than happy to help.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Default Value - I see the finish line!

Third Posting on how the heck Report Manager sets the "Has Default" property,
specifically the method it uses. Current, RS drops that property when you
copy a report, hence making Snap Shots impossible when Snapping a copy of
another report. I'm doing this in an application.
Comon someone, I get this down and this baby gets thru QA!!!
My kingdom for the answer!!
thank you in advanceTake a look at
http://msdn.microsoft.com/library/en-us/rsprog/htm/rsp_ref_soapapi_ir_5zec.asp
for working with ReportParameter Objects
and
http://msdn.microsoft.com/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_48jc.asp
for how to call SetReportParameters method.
Some examples for working with report parms can be found on:
http://groups.google.com/groups?q=SetReportParameters&hl=en&lr=&group=microsoft.public.sqlserver.reportingsvcs&selm=OlRQmQDuEHA.3860%40TK2MSFTNGP09.phx.gbl&rnum=8
http://groups.google.com/groups?hl=en&lr=&frame=right&th=3c7cb0c51785eb58&seekm=9F17B95C-B484-46D9-A7F0-FD7BE91DE8EB%40microsoft.com#link7
Suspect you need to 1st call GetReportParameters against old report to
obtain parameters, then SetReportParameters against copy fo the report you
are making.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:6320E87B-95CA-4DA7-85FB-B2FCF05198E2@.microsoft.com...
> Third Posting on how the heck Report Manager sets the "Has Default"
> property,
> specifically the method it uses. Current, RS drops that property when you
> copy a report, hence making Snap Shots impossible when Snapping a copy of
> another report. I'm doing this in an application.
> Comon someone, I get this down and this baby gets thru QA!!!
> My kingdom for the answer!!
> thank you in advance|||John,
I do as the docs and you speak of. The twist is, you can't set a default
value if the report does not have the "has default" check box ichecked. It
works great if that darn check box is checked. Unfortunately, when you do a
Copy of a report, using CreateReport(), it for some reason loses the "Has
Default" property, meaning you can't progamatically set it, and hence, cannot
create a snapshot from it. I know it's possible, since you can do it in
Report Manager. What I can't figure out is how to progamatically set the "Has
Default" property of the parameter. The "Has Default" property is not listed
as a public of the ReportParameter Class.
"John H. Miller" wrote:
> Take a look at
> http://msdn.microsoft.com/library/en-us/rsprog/htm/rsp_ref_soapapi_ir_5zec.asp
> for working with ReportParameter Objects
> and
> http://msdn.microsoft.com/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_48jc.asp
> for how to call SetReportParameters method.
> Some examples for working with report parms can be found on:
> http://groups.google.com/groups?q=SetReportParameters&hl=en&lr=&group=microsoft.public.sqlserver.reportingsvcs&selm=OlRQmQDuEHA.3860%40TK2MSFTNGP09.phx.gbl&rnum=8
> http://groups.google.com/groups?hl=en&lr=&frame=right&th=3c7cb0c51785eb58&seekm=9F17B95C-B484-46D9-A7F0-FD7BE91DE8EB%40microsoft.com#link7
> Suspect you need to 1st call GetReportParameters against old report to
> obtain parameters, then SetReportParameters against copy fo the report you
> are making.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:6320E87B-95CA-4DA7-85FB-B2FCF05198E2@.microsoft.com...
> > Third Posting on how the heck Report Manager sets the "Has Default"
> > property,
> > specifically the method it uses. Current, RS drops that property when you
> > copy a report, hence making Snap Shots impossible when Snapping a copy of
> > another report. I'm doing this in an application.
> >
> > Comon someone, I get this down and this baby gets thru QA!!!
> > My kingdom for the answer!!
> >
> > thank you in advance
>
>