Viewing 15 posts - 2,086 through 2,100 (of 2,917 total)
Hi Jeff,
I sent you a PM on the scripts because I feel we are getting a bit off topic from the original post. If you prefer, I can post 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.
February 26, 2020 at 2:34 pm
Still not seeing the "recursion" that is required here. With the updated data, does this not work:
SELECT
[T1].[col11]
, [T1].[col1]
, [T1].[col2]
, [T2].[col5]
, [T2].[col6]
, [T3].[col9]
, [T3].[col2]
FROMtable1 AS [T1]
JOINtable2...
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.
February 24, 2020 at 5:58 pm
Looking at that data set and sample output, I am confused on a few things. First, why would this need to be dynamic? Second, why would this need to be...
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.
February 24, 2020 at 2:51 pm
thanks for the code Jeff.
Downloading it and looking through that today!
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.
February 24, 2020 at 1:56 pm
Hello Jeff,
Any update on that code? I am curious to look at 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.
February 21, 2020 at 5:35 pm
Drew, I think that both single and double quotes are valid according to the XML standard (or at least my interpretation of it).
Microsoft's interpretation in the .NET framework allows for...
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.
February 21, 2020 at 4:15 pm
I believe your issue here is that code is not being provided a string literal which is required by the XML 1.0 standards.
Similar issue to yours, but slightly different:
His issue...
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.
February 20, 2020 at 9:57 pm
Hello Jeff,
Not sure if it is useful for the OP, but it does look like an interesting report to me.
I would like to have a copy of that 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.
February 19, 2020 at 7:32 pm
Jeff - that script sounds useful. Any chance you could post it on here or link to it on github or something?
Currently, we are using RedGate for our monitoring 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.
February 19, 2020 at 3:07 pm
Have a look at this webpage:
https://regex101.com/r/cO8lqs/2
It lets you test out RegEx and it provides an explanation of what the regex is doing.
Your understanding of that part is correct. (.) 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.
February 18, 2020 at 9:57 pm
A failed ping also doesn't mean the server is "up". Firewall, for example, could block a ping but the server could still be up.
That being said, if you want fewer...
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.
February 18, 2020 at 9:13 pm
Another thing to check is - is it actually SQL Server using the CPU?
If you have predictable times that the CPU is high, check things out in task manager as...
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.
February 18, 2020 at 8:14 pm
That error is strange. It should be executing the stored procedure xp_logininfo against only Windows AD Groups. If it got an error, I'm guessing you don't have permission to 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.
February 18, 2020 at 6:48 pm
Did you run profiler/extended events to see which account your query was being run as?
Also, is this a cross database query OR does the view contain cross-database objects?
What I mean...
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.
February 18, 2020 at 3:47 pm
As a thought, what about creating a temporary table (or table variable), with all of the columns you want and populating that table by running both queries. As both queries...
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.
February 14, 2020 at 8:15 pm
Viewing 15 posts - 2,086 through 2,100 (of 2,917 total)