Viewing 15 posts - 1,636 through 1,650 (of 3,366 total)
When Jobs are run through a .NET application the base requirement is it runs in the context of the Agent which means you need to create a proxy account with...
April 30, 2009 at 2:15 pm
First you could use JPEG and GIF but BMP is not good because I had a report with 13 images and I had problem with BMP had to convert those...
April 30, 2009 at 1:47 pm
Huge data is relative I have created a report that default to 170 plus pages in test box so you know it will be more than 300 pages in production,...
April 30, 2009 at 1:40 pm
If you want the results sorted I am assuming you need to create your model with either a query with ORDERBY or a View with ORDERBY so the results are...
April 30, 2009 at 1:33 pm
Kenneth Fisher (4/29/2009)
April 29, 2009 at 1:09 pm
Since the context is different, you would think it would *create its own connection pool*. But it doesn't, because it clearly *can* access connections in the other created pool, because...
April 25, 2009 at 8:10 am
I have posted the valid solution to your problem in the thread below.
http://www.sqlservercentral.com/Forums/Topic683681-1291-1.aspx
April 23, 2009 at 7:33 pm
With a static connection string you can use DatabaseFactory.CreateDatabase() which properly manages the pool even in the Silverlight + WCF scenario.
If you have a dynamic connection string you are forced...
April 23, 2009 at 7:19 pm
No I would not say I am contradicting myself because I have corrected that statement before you posted the smaller features from the book. And for ETL most of...
April 23, 2009 at 6:57 pm
The advanced transforms only available with Enterprise edition:
Data Mining Training Destination
Data Mining Query Component
Fuzzy Grouping
Fuzzy Lookup
Term Extraction
Term Lookup
Dimension Processing Destination
Partition Processing Destination...
April 23, 2009 at 6:33 pm
In the tools menu you could also connect to the database through Server Explorer, in Professional you could save your stored procs to VSS from the Server Explorer. No...
April 23, 2009 at 6:02 pm
I don't think that is a better source than Jeffrey who is running solution with it and the experts at SSIS.
April 23, 2009 at 5:53 pm
Not true at all - using BIDS you have access to a whole range of components for creating ETL processes. I have personally used merge joins, unions, derived columns, lookups...
April 23, 2009 at 5:48 pm
What I found if you are running Standard you can import your DTS packages and create packages similar DTS but nothing more all ETL require the Enterprise edition. So...
April 23, 2009 at 5:14 pm
If you are in Silverlight I am closer to the correct implementation than your current solution, I found about two alternatives that can be used. Read the long conversation...
April 23, 2009 at 2:55 pm
Viewing 15 posts - 1,636 through 1,650 (of 3,366 total)