Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

All Blogs

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    comments

    I had to change the account that some SQL Server boxes were using to run the SQL Server services. After I changed the account on one machine from DomainName\User to DomainName\NewUser SQL Server wouldn't start up In the error log I saw the following…

    Read More...
    comments

    Windows Azure Training Kit April 2013 Released

    by SQLDenis on Apr 29, 2013 in categories Azure. Article views: 1457 views

    Miscrosoft has released the Windows Azure Training Kit April 2013. The Windows Azure Training Kit includes a comprehensive set of technical content designed to help you learn how to use Windows Azure. The kit includes hands-on labs, presentations, de…

    Read More...
    comments

    Error while enabling Windows Feature: Netfx3

    by Koen Verbeeck on Apr 29, 2013 in categories Business Intelligence. Article views: 8793 views

    Recently I was setting up a virtual machine environment to do some demo’s. One of the virtual machines would be the home for a SQL Server database engine supporting a SharePoint 2013 farm. Since it is a back-end database, the server was not connected to…

    Read More...
    comments

    If you look at the sys.sysobjects view, you will see an xtype column listed Object type. Can be one of the following object types: AF = Aggregate function (CLR) C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L…

    Read More...
    comments

    Trying out Anotar Fody.

    Read More...
    comments

    Force installation of 64-bit ACE OLE DB provider

    by Koen Verbeeck on Apr 23, 2013 in categories Microsoft SQL Server, SSIS. Article views: 8986 views

    This blog post describes how you can install the 64-bit ACE OLE DB provider when you have 32-bit Office components installed.

    Read More...
    comments

    Missing index suggestion – Duplicate Index The missing index feature while tuning or checking estimated and actual plans is very helpful.  Something that is key in that sentence is the word, helpful.  Don’t run out and simply create all of them.  Make…

    Read More...
    comments

    SQL Azure Log Space Errors 40552

    by Ted Krueger (onpnt) on Apr 15, 2013 in categories Business Intelligence. Article views: 9613 views

    If you are dealing with SQL Azure and a large data volume, you’re bound to run into this error. Msg 40552, Level 20, State 1, Line 1 The session has been terminated because of excessive transaction log space usage. Try modifying fewer rows in a singl…

    Read More...
    comments

    On Saturday, April 6, 2013, Madison, WI hosted its second annual SQL Saturday. It was another successful year! We had 241 attendees, an increase over last year. It’s been exciting to watch the Wisconsin SQL Server community grow over the past five ye…

    Read More...
    comments

    When working on SQL Server that is stretching IO and the subsystem to its limits, you are bound to see a buffer latch time-out error at some point. This is typically, "Time-out occurred while waiting for buffer latch type 2 or 3". If you do, it will us…

    Read More...

    << Previous :: Next >>