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...
Guys, really annoying problem where after an install of analysis services pack SP3 from RTM (8.00.382) the registered servers have disappeared? Done...
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.
