Viewing 15 posts - 2,026 through 2,040 (of 2,857 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...
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...
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...
February 24, 2020 at 2:51 pm
thanks for the code Jeff.
Downloading it and looking through that today!
February 24, 2020 at 1:56 pm
Hello Jeff,
Any update on that code? I am curious to look at it.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
February 14, 2020 at 8:15 pm
Viewing 15 posts - 2,026 through 2,040 (of 2,857 total)