Running a particula stored procedure against a SQL2000 database within a
SSMS2005 query window  using identical parameter values it will sometimes
run in 17 seconds and at other times runs in 47 seconds. What should I look
into for the cause.

I'm wanting to get a ordered table of players and their scores, in
descending order, with a a leaderboard style row-numbering (so of two people
had the same score they would both be position 3, and the next would be
position 5). I've managed to find a way using a side-effect of ...

I've heard that a good rule of thumb for table vars vs temp tables is if you
might be working with 10,000 or more rows go with a temp table, otherwise a
table var.
So, assuming working with a temp table of 10,000 rows , should indexes be

I am looking a stored procedure that writes SQL data out to a text file from
a stored procedure. The existing code is doing this:
------------------------------
Some code to create #QSBonuses and fill it with data

How do I return the following as a Decimal 10.2
    Sum(Balance) asBal,
     Case
     WHEN Sum(Balance) = 0 and  Sum(PER) = 0 THEN

I recently came across the PIVOT sql syntax. Less typing than select
case.
Access has a crosstab query to turn values that appear in rows as
columns. this has the advantage over SQL in that you don't need to

Anyone have a query to find all the unique indexes in a given database?
Thanks,
Mark

I was struggling for this one for a while.
It could be very easy one, but I cannot seem to get it as I get an error.
1.Here is a task
I have a table A which contains Acct# & a blank Contact field.

Here it goes.
I use an ordinary ORDERS database, that we all know the tables that are
normally contained in it :
CUSTOMERS (C_ID, C_NAME, ...)

Is there an easy way to email the results of a query using sp_send_dbmail? I
can always use a cursor and build a string for the email body, but I was
hoping there would be a better way.

I would like to operate a v.simple locking mechanism. Have a
hierachical db structure everything hangs of customer table. So when
someone is editing a customer do not want anyone to be able to edit
the same customer.

We are trying to trouble shoot a problem and we are not sure what is
the queries that the application sending to my sql server. is there a
way to audit the queries executed by SQL Server?
Thanks

I have a temp table #Output with one column OrderId int. I add some
OrderId's to this table based on some criteria.
I have another table called OrderLineItem with OrderId, Event. I have
a variable called @events which corresponds to the maximum number of

I have a varchar 50 field that contains periods and underscores.  I want to
return only the alphanumeric characters.  Unfortunately, the periods and
underscores do not always appear in the same position.  I worte a public
function is Access that does this:

I currently have Sql Server 2005 Standard Edition.
I have a few legacy Sql Server 2000 Standard Edition databases as well.
..
I have implemented the Sql Server 2005 Performance Dashboard Reports as