Viewing 15 posts - 961 through 975 (of 1,479 total)
vikas bindra (6/2/2009)
I agree with you that I can not drop/change any index before i find out the queries,
But in general, if all 3...
June 2, 2009 at 7:37 am
I think that you forgot to ask the question.
Adi
June 2, 2009 at 4:46 am
It is impossible to give you a recommendation about the indexes without knowing what queries you have and the selectivity of the queries. An index that is created with...
June 2, 2009 at 3:05 am
It is hard to understand from your message what you need. Database doesn't get into restoring state on its own. Did you start the restore?
Having said...
June 1, 2009 at 1:29 am
newbie101 (5/30/2009)
I checked again and it only returns 500 characters. I increased it to 4000. :unsure:
After you modify it, you have to open a new window in Query Analyzer and...
May 31, 2009 at 4:39 am
It would help if you’ll specify the values of the parameters that you use and the problems that you encountered. Do you have an error message? Does it...
May 28, 2009 at 4:50 am
arun.sas (5/28/2009)
Hi Adi,
The scan is good,
but is any difference while putting the %2% instead of '%,2%' or '%,2,%'
ARUN SAS
Yes there is. If you have user that his/her ID has...
May 28, 2009 at 2:41 am
Instead of storing the users in a coma separated string, you should use a table to describe the connection between users and there groups (you can Google for “many to...
May 28, 2009 at 12:58 am
Last night and this morning I got the same message when I tried to connect from home. When I got to work and tried to connect from work, I...
May 26, 2009 at 7:25 am
Mark (5/26/2009)
with cte as (select CatID as RootCatID,CatID,NumOfProducts
from Hirarchy
union all
select c.RootCatID,h.CatID,h.NumOfProducts
from Hirarchy h
inner join cte c on c.CatID=h.ParentID
)
select RootCatID,sum(NumOfProducts) as NumOfProducts
from cte
group by RootCatID
Thank you for your answer. Your...
May 26, 2009 at 5:22 am
Thank you for the reply, but this is not what I wanted. I want to get the results for all the categories in the table and not get the...
May 26, 2009 at 3:36 am
Here is another way of doing it using a CTE instead of a table, but I don't understand the request that the report shouldn't use another table. Who cares...
May 26, 2009 at 3:08 am
Why do you think that SQL Server 2000 doesn't delete the constraint? Below is a small script that I just ran on SQL Server 2000 to check it and...
May 26, 2009 at 2:41 am
Viewing 15 posts - 961 through 975 (of 1,479 total)