Viewing 15 posts - 976 through 990 (of 2,917 total)
My understanding is that they are 2 completely different data capture methods. Ring buffer is a buffer and only exists in memory. The advantage to this is that you are...
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.
August 16, 2021 at 9:31 pm
Pretty sure for this to work you are either going to need to have your stored procedure call a second stored procedure (likely the approach I would go with) OR...
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.
August 13, 2021 at 4:29 pm
I updated my post as the forum apparently didn't like the alias I used.
Since you are updating everything and you are doing it every 24 hours, I would recommend trying...
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.
August 13, 2021 at 3:20 pm
I would start development on this by making it work with a SELECT statement, which you can do with 2 JOINs. The basic logic of it is you want 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.
August 12, 2021 at 2:13 pm
Probably a silly question but is there a reason you are wanting to drop ALL clean buffers and free ALL the caches before you do your steps? And why 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.
August 11, 2021 at 7:29 pm
I think that this page will help:
https://www.sqlshack.com/max-worker-threads-for-sql-server-always-on-availability-group-databases/
The link above says that for 500 databases with 1 primary, 2 secondaries, and 1 availability group your MINIMUM threads should be 1501. 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.
August 11, 2021 at 7:19 pm
Something along the lines of:
string text = ex.Message;
string path = @"C:\Data\TextFiles\logFile.txt";
System.IO.File.AppendAllText(path, text);
Although, if you are "really new to C#", I would recommend reading up a bit on...
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.
August 11, 2021 at 3:55 pm
Quick google brought me to this:
https://www.linkedin.com/pulse/ssrs-2017-anonymous-authentication-problem-solved-frans-van-der-geer/
Following directions for SQL Server 2008 to configure something for SQL Server 2017 sounds like a recipe for disaster in my opinion. The fun part...
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.
August 11, 2021 at 2:41 pm
I think the best way depends on what sort of issues you are looking for.
If it is frequent high CPU, then task manager or WMI or perfmon will tell 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.
August 11, 2021 at 2:36 pm
Not sure I can help, but first thing I'd do is change the C# you posted to exclude the username and password and smtp client name. don't need people 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.
August 10, 2021 at 7:21 pm
If I remember right with R (it's been a while since I touched it as it isn't really related to my job), the file you create is essentially just 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.
August 9, 2021 at 4:22 pm
I'm a little late to this reply, but with respect to my comment about service broker - if you set it up, I'd check to make sure you are following...
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.
August 9, 2021 at 4:01 pm
As far as I know there is no way to do that nicely inside SQL.
If doing it inside SQL is a requirement, you could modify the code you are running...
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.
July 30, 2021 at 3:42 pm
Easiest way - change the division to handle when 0 may be the result. How you handle that is up to you, but my approach would be to set 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.
July 29, 2021 at 8:26 pm
It includes them becuase the Prod Line is different.
Your original requirement (original post) says:
" I only want to include ME# where there are 2 different Prod Lines associated with single ME"
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.
July 29, 2021 at 5:52 pm
Viewing 15 posts - 976 through 990 (of 2,917 total)