Viewing 6 posts - 2,911 through 2,917 (of 2,917 total)
you are already doing that.
if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.
so in your case:
JIREM10.dbo.JIRABConcentration
JIREM10 is the database
dbo...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 27, 2016 at 1:12 pm
Posisbly a dumb question, but are you enabling the broker? I don't see that in your scripts.
The other thing I'd recommend is to try sending a message outside of...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 19, 2016 at 10:32 am
As a thought - are your database and SSRS instance on the same SQL Instance? If not, did you update both SSRS instance and your database instance?
it sounds to...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 13, 2016 at 4:31 pm
Another thought (that we hit in our shop) is if "Option (Recompile)" improves performance, your statistics may be out of date.
How frequently do you re-create statistics or just let it...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 12, 2016 at 2:36 pm
Right. My bad.
My version of it would have given you wrong results as it would have started at 0 whenever the date changed.
Good job figuring...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 12, 2016 at 10:00 am
Have you tried using partition by in your second one instead of order by? That is:
SUM(Quantity) OVER (PARTITION BY EffectiveDate ORDER BY Holder RANGE UNBOUNDED PRECEDING) AS TQuantity
you may...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 12, 2016 at 9:47 am
Viewing 6 posts - 2,911 through 2,917 (of 2,917 total)