When I use "Database Engine Tuning Advisor" to analyze my stored procedure,
it recommends that I drop all related indexes (that I believe they are
useful) and
add so many statistics.

    I have 3 tables
solset with columns
       solset_ID and Solset name
Solsubset

Using SQL 2000 and 2005 servers
We have a view that pulls the proj_name from the MS Project server.
It sometimes includes .Published at the end of the name.
Is there a way to trim a specific value from the end of the string?

I have tried this sql but rows where the "VD" is the same is not summed.
What is the error ?
SELECT (VD.perc * RIGHEDOCUMENTI.TOTNETTORIGA) / 100 AS VALUETOT, VD.VD,
VD.perc, ANAGRAFICAARTICOLI.CODICE, RIGHEDOCUMENTI.NUMERODOC, sum ((VD.perc

I've got a list of customers, customer names, ... from another db (I didn't
design it).
I want to get a list of all of the customers plus the first customer name.
So if customer 1 appears twice (customer name = 'Fred' and 'John') I want

I'm not sure how I could get a total from multiple results. For example,
this SQL:
SELECT  COUNT(id) AS [Total Dialup Customers]
,rgheader.rg_name AS [Rate Group]

I need to select the top 3 rows per each group (xID -- order by xID).  No
problem here.  But I need to select the count of rows in each group before a
null value is encountered in the stat column -- ordering by xID
CREATE TABLE #tmp1(rowID int Identity(1,1), xID int, x1 int, stat ...

This is the final part of my previous post in the morning. I have changed
the stored  procedure quite a bit. The idea is the generate a select
statement where the database needs to be chosen dynamically based on a
parameter 'site' in the procedure. The procedure looks like the ...

I have a problem.  I just inherited a program that is full of holes and bugs
and I need to do some patching.  Just to note everyone, I did not set up
this database and I did not code this program, I am stuck with it as is.
That being said,  I have to do some checks on a database to ...

We are using the following query for paging the resultset.
With Cust AS
   ( SELECT CustomerID, CompanyName,
   ROW_NUMBER() OVER (order by CompanyName) as RowNumber

I am having trouble with the performance of one SP.This sp is taking
around 45 Sec to execute and
sometime timing out.. Here is the main code of SP..This SP calls
function to adjust the impression value..

I have 2 tables, A and B with a layout similar to the following:
A
PKId  | data
 1     |  aa

I am trying to work on a stored procedure that will work with multiple
database. I have a prototype of multiple databases. Those are named as the
following: ts2_aldkm_app, ts2_aldkp_app, ts2_aldkt_app. The middle part of
the database name corresponds to the site name e.g aldkm ...

I have a database that is currently using an int field to hold record
identifiers and acts as both the primary key and key in relationships to
other tables.  Up until now the int field has been satisfactory in
maintaining uniqueness but we are expanding to hold data from many ...

I have some quesation about Locks in the sql 2005.In the application I call
50x delete where I delete from table rows with specific range datetime.Why
this command locks second delete and not run paralel ?
thanx