Viewing 15 posts - 556 through 570 (of 8,760 total)
That feeling when you want to point out that someone isn't correct about what they said, but you don't want to derail a topic and / or annoy said...
December 5, 2019 at 3:38 pm
Is anyone one else still getting directed to the wrong page of responses? I was on the 'Active Threads' view and clicked on the link for Josana.work response on...
December 4, 2019 at 5:43 pm
Query your plan cache to see which queries are using the most CPU. Are you updating statistics regularly? If not, inappropriate, resource-intensive plans could be being compiled. Make...
November 28, 2019 at 6:49 pm
Fantastic article, do you have any links to using the % to return value. never seen the use of % like this (T.N-1)%3 +1
thanks
The % is the modulus operator,...
November 16, 2019 at 12:51 pm
Good job Mike and thanks for this fine write-up
😎
November 11, 2019 at 1:19 pm
Eirikur Eiriksson, sorry to hear about your crystall ball. I hope it cristallizes again. Perhaps with the hourglass bbq of Steve.
This is how it looks like, kind of...
October 31, 2019 at 5:19 pm
To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?
You owe me a crystal ball Joe, I popped the question...
October 30, 2019 at 1:07 pm
I've found that using the latest Oracle drivers is much more efficient than the MS drivers, is that an option?
😎
BTW: in a recent project, I experienced up to 10x difference...
October 17, 2019 at 3:28 pm
I have a query that creates an xml file but I'm getting errors because the XML is too large. I've already set the Results To Grid Property XML Data...
October 17, 2019 at 2:29 pm
Oracle driver oddities: create table as select * @from_dblink 1 minute. SSIS select * + rowcount: 80 minutes with Oracle Oledb 🙁
Is this on an on-prem or in the...
October 17, 2019 at 2:22 pm
I think we may have interpreted the q differently. I took "statistics i/o" to mean the results from:
SET STATISTICS IO ON;
The logical i/o results are directly comparable, aren't they?
I think...
October 16, 2019 at 11:14 am
Suggest you get Grant's book on execution plans, statistics IO is not comparable when it comes to any kind of troubleshooting unless you want to troubleshoot yourself in the foot.
😎
October 15, 2019 at 3:09 pm
Why the extra step of replacing the concatenated CR and LF? Doesn't replacing the individual CHARs suffice? That's how I've done it, and I'd like to know if there...
October 15, 2019 at 1:47 pm
Folks:
I would like to replace CHAR(13) (Carriage Return) with space and I use this SQL to replace it, but the problem is when the column has NULL values it...
October 15, 2019 at 12:51 pm
IIRC, 18456:1:X error should result in an entry in the SQL Error Log, have you checked if anything is there?
😎
Quick question, is this a named instance?
October 11, 2019 at 12:58 pm
Viewing 15 posts - 556 through 570 (of 8,760 total)