Viewing 15 posts - 316 through 330 (of 440 total)
Please post relevant DDL statements (in this case definitely including indexes), it would help us a lot to see the whole picture.
I've seen similar scenarios, where a strange index has...
October 26, 2011 at 12:37 am
October 25, 2011 at 2:24 pm
Unfortunately, I must tell that I have had the exact same issue. What I did is the same as described here, I browsed to the report, and configured it manually...
October 25, 2011 at 2:18 pm
Just glad to help 🙂
October 25, 2011 at 7:51 am
For SQL Server vs File System: http://pragmaticworks.com/help/dtsxchange/index.htm#page=FAQ%20-%20What%20are%20the%20advantages_disadvantages%20of%20storing%20SSIS%20packages%20to%20MSDB%20vs%20File%20System.htm.
What I think is missing here, is scalability. If you want to run the same package on/against several servers, I would definitely prefer a...
October 25, 2011 at 6:19 am
wilmer 15225 (10/25/2011)
October 25, 2011 at 6:14 am
First of all. I completely agree with Gail, dropping and recreating a clustred index may be a very costly operation. Furthermore, I don't like the idea of dropping constraints during...
October 25, 2011 at 6:03 am
Why do you return appointment dates? You're not showing appointment dates in the report, and that is the column causing your blank lines.
October 25, 2011 at 1:47 am
A good video on the subject (clustering key): Kimberly Tripp - The Clustered Index Debate. One of a whole bunch of MCM Videos.
October 24, 2011 at 12:13 pm
If I understand your issue right:
Setting the Protection Level of Packages
Long story short: Either use Encrypt With User Key, and edit/execute the package/configurations only with a single user, or use...
October 24, 2011 at 3:17 am
There are at least few possible solutions here.
As long as you don't have a default instance on the new server, you can specify that your named instance shall listen on...
October 24, 2011 at 2:42 am
What credentials are you using to install reporting services? It seems to me that you are not allowed to add performance counters to the system.
October 24, 2011 at 12:09 am
Seems very much like school work, so please try for yourself first, and then show us what you've got.
October 24, 2011 at 12:04 am
No, I have not. First of all, I rarely create global temp tables. I use local temp tables instead, which is lokal to the session. I drop there tables when...
October 22, 2011 at 1:20 am
Jeg tror du vil få bedre respons hvis du poster på engelsk, så slipper folk å bruke http://translate.google.com/[/url]
October 21, 2011 at 10:42 am
Viewing 15 posts - 316 through 330 (of 440 total)