Viewing 15 posts - 2,086 through 2,100 (of 2,612 total)
Just another option...
Rather than using RECOMPILE in your procedure, using an OPTOMIZE FOR and specifying date parameters that give you your hash joins may give you better performance overall and...
February 13, 2008 at 5:31 am
The outside container will fail if the inside containers error counts add up to it's maximum error count. So in your example if you wanted it to be ok...
February 11, 2008 at 5:39 am
After a decade in corporate IT I have figured out one thing - everything changes. Even working with medical records I have found that I could not rely on...
February 11, 2008 at 5:30 am
I would tend to separate them for a couple of reasons.
First, your OLTP system is probably inserting and updating records pretty regularly. If you have a high transaction rate...
February 6, 2008 at 6:18 am
You must use a Raw File Destination component to create a raw file.
Raw Files are in a binary format that is native to SQL server and SSIS. These are...
February 5, 2008 at 7:01 am
Probably the most secure thing you could do is have everything run as LocalSystem (not a domain account).
Using a domain account, having one account per server and per service would...
February 4, 2008 at 1:57 pm
\\Server\it\client data\ASCEND\Current Batch Processing\raw\Errors\ERRORS_Charges.txt
By the path of the file, it may be that your package is trying to use a Raw File Destination or Raw File Source.
These are not text...
February 4, 2008 at 1:49 pm
That's a big question and it will really depend on the needs of your application.
If the reporting needs to be 100% real-time and it will not conflict, running the reports...
February 4, 2008 at 1:43 pm
What application are you using to execute the query?
How have you specified the value for your parameter?
February 4, 2008 at 6:31 am
This is going to be a bit tricky to troubleshoot without being able to look at package and your environment, but I will try to send you in the right...
January 30, 2008 at 4:42 am
Look in books online for the PIVOT clause for SELECT statements.
January 30, 2008 at 4:24 am
EXEC sp_Lock
If you know the spid of your process, you can also pass that in as a parameter.
There is information about the procedure in Books Online.
January 30, 2008 at 4:23 am
I have just scheduled a job agent job that checks the LastStatus field in the Subscriptions table in the reporting services database. This is the status displayed in report...
January 30, 2008 at 4:21 am
First, your report should not have a parameter for the email it is being sent to unless you want to actually display the email address in the report.
As far as...
January 30, 2008 at 4:14 am
One more thing - if you look for DTC Deadlocks on google, I think you will find some related information. DTC can deadlock and even self-deadlock and hang until...
January 28, 2008 at 9:52 am
Viewing 15 posts - 2,086 through 2,100 (of 2,612 total)