Forum Replies Created

Viewing 15 posts - 9,466 through 9,480 (of 49,552 total)

  • RE: Log file is filling up

    Steve isn't suggesting running the traces via the GUI. He's suggesting using the GUI to create a server-side trace script and then running that. It's easier than trying to write...

    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

    April 1, 2014 at 6:55 am

    #1702004

  • RE: The SQL Server service terminated

    Start with the latest error log and any relevant-looking messages from the Windows event log, system and application logs.

    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

    April 1, 2014 at 5:02 am

    #1701965

  • RE: Issue Access Named Instance

    No, that has nothing to do with the OS's memory.

    Can you post the error log?

    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

    April 1, 2014 at 4:25 am

    #1701949

  • RE: Issue Access Named Instance

    Start up failure. Check the latest error log and see why the start up is failing.

    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

    April 1, 2014 at 4:05 am

    #1701940

  • RE: Are the posted questions getting worse?

    Ok...

    "The language is expressive, easily readable and values explicitness. Abbreviations and corrupted spelling should be avoided in variable names"

    and the string data type is 'str'

    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

    April 1, 2014 at 4:03 am

    #1701938

  • RE: Issue Access Named Instance

    Looks like the instance isn't running. Check that the appropriate service is running

    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

    April 1, 2014 at 3:41 am

    #1701924

  • RE: Are the posted questions getting worse?

    I'm watching an introductory course (on Pluralsight) on a new language, and the introduction is almost enough to make me ditch the language and never look at it again.

    "... 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

    April 1, 2014 at 3:02 am

    #1701909

  • RE: SP

    So run the original, run the changed and make sure that behaviours are the same. Basic unit testing.

    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

    April 1, 2014 at 2:16 am

    #1701902

  • RE: when to use dbcc shrinkdatabase

    yuvipoy (3/19/2014)

    I am having a database size ofaround 15 Gb.

    I am deleting older records on time bases which around 1 GB , on the deleting can dbcc shrinkdatabase ?

    Probably not...

    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

    April 1, 2014 at 2:13 am

    #1701900

  • RE: IDENTITY(1,1) doesn't work, from 17 jumped to 1001

    Bear in mind that identity has never been guaranteed to not have gaps. It's an ever-increasing number, that's all. It's not gap-free and it's not even guaranteed unique (you can...

    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

    April 1, 2014 at 2:09 am

    #1701899

  • RE: X in Technology

    skeleton567 (3/31/2014)

    They don't want to swim with the same sharks as the rest of us.

    Actually, yes we do.

    Sure, there are some groups which give them all a bad...

    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

    April 1, 2014 at 12:58 am

    #1701887

  • RE: TEMPDB issue

    No. Never said that.

    I said, if you change the initial size it will start smaller. That's it. Counter-productive, as SQL now has to grow the files, but if you want...

    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

    March 31, 2014 at 3:20 pm

    #1701824

  • RE: Tranaction Logs on a Test Box

    Or, as something a tad easier:

    exec sp_MSforeachDB 'USE [?]; IF ''?'' NOT in (''master'',''model'',''msdb'',''tempDB'') DBCC ShrinkFile(2,10)'

    Untested, so may have syntax errors. Test before use.

    Shrinkfile takes either the file...

    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

    March 31, 2014 at 3:19 pm

    #1701823

  • RE: TEMPDB issue

    Work as in start smaller, probably. Work as in not get full and throw errors, probably not.

    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

    March 31, 2014 at 3:12 pm

    #1701818

  • RE: X in Technology

    skeleton567 (3/31/2014)

    I just want to be a skilled professional and be recognized for that alone.

    That would be very nice.

    I have before been asked if I'm at the wrong interview,...

    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

    March 31, 2014 at 2:43 pm

    #1701807

Viewing 15 posts - 9,466 through 9,480 (of 49,552 total)