Viewing 15 posts - 421 through 435 (of 1,478 total)
One way is to calculate the number of days that passed since your date, then divide it by seven and multiply it by seven. Since the function datediff returns...
--------------------------------------------------------------
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/
November 11, 2011 at 10:03 am
Thank you for everyone that participated in this thread. I’ve learned a lot from it, (and also have more reading to do about the subject).
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/
November 7, 2011 at 1:12 pm
Did you check the event viewer for more details?
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/
November 6, 2011 at 7:04 am
ChrisM@Work (11/4/2011)
GilaMonster (11/4/2011)
Lowell (11/4/2011)
--------------------------------------------------------------
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/
November 4, 2011 at 10:11 am
Lowell (11/4/2011)
--------------------------------------------------------------
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/
November 4, 2011 at 10:05 am
Lowell (11/4/2011)
i had to use winmerge to be sure, the two files you posted are identical; could you have copied the same plan as two different names?
You are correct that...
--------------------------------------------------------------
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/
November 4, 2011 at 9:36 am
Those are the 2 queries:
--First query
declare @LastRunTime datetime
select @LastRunTime = '2011-01-16 00:00:52.870'
;WITH RankedRows AS (
SELECT ID,DataCLInd,SecField,Third,
RANK() OVER (Partition by SecField ORDER BY DataCLInd DESC) AS RowNum
FROM Inna
WHERE...
--------------------------------------------------------------
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/
November 4, 2011 at 9:01 am
Lowell (11/4/2011)
as i remember it, the key to look for is the property "Reason For Early Termination...
--------------------------------------------------------------
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/
November 4, 2011 at 8:36 am
Change the way that you export the data. Instead of exporting all the data export only the data that you want to show. Never count on an external...
--------------------------------------------------------------
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/
November 4, 2011 at 4:41 am
One more way is to use the serverproperty functions with the input 'ProcessID'
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/
November 4, 2011 at 4:37 am
I don’t think that those 2 things are related. I think that the TempDB’s growth had nothing to do with the increasing the memory of the server.
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/
November 4, 2011 at 4:06 am
According to my memory, but more important this url:-) - http://msdn.microsoft.com/en-us/library/ms189315(v=SQL.100).aspx, you can run both types of backup at the same time.
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/
November 2, 2011 at 11:22 am
I’m not a developer and not an export in connection string, but I think that you also need to add the driver that should be used (have to admit that...
--------------------------------------------------------------
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/
November 1, 2011 at 2:03 am
When you work with XML variable, SQL Server only knows that it is going to work with an XML variable, but has no idea about the XML variable’s size or...
--------------------------------------------------------------
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/
October 31, 2011 at 4:04 am
Take a look at http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx. If you don't find anything about the failed login in SQL Server's error log, then check if the server is configured to log failed...
--------------------------------------------------------------
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/
October 31, 2011 at 3:15 am
Viewing 15 posts - 421 through 435 (of 1,478 total)