Viewing 15 posts - 556 through 570 (of 8,755 total)
I have a stored procedure that run a number of update statements using table function to select 10% of the records based on the year the data was collected.
I’m...
December 5, 2019 at 5:04 pm
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 /...
December 5, 2019 at 4:14 pm
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...
December 5, 2019 at 3:41 pm
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
Viewing 15 posts - 556 through 570 (of 8,755 total)