I have downloaded SP3 several times from Internet and it has always worked. But the problem you mention HAS happend to a colleuge of mine when he was doing...

boz: In SQL 7 it's not the default. What if, by design, you chose that another clusterization suited your needs better when the table was created?

/Hans

Edited by - hanslindgren on...

I believe that we all now have proved that we can make the calculations 🙂 But at this point I think the issue is DataStoring vs Dynamic calculations. Using a...

I believe that you still have to do these considerations when you are calculating your Performance, right? I mean even if you are doing storing, don't you have to take...

Thanks. For optimal performance, if you are just using dates in your table, consider storing them as INTs and in the view (when displaying them) converting them into DATETIME, in...

Depending on the size of the table, aren't you limiting concurrency with the storing of your calculations and huge updates? Why not just do the calculations when showing the data?...

Since the calculations are fairly simple why store them at all?

Why not look into the performance of this:

Your table (tbl):

Day AS DATETIME

NAV AS INT

You make a View:

SELECT TodaysTable.[Day],TodaysTable.[NAV],(TodaysTable.[NAV] - YesterdaysTable.[NAV])...

Another way is to just drag & drop your table from EM to QA, that generated the full table structure and all the constraints as a CREATE TABLE statement. You...

Thank you!

Unfortunatly that is not really what I needed :/

I probably expressed myself abit vauge. I meant more in the way of some of these:

* Streaming XML inserts

*...

Maybe you should start off with a general course in databases. They help.

Then try fiddling around with the control panel to find your administrative tools. Why don't you also look...

Quoting BOL:

quote:

---

To run a procedure as an RPC

Construct a SQL statement that uses the ODBC CALL escape sequence. The statement...

Maybe you have a virus?

Did you try the ODBC call instead of your 'exec StoredProc'?

Try msdn.microsoft.com if you have problems with BOL (they exist in there to).

Though if I remember correctly, BOL consists of more then one file...

Omen: I believe you are talking about data warehousing and not DBs in general?

Many times in OLTP processing you need different sets of data depending on the demands of the...