Viewing 15 posts - 736 through 750 (of 2,917 total)
To add to your patching notes, it also falls under how much planned downtime can you get. I have some systems that require maximum uptime and downtime on them is...
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.
December 20, 2021 at 7:21 pm
To add to what Phil said, my understanding is that ADS (Azure Data Studio) is more of a "development" tool and SSMS is more of a "management and administration" tool.
Deploying...
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.
December 20, 2021 at 7:13 pm
My opinion - VERY. In general, what you are going to be doing the most of in SQL is NOT going to be CPU heavy operations but memory and disk...
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.
December 19, 2021 at 9:05 pm
I MAY be mistaken on this, but I think that an i9 is a desktop processor not a server processor. Generally, you would want to have SQL Server running 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.
December 19, 2021 at 2:15 pm
Ah yes, that's much easier to read now, on my brand new 20-metre-wide screen.
You just need to make your font smaller if it doesn't fit 😛
BUT even if 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.
December 17, 2021 at 2:46 pm
That is VERY hard to read and consume... But stripping out everything prior to the line of *'s, fixing a bad piece of formatting, and running it through a SQL...
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.
December 17, 2021 at 2:39 pm
To add to what Phil is saying - I would try it out and see what happens. Basically, run your code and then either SELECT or PRINT @Where to see...
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.
December 16, 2021 at 5:37 pm
Looks like you changed the post after ratbak replied?
What I would recommend is rather than executing the dynamic SQL, print it so you can see exactly what will be run...
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.
December 16, 2021 at 5:36 pm
A few ways I can think of to fix this. I think the BEST solution to fix it is to change the SQL Server Agent service to be an AD...
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.
December 16, 2021 at 4:07 pm
Is there a reason you don't want to do it from the web interface?
Offhand, I am not sure how to remove them using rs.exe or any other utility, but I...
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.
December 15, 2021 at 9:40 pm
Wouldn't that be related to parameter sniffing in the scenario I gave vs function in a WHERE clause in the OP? And if so, the performance could tank due 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.
December 15, 2021 at 7:37 pm
Without seeing any of your data or datatypes, I am really just guessing, but I would be willing to bet that it is related to your group by statement 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.
December 15, 2021 at 7:16 pm
Offhand, the best way I have found to search for it is to use SQL Search OR to script out all of the jobs and do a search in those. ...
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.
December 15, 2021 at 7:09 pm
Yeah, I wasn't saying it was "good", it is just what it was doing. I prefer the "WHERE (A=@a) OR (@a IS NULL)" approach myself... and depending on how often...
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.
December 15, 2021 at 6:57 pm
if @Parameter3 is null, then use table1.id2.
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.
December 15, 2021 at 6:05 pm
Viewing 15 posts - 736 through 750 (of 2,917 total)