Viewing 15 posts - 481 through 495 (of 529 total)
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...
April 5, 2003 at 2:38 am
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...
April 5, 2003 at 2:32 am
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...
April 4, 2003 at 5:19 pm
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...
April 4, 2003 at 9:43 am
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...
April 4, 2003 at 7:57 am
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?...
April 4, 2003 at 7:14 am
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])...
April 4, 2003 at 5:14 am
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...
April 3, 2003 at 12:51 am
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
*...
April 2, 2003 at 7:56 am
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...
April 2, 2003 at 12:32 am
Quoting BOL:
quote:
To run a procedure as an RPCConstruct a SQL statement that uses the ODBC CALL escape sequence. The statement...
April 1, 2003 at 1:06 am
Did you try the ODBC call instead of your 'exec StoredProc'?
March 31, 2003 at 10:44 am
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...
March 31, 2003 at 10:37 am
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...
March 31, 2003 at 10:26 am
Viewing 15 posts - 481 through 495 (of 529 total)