Viewing 15 posts - 1 through 15 (of 41 total)
Using performance monitor I find that Reporting Services is sending the entire report (including drop down parameters) each time a parameter is selected that causes the next drop down parameter...
December 1, 2006 at 8:12 pm
From what I can see is that all of the configuration files are all set when the package loads. This is the reason that the last...
November 16, 2006 at 9:48 am
You could also migrate directly into a BIDS solution.
Right click on Packages node in solution explorer and select Migrate DTS 2000 package.
November 15, 2006 at 8:41 am
I walked through and was able to get this to work. This will allow me to control connections from the Parent process.
November 10, 2006 at 5:51 am
Some of the Microsoft SQL Server 2005 ELearning is still free until the end of the month.
Each course takes about 6 hours.
Check this link out: http://www.microsoft.com/learning/2005/sql/dba/default.mspx
November 3, 2006 at 1:15 pm
The application does an update by joining the 100,000 rows from the base table to a table in a staging database. On the publisher (where the original update occurs) it...
January 12, 2006 at 8:38 pm
I was able to register for both of the exams on the Pearson VUE web site last Friday night. I did not like the drop in a mailbox (late on...
November 1, 2005 at 1:23 pm
I agree with Jason that you should run the backups as a train (one behind the other).
A way to determine that that backup is running is to look at the...
November 1, 2005 at 12:53 pm
Ramesh & Chris
I believe that I will be able to activate free 90 day licences on all of the SQL2005 courseware prior to the end of the free period.
October 31, 2005 at 9:20 am
DBCC Shrinkfile is transaction safe. You can cancel it at any time.
We would have to cancel this process when the shrinkfile failed to finish during the "quiet" time.
October 17, 2005 at 6:40 pm
Yes, it should have been installed from the SQL Server 2005 Developer Edition Community Technology Preview CD.
It is located on the start menu under "Microsoft SQL Server 2005 CTP" as...
June 13, 2005 at 6:42 am
Are you sure that the tests are the same between the Intel and AMD.
Have you loaded both databases from identical copies.
Is your recovery model the same on both servers?
June 10, 2005 at 6:49 am
The AMD was purchased just to test the 64 bit software for Data Warehousing. It is only a test machine that cost $1,050.
The machine outperforms the Intel 3.2 GHz...
June 9, 2005 at 5:43 am
The documentation states that you must drop and recreate the user defined type. They claim this is due to indexing issues. So in order to drop the user defined type...
June 8, 2005 at 9:49 pm
There are some screen shots in this document:
Or if you have the SQL 2005 Beta (or CTP) installed see the tutorials. The Integration Services Information...
June 8, 2005 at 9:28 pm