Viewing 15 posts - 526 through 540 (of 1,222 total)
When more than one record is inserted or updated in a single transaction, the SELECT statement in the line of code that reads:
...
February 22, 2011 at 7:58 pm
"GROUP BY" is normally used to aggregate data (e.g. to SUM amounts or to COUNT things). I suspect that you are using a more english interpretation of "GROUP" to...
February 22, 2011 at 7:51 pm
I don't see any need to BIDS to be installed onto a production server and very little, if any, sustainable argument for it to be installed on any other server....
February 21, 2011 at 7:53 pm
You are looking in the wrong table. sysdtspackages is used to store DTS packages. Try looking in table sysdtspackages90 instead.
February 20, 2011 at 7:43 pm
You can use MDX against Analysis Services in any of Standard, Enterprise, Evaluation or Developer editions. Not all features are available in standard edition but this shouldn't affect you...
February 14, 2011 at 7:49 pm
Dynamic configuration of DTS packages is pretty straightforward - try searching on google for DTS Package Configuration. One of the results I got is http://www.sqlis.com/post/Easy-Package-Configuration.aspx. This gives you...
February 12, 2011 at 1:41 am
SQL Server can be configured using a trace flag to allow the use of network drives. Trace flag 1807 bypasses SQL Servers checks for network bases drive.
There...
February 10, 2011 at 7:28 pm
You will need to create partitions in your cube. One for 2009 data and another for the rest.
You will then need to change the way you do your...
February 7, 2011 at 7:50 pm
One of the issues with the SCD component in SSIS is that the generated INSERT component does not use the fast load options. If I use the SCD component,...
February 3, 2011 at 8:07 pm
I would be wary about changing memtoleave. I suspect that the system.outofmemory exception you are getting is more likely to be a problem that visual studio / BIDS is...
February 3, 2011 at 8:02 pm
I am not sure how you created the sprocs - I used the defaults and the MS generated insert sproc specifies the columns.
February 3, 2011 at 5:13 am
I can't answer your first question - never measured performance of writeable Vs read only databases.
On you second question, you cannot replicate to a read only database. If you...
February 2, 2011 at 8:58 pm
I am a bit of a loss as to why you would do this as a cursor. How about something like ...
Select * from instore..tblDistributionCenters a
where a.dist_center in (...
February 1, 2011 at 8:26 pm
Since I haven't got your cube definitions, I did what I think is the equivalent in Adventureworks. My "Spe. cial exclusion" calculation excludes the color Black from its...
February 1, 2011 at 8:20 pm
I am not sure from your post which agent is timing out - is it the snapshot or the merge agent.
Either way, another option you could use is to change...
January 26, 2011 at 8:11 pm
Viewing 15 posts - 526 through 540 (of 1,222 total)