Forum Replies Created

Viewing 15 posts - 17,476 through 17,490 (of 49,552 total)

  • RE: The transaction log for database is full

    SQL_Surfer (7/22/2012)

    One thing though I didn't understand was if transactions gets logged in Simple Recovery model as well then what is the difference between Simple Vs Full recovery model?

    All operations...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2012 at 9:07 am

    #1515981

  • RE: index fill-factor

    opc.three (7/22/2012)

    I suspect if someone were to get serious about using fn_dblog to count 'middle page splits/sec' they could somehow achieve this by referring to the object to find out...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2012 at 9:00 am

    #1515980

  • RE: The transaction log for database is full

    SQL_Surfer (7/22/2012)

    Should we be concerned about number of VLFS? There are about 735 in there? Would adding another Log file help?

    No and no.

    Worry when you have thousands or tens...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2012 at 8:01 am

    #1515970

  • RE: SQL Server 2008 Security features

    http://www.amazon.com/Securing-SQL-Server-Protecting-Attackers/dp/1597496251/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2012 at 4:36 am

    #1515953

  • RE: Incorrect syntax near '/'.

    That was in the code I posted earlier.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 3:09 pm

    #1515889

  • RE: Incorrect syntax near '/'.

    Please post definitions for the tables involved and some sample data.

    Also, instead of EXECing the string, print it and post the output.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 2:28 pm

    #1515881

  • RE: The transaction log for database is full

    A select won't fill the log. Selects aren't logged. Data modifications are logged.

    As for the delete, the entire of that delete transaction has to be logged. Calculate how much space...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 2:27 pm

    #1515880

  • RE: Incorrect syntax near '/'.

    SELECT @info-2 = STUFF(( SELECT ', ' + 'MAX([' + TempSymbol + ']) As ['+ TempSymbol + ']'

    FROM #TempSymbolList

    FOR XML PATH('') ), 1, 1,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 12:43 pm

    #1515876

  • RE: memory leak

    As per the title of that page - "NET Micro Framework 4.1" under Windows Automotive:

    Windows Automotive is an automotive-grade open software platform that provides carmaker, suppliers, and developers with the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 12:42 pm

    #1515875

  • RE: memory leak

    You track memory in SQL with DMVs.

    Where did you hear that term and what was it talking about?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 9:11 am

    #1515859

  • RE: memory leak

    In what context, in relation to what?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 9:02 am

    #1515856

  • RE: SQL JOb

    Check what it was doing.

    You may well have to restart the SQL instance, don't do so until you know exactly what the job was doing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 6:39 am

    #1515846

  • RE: Some Intreview questions

    SKYBVI (7/21/2012)

    1.What precautions will you take before updating a million rows in a table in a production database.?

    That's asking for what you do. So, what precautions do *you* take before...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 6:37 am

    #1515845

  • RE: Error 945: MSDB is not accessble

    vikrantspatil (7/21/2012)

    1)start up SQL Server from command line in minimum configuration mode (sqlservr -f )

    2) and then restore the msdb database from a backup.

    That's not necessary. A suspect MSDB...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 6:33 am

    #1515844

  • RE: Incorrect syntax near '/'.

    You'll need to wrap the column names (as you build them up for the pivot) in []

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2012 at 4:42 am

    #1515837

Viewing 15 posts - 17,476 through 17,490 (of 49,552 total)