day (11/1/2007)

---

Now, I need also [Balance] field in the view. Since [AmountIn] and [AmountOut] are not a physical fields, I cannot do something like this:

Can anyone help me with this?

SELECT...

kev_byrne (11/2/2007)

---

On the second server, where the database is the same in structure and programming, there is no problem at all.

The SQL when run directly against the DB, on the...

This is unlikely to run very fast, 43 seconds on my machine against 54 million rows, but it'll work.

WITH x AS (SELECT b.[ID]

,b.[Date]

,b.[Value]

,ROW_NUMBER() OVER(ORDER BY b.[ID]) AS RowNum

FROM [BigTable] b

)

SELECT...

Johannes Fourie (11/2/2007)

---

Another option is to create an index on the temp table that you want to use for sorting before inserting into it.

Then remove the ORDER BY in the...

Thinking about it more, you should be able to get reasonable performance, even pivoting the data, assuming the indexes are clean, especially the clustered indexes. How did you set those...

Unfortunately, I'm going out of town for a week, but posting a bit of code could help someone else to help you.

Based on the requirements... 30 fields each 100 characters...

Bump.

Surely someone has a comment?

The one time I did manage a VLDB, we sure has heck ran the log backups more frequently than once a day, but then it was an OLTP system. I'm...

Bob Fazio (11/1/2007)[hrComplaints come from many sources. A stable system is a good goal too. Performance is also a goal. If you haven't noticed before a high...

Please, a syntax check on the XQuery. It's my first time out of the gate with this and I'm not sure I'm avoiding stupidity successfully.

Neither full text or xml has me terribly excited. If it were my project, I'd be reexamining the assumptions and trying to find a method of defining the requirements more...

Sounds like you just need an "ORDER BY"

What about XML for the meta data? It really does sound like it's only semi-structured data.

I'm sorry, I don't understand the question. Can you supply a few more details?

When you say in-lined table function, do you mean a user defined function that returns a table...

Well, again, there's not enough detail to start to give you very specific answers. It sounds like you're doing RBAR (row by agonizing row) processing. I'd strongly suggest you examine...