I have a stored procedure (on both SQL-Server 2000 and 2005) which simulates
a recursive functions (it computes the closure of a user-group hierarchy,
that is, for each group it finds all its descendants). Currently, the results
of  each round of the loop are stored in a ...

I have a stored procedure (on both SQL-Server 2000 and 2005) which simulates
a recursive functions (it computes the closure of a user-group hierarchy,
that is, for each group it finds all its descendants). Currently, the results
of  each round of the loop are stored in a ...

Working a new gig, they gave me a pretty nice little workstation,
dual-core 3ghz 2.5gb RAM, don't know what the disk is except it's
80gb.
Anyway, I'm working a GL project where we have to produce about 30m

Any kind words on the following issue regarding excessive compile time would
be greatly appreciated. SQL Server 2K, Windows 2003, both on the latest
service packs. Our appication is cross-platform so we use adhoc SQL instead
of stored procedures.

Does anyone know the resource utilization of Sharepoint. Our network admin
wants to use it as a file system for our company and put it on one of our
production boxes. Would use SQL 2005 for the database version.

We experienced some deadlocks in our servers and to resolve those we used
nolock query hints in some of our select statements.
Afterwards we are experiencing "There is insufficient system memory to run
this query." errors for queries which previously ran well. These queries

this SQL 2000, I have  data base with 4 files, each one more than 60 GB,
I'v a problem with the I/O performance, I found that the free space in each
file =0
how can I control the size of the free space of the file,

on sql server 2000 ... apart from going to the execution plan, is there a
way to identify queries that are doing table scans ?
thanks

Is there a way I can flag only queries that execute for longer than a
specified run time? Is there also any way to flag cpu intensive queries? SQL
version is 2k and Windows OS is 2003 Standard.
Many thanks

Questions:
1. There is a "Report" Icon within the summary tab. Is there a way to change
or add to the events being monitored.
thanks...