This issue is fixed in SQL 2005 as it now does the correct rounding. <img src='/community/emoticons/emotion-1.gif' alt=':)' />
How can you loop over a data reader and save the current row to a temp array of some sort and return this array back to the caller?...
-- Rebuild Indexes exec sp_msforeachtable 'DBCC DBREINDEX (''?'','' '',90)' ##################################################################...
Hi all, When bulk inserting from a file into a table, where you have a column of decimal(12,4) the precision is lost as soon as the data gets into...
Ok, I need to know: 1) If you have a clustered index and you specifiy TABLOCK in your bulk inserts then it really does queue the inserts and does...
Installed SP4 for Analysis and the problem went away, but... Another issue arises when you process the cubes via DTS - "Error string: invalid...
Guys, really annoying problem where after an install of analysis services pack SP3 from RTM (8.00.382) the registered servers have disappeared? Done...
Twan, quote:How easy is it for you to sort the data file (as per the columns in the clustered index) before inserting it? The file is already...
Twan, object_name( 568493204 ) = 'HIST_STOCK' (table), there are no triggers in this db. Single transaction takes a couple of min (each bulk load...
Guys, would a lower fillfactor help. If the table is set to 50% that would mean 50% more space for inserts? (but this only relates to page splits not...
Guys, we have several deadlock issues where a deadlock occurs on bulk inserts statements that are issued by more than one app server at any given...
Hi, not sure what the problem is but when I try and log into analysis services (SP3a) via the gui and click on a database it just hangs and there is...
Hi, just wondering whether there would be a performance gain/loss whilst querying tables with different combinations of columns that make up an...
When running a scheduled job from sql srv 2000 on win2k3, I get a "path not found" error msg in my Activex script task (I'm using...
Separate names with a comma.
