Viewing 15 posts - 1,531 through 1,545 (of 2,917 total)
That part is the EASY bit. Set the report parameter to allow multiple values. Then set the report parameter to be a variable in the query and use your WHERE...
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.
October 5, 2020 at 6:16 pm
This one is actually answered in the documentation. First I went here:
which gives an overview of report parameters in SSRS 2016. From there, I searched for "Data Type" which listed...
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.
October 5, 2020 at 5:08 pm
Could you provide:
1 - what you have tried already?
2 - sample output for what it should look like?
I am not sure what "stick" means or what your output should look...
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 30, 2020 at 6:04 pm
Congrats! I have the same certificate and I think I got the same score actually.
Are your plans to keep going and getting more certs or stopping at the MTA?
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 30, 2020 at 4:26 pm
What I mean by sequential is to just don't do the same task simultaneously. So if you are calling a stored procedure, just make sure your package only calls that...
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 25, 2020 at 2:40 pm
I wouldn't bother with NOLOCK as that doesn't work with UPDATE queries. Won't get a syntax error, the hint just gets ignored.
As for a good alternative, if you NEED a...
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 24, 2020 at 9:09 pm
Jeff I think this may be a thing that we have to agree to disagree on. I am not saying that SQL shouldn't be the first solution you look at...
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 24, 2020 at 6:34 pm
The index ID and the Object_ID are tied together. Object_ID will tie back to a table whereas the Index ID will tie back to an index ON the table. So...
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 18, 2020 at 10:12 pm
Stream design doesn't introduce blocking. Your stored procedure is creating the blocking.
You even said it creates blocking - you are requesting an update lock on the table. So anything that...
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 18, 2020 at 8:21 pm
Index fragmentation is a very heated debate on SSC and ranges between "don't ever do it" to "do it once it gets above x%". My advice - if the index...
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 18, 2020 at 8:17 pm
it depends. Having multiple "streams" call the same stored procedure that is updating a table will create blocking on that table and each one will need to wait for the...
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 18, 2020 at 7:57 pm
My approach is to watch for long running queries. If I have a long running query, then I probably need an index (or other tuning) of some sort. I would...
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 18, 2020 at 7:51 pm
Can you post some DDL? We have no sample data to go off of and your query that you have there doesn't have an end to it or a FROM...
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 18, 2020 at 7:24 pm
It depends. The order for the index is the order it is "ordered" in the table. So if you order it by col1 and col2, it is REALLY by col1...
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 18, 2020 at 7:17 pm
Do you have any 3rd party plugins installed (ApexSQL, RedGate, etc)?
I had a weird conflict with ApexSQL Model + ApexSQL Refactor + RedGate SQL Prompt. Had to remove the ApexSQL...
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 18, 2020 at 6:56 pm
Viewing 15 posts - 1,531 through 1,545 (of 2,917 total)