Viewing 15 posts - 1 through 15 (of 53 total)
Brad,
Should all be fixed as of service pack 3 http://redmondmag.com/articles/2011/10/07/sql-server-2008-service-pack-3-available.aspx
I have tested this and found no issues but I would advice that you so the same.
Steve
January 14, 2013 at 2:39 am
Hi Brad
I Believe that this issue has been addressed in one of the service packs and should now work as expected. I will confirm tomorrow.
Steve
January 13, 2013 at 4:18 pm
Hi Thomas
Since totally purging the transaction log is the key step of this fix, i do not think you are going to be able to do this without taking mirroring...
November 22, 2012 at 2:25 am
Great set of articles. I am really enjoying working through them.
Is it just me or are these articles from the future?!?!? Level 2 is dated the 15th Aug 2012 and...
August 13, 2012 at 8:18 am
The extension of the Access file is .adp
There is no connection string in the code behind the forms, it is using Data Link which i think is part of OLE...
April 11, 2012 at 8:32 am
No worries, i am just happy for the help.
The Linked Table Manager is greyed out. I have been have trouble finding where the access/database interaction takes place. When an action...
April 11, 2012 at 2:21 am
The Pivot seems to work fine in Access, its a bit slow but that may be down to the rubbish machine that i am using!
I held down SHIFT as the...
April 10, 2012 at 9:47 am
Hi Wendell
Thanks for your reply. I am using version 14.0.6112.5000 which i believe is the latest version.
The PIVOT is being done in access, the database view is static.
As for the...
April 10, 2012 at 8:02 am
Yes, that is correct but make sure to follow the steps in the article to remove TDE. 🙂
November 8, 2011 at 7:29 am
crazy4sql (11/2/2011)
Hi Steve, how about if we have 5 user database enabled with TDE and want to remove TDE permanently only on one/few database?
Hi Ashish
The steps apply in the...
November 8, 2011 at 7:04 am
Thanks for all the comments. I have just come back from holiday and seeing all the positive comments has helped chase away the post holiday depression!
November 8, 2011 at 5:55 am
From what I read as long as cluster size / stripe size = an integer then all was good.
October 13, 2011 at 1:52 am
Using the HAVING clause is the most efficient way of doing it, but there are other ways.
Are you required to not use the HAVING clause?
June 9, 2011 at 8:47 am
Or
SELECT C.CustomerName,C.ServiceID,C.Rendered ,S.ServiceName
FROM #Customer C
Inner JOIN #Services S ON S.ServiceID = C.ServiceID
WHERE CustomerName IN (
SELECT CustomerName FROM #Customer
WHERE Rendered = 1
GROUP BY CustomerName
HAVING COUNT (CustomerName) = (SELECT COUNT(*)...
June 9, 2011 at 2:38 am
At a guess i would say its a rights issue rather then a hardware issue.
Having never imported an SSIS package as a SP i am assuming that the package...
June 8, 2011 at 8:53 am
Viewing 15 posts - 1 through 15 (of 53 total)