Viewing 15 posts - 2,056 through 2,070 (of 2,917 total)
Quick google brought me to this page:
https://docs.microsoft.com/en-us/archive/blogs/sqltips/ordering-guarantees-in-sql-server
which states in point number 4:
INSERT queries that use SELECT with ORDER BY to populate rows guarantees how identity values are computed but not...
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.
April 14, 2020 at 2:45 pm
Have you tried creating an alias on server B?
Where I work, we have the SQL aliases pushed out through the logon script (VBScript) to each end user machine. Putting an...
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.
April 9, 2020 at 5:37 pm
One thing to watch out for is with your linked server, are you passing your credentials along OR using a hard-coded username and password?
If it is hard coded, that account...
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.
April 9, 2020 at 5:34 pm
If I am looking at that execution plan correctly, the left-most operation is a cursor. Cursors will impact performance as they are row based operations. If you can remove 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.
April 8, 2020 at 7:31 pm
that is, as far as I can see, an older paper.
Visual Studio Subscriptions (formerly MSDN subscriptions) - latest licensing whitepaper here.
from it
Different Licensed Users Can Run the Same...
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.
April 8, 2020 at 6:59 pm
Quick thing about MSDN licensing - End users who are doing acceptance TESTING do not require a license. To quote Microsoft's licensing terms:
Acceptance Testing and Feedback. Your end users 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.
April 8, 2020 at 4:57 pm
This would probably be written better as an "IF" statement rather than a CASE... something along the lines of:
IF EXISTS (SELECT 1 FROM [ITRM_ITBF].[Dflt].[MANUAL_LSV_PERMISSIONS] WHERE USERNAME =...
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.
April 8, 2020 at 4:45 pm
Blanks are a bit harder to deal with. One way would be to add a UNION onto the query... something like:
UNION
SELECT NULL
WHERE NOT EXISTS(SELECT 1
FROM <table>
WHERE SSN...
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.
April 8, 2020 at 3:36 pm
My preference is to avoid maintenance plans wherever possible. I have run into issues with them and when a problem comes up, it can be tricky to reproduce and debug. ...
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.
April 8, 2020 at 3:27 pm
I've not used developer edition, but we also run SQL Server Standard at my workplace. I am just offering a different option: Visual Studio subscription licensing for your test/dev environment. Everyone...
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.
April 8, 2020 at 3:07 pm
Hello JSB_89,
Have you checked the logs? That would be my first step. Check PBI logs and IIS logs and windows event logs. One of them should have something useful in...
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.
April 7, 2020 at 8:52 pm
Your max memory is set way too high. I would drop that down to a more reasonable value.
As Frederico_fonseca said, you should have at LEAST 1 GB free 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.
April 6, 2020 at 2:37 pm
Looking at the log it says it out of memory. "Memory allocation failure". You need more memory on your VM or need to allocate your memory differently.
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.
April 3, 2020 at 6:31 pm
As a thought, do you have a linked server on Server1 that points back to Server1?
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.
April 3, 2020 at 6:28 pm
If this is a manual process of extracting the data to CSV, you could probably do a find-and-replace in the CSV.
If you are using a tool (SSRS for example), you...
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.
April 2, 2020 at 3:05 pm
Viewing 15 posts - 2,056 through 2,070 (of 2,917 total)