Viewing 15 posts - 47,986 through 48,000 (of 49,552 total)
To add to that
IO contention from different file placement
Network settings (full/half duplex, auto vs specified speed)
CPU contention with other apps running on the server (if any)
Have you checked what's running...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2007 at 4:32 am
Can you use a DTS package? iirc, the Excel source allows skipping of rows.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2007 at 4:09 am
Could you perhaps delete this thread please, as it's in completely the wrong forum.
There's no need to post in multiple forums, the regulars read all the forums
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2007 at 3:37 am
Why is the group by there at all? You aren't doing any form of aggregation that could require a group by.
If you're trying to eliminate duplicate rows, rather use Distinct.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2007 at 12:39 am
How do you find the duplicate rows in a table with Integer ID and a varchar name fields?
Well, that depends on whether its the name that's duplicated, or the name...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 11:53 pm
Jeff Moden (12/19/2007)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 11:21 pm
Jeff Moden (12/19/2007)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 11:18 pm
Not sure. I'll have to check. (Tomorrow. Is bed time here. I shouldn't post this late at night)
Since the like determines that the first character is between 0 and 9,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 2:20 pm
You don't need the temp table. (unless you're using it for performance reasons)
WITH ALevel (ConsultantID, AchieveLevel, AchieveTitle, PeriodEnddate) AS
(
SELECT ConsultantID, max(AchieveLevel), AchieveTitle, PeriodEndDate AS DirectReports
FROM Volume
WHERE ConsultantID = @ConsultantID
GROUP BY...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 2:17 pm
Edited for correctness.
And if there's an index on government_id, the like might allow the optimiser to use it for a partial scan, the len (since it's a function on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 2:02 pm
You don't. But one's time is, unfortunately limited, and a more productive use of one's time may be to fix the things that are known to be broke, before investigating...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 1:52 pm
The group by doesn't sort at all. A table doesn't have any defined order on it. By definition, it's an unordered set of records
When you say max(periodDate) ... group by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 1:45 pm
alorenzini (12/19/2007)
Basically I need the max periodenddate for each AchieveLevel. Soes ths make sense?
It would, if level 07 wasn't in your desired output 3 times. The max period date is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 1:15 pm
Check that the compatability mode of the database you're running this in is set to 90
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 9:54 am
Use SQL Profiler
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2007 at 9:52 am
Viewing 15 posts - 47,986 through 48,000 (of 49,552 total)