Viewing 15 posts - 1,306 through 1,320 (of 1,479 total)
michael.breen (12/17/2008)
AdiSorry if I seam very stupid as this is maybe straight forward for you but i have made the changes:
You didn't seam stupid and I hope that you...
--------------------------------------------------------------
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/
December 17, 2008 at 10:01 am
michael.breen (12/17/2008)
This didnt work any other ideas?Mick
You didn't specify what didn't work. I guess that the select statement was executed, but you didn't get any results. You...
--------------------------------------------------------------
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/
December 17, 2008 at 4:42 am
NULL is an anknown value, so when ever you compare null to another value, the results will be falls. For example - if you'll run the script bellow,...
--------------------------------------------------------------
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/
December 17, 2008 at 4:37 am
In log shipping the log is backed up. The log includes both open and close transactions. Each time that the log is being restored the server applies all...
--------------------------------------------------------------
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/
December 16, 2008 at 11:28 pm
You can limit the memory by running sp_configure with the 'max server memory (MB)' option. You can also do it from the GUI - right click on 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/
December 16, 2008 at 11:12 pm
ananda.murugesan (12/16/2008)
We are running SQL 2000 server database for our websites.
When we look sqlservr.exe inTask Manger lot of memory ( upto 1.7 GB ) and also cpu usage ...
--------------------------------------------------------------
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/
December 16, 2008 at 5:14 am
Christopher Stobbs (12/16/2008)
are your parameters dates?If so sounds like parameter sniffing
Hi Christopher
Why do you think that it is because of date parameter? As far as I know parameter...
--------------------------------------------------------------
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/
December 16, 2008 at 4:59 am
Christopher Stobbs (12/15/2008)
am I missing something here!Why do you need a derived table or a CTE when it seems to be a simply Group By Having Statement?
You are not missing...
--------------------------------------------------------------
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/
December 15, 2008 at 10:32 am
I do remember that syslog existed as a table in SQL Server 6.5. If I remember correctly it was removed with SQL Server 7.
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/
December 15, 2008 at 8:58 am
You can do it. You have to include the price in your query. I don't have your tables' structure so I can't show you how to do 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/
December 15, 2008 at 3:57 am
When you use path mode and you want to have hirarchies you need to use correlated queries. The script bellow creates 2 tables, insert some data into them 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/
December 15, 2008 at 3:04 am
Barkingdog (12/15/2008)
1jack15.00
4Fred35.00
The first row is exactly what I want but the second row is not. I expected 17...
--------------------------------------------------------------
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/
December 15, 2008 at 2:05 am
Here is one way of doing it:
with GetName as (
select myID, min(MyName) as MyName
from GroupingTest
group by myID)
select GetName.MyID, GetName.MyName, sum(MyMoney)
from GetName inner join GroupingTest on GetName.myID = GroupingTest.myID
group by GetName.MyID,...
--------------------------------------------------------------
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/
December 15, 2008 at 12:52 am
sanuj (12/14/2008)
Hi Adi,Thanks for your reply. How can we specify the DB in the query, in case if I am using dbOwner role ?
I see that you already got...
--------------------------------------------------------------
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/
December 14, 2008 at 10:29 pm
Did you remember to run sp_addserver with the local parameter? If you didn't you should run the statement
exec sp_addserver 'NewName', 'local'
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/
December 14, 2008 at 10:25 pm
Viewing 15 posts - 1,306 through 1,320 (of 1,479 total)