Viewing 15 posts - 961 through 975 (of 1,478 total)
I think that you forgot to ask the question.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 28, 2009 at 12:58 am
Chirag (5/27/2009)
I wonder how most of the people got the right answer. 55% when i checked.
It was clear that answer number 1 had a type. Since the other answers...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 27, 2009 at 1:24 am
insert into emp default values
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 26, 2009 at 7:54 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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 26, 2009 at 2:41 am
I don't think that there should be a rule of thumb about the time interval of log backup. It depends on factors such as the importance of the data...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 26, 2009 at 2:18 am
Viewing 15 posts - 961 through 975 (of 1,478 total)