Viewing 12 posts - 1 through 12 (of 12 total)
And an update: Microsoft have released a fix for this bug, Microsoft Connector for Oracle V1.2 from the Microsoft Download Center
"https://www.microsoft.com/en-us/download/details.aspx?id=104113"
Be aware, apparently this adapter requires SQL Server 2019 and...
April 21, 2022 at 12:56 pm
"Subsequently we have found this is not just an upgrade issue, it can impact any Oracle data source based on the new component."
In other words yes, any project including a...
January 21, 2022 at 4:44 am
"We have raised this issue with Microsoft and are not looking for other assistance but given the potential impact I thought we had best share that the problem exists."
January 21, 2022 at 4:42 am
Ouch. As with everything workwise leaving a company should be a team process.
We are all human and in 12 years of service we will inevitably forget...
October 20, 2020 at 8:27 pm
Simply stating a known issue (recompilation) has , I suppose some merit.
However it would be much more interesting to see some quantitative analysis of the effects or otherwise of recompilation,...
June 7, 2012 at 12:45 am
Hello Terry
Afraid I see the same results as Hugo. The elapsed time for the second approach seems much higher and far more records are read. Looking at the plan the...
November 1, 2010 at 2:50 am
"UPDATE dbo.tblProduct*
SET Color = 'Black'
WHERE Name = 'ML Mountain Frame-W - Silver, 42';"
I might be missing something but how can you expect a surrogate key to improve performance if you...
October 24, 2010 at 10:08 pm
Very interesting approach. Without more test data I cant say is its any faster than straight inserts (below) but a nicely written article. Many thanks for taking the...
January 25, 2010 at 2:20 am
A really good point, well made. As Joe says, using a staging area is best practice. However staging will never fully insulate you from the real world.
In fact Obstacle...
November 23, 2009 at 1:25 pm
Sorry, Footer is O.K. - header no luck - same sort of restriction as for db images. Come on M$!
March 13, 2009 at 4:13 am
Unless I am missing something, this does not work in the header or footer of the report. Would love to be proved wrong but if so it does limit the...
March 13, 2009 at 3:49 am
Surely as mentioned earlier the SA account has by default full access to database objects. However if database storage is created on an external file system like a SAN...
December 8, 2008 at 6:15 am
Viewing 12 posts - 1 through 12 (of 12 total)