Viewing 15 posts - 46,501 through 46,515 (of 49,571 total)
ROW_Number is a built-in ranking function that's new in SQL 2005.
the order by clause in it specifies which column or columns define the order for the row number
The partition...
May 20, 2008 at 6:08 am
Do the tables BIS.History, BIS.[999] and ProcessedData all exist?
May 20, 2008 at 6:04 am
Put useful indexes on the table and remove the functions in the where clause.
May 20, 2008 at 5:59 am
Sweet. Then this should do the update for you
UPDATE #temp SET [Order] = TheOrder
FROM (SELECT ID, ROW_NUMBER() OVER (PARTITION BY projectID, langCode ORDER BY projectID, langCode) AS TheOrder
FROM #temp) Sub...
May 20, 2008 at 5:57 am
Sandy (5/20/2008)
If I am using the GETDATE() function, Its using Server Side Code to get the functionally of this function which is calling as delegates in .NET.
Um.... Getdate is not...
May 20, 2008 at 5:49 am
As insert statemetns would be easier, as it's gonna take time to manually enter the data into the table.
No matter. I do prefer to test before posting though.
Give this select...
May 20, 2008 at 5:46 am
Johan, if you can give me the table definition and the sample data as insert statements, I'll have a solution for you before you and Sandy stop arguing. 😉
May 20, 2008 at 5:41 am
karthikeyan (5/20/2008)
As for higher vs lower reads, which do you think is better, for SQL to read 1782 pages or for it to read 720?
1782 is better. Am i...
May 20, 2008 at 5:40 am
Sandy (5/20/2008)
May 20, 2008 at 5:38 am
What do you mean, "The trace won't enter the job step"?
Set the trace definition once, thenset the job to change the status of the trace, start and pause it. Should...
May 20, 2008 at 5:34 am
Could you give the table definition please and, if possible, the sample input as insert statements.
Just to make sure, you are using SQL 2005? If so, this looks like something...
May 20, 2008 at 5:31 am
Forget the inequlity, all those functions on columns in there where clause mean you are going to get scans. (not that you have an index on StartDate that SQL could...
May 20, 2008 at 5:28 am
A while loop is not going to be massivly more efficient. It's still row-by-row processing of a large number of rows.
Johann, can you give us sample input and output please,...
May 20, 2008 at 5:19 am
Sure. You can get profiler to create you a script that defines the trace.
May 20, 2008 at 5:15 am
Viewing 15 posts - 46,501 through 46,515 (of 49,571 total)