Forum Replies Created

Viewing 15 posts - 16,081 through 16,095 (of 49,552 total)

  • RE: 'DBCC' is not recognized as an internal or external command

    Look up SQLCMD. It's a command-line (runs from OS command console) SQL Server querying tool (runs commands against whatever SQL Server it connects to)

    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

    October 16, 2012 at 10:03 am

    #1549665

  • RE: Upgraded SQL Server 2005 to SQL Server 2008, but it still reports 2005

    Start with SQL Server Configuration manager, or in management studio (the 2008 one) check registered servers.

    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

    October 16, 2012 at 10:01 am

    #1549662

  • RE: Commit, truncate of log file and checkpoint in SQL Server

    Vegard Hagen (10/16/2012)

    For the record, I might add that a truncate log does not actually clear individual records or transactions from the log. It simply clears all VLFs (Virtual 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

    October 16, 2012 at 9:57 am

    #1549660

  • RE: Trying to view properties of the Database

    The server needs to be in single user mode, not the master database. There's a section in books online on restoring the master database and it goes through the steps...

    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

    October 16, 2012 at 9:43 am

    #1549652

  • RE: Upgraded SQL Server 2005 to SQL Server 2008, but it still reports 2005

    No, that's not a compat level. I suspect you're connecting to the wrong instance, the services shows a SQL 2005 instance as well as the SQL 2008.

    Did you install...

    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

    October 16, 2012 at 9:42 am

    #1549651

  • RE: TRANSACTION and @@IDENDITY

    Plus the book chapter I referenced 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

    October 16, 2012 at 9:04 am

    #1549626

  • RE: TRANSACTION and @@IDENDITY

    Yes, you may want to do some research into that switch.

    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

    October 16, 2012 at 8:49 am

    #1549617

  • RE: Upgraded SQL Server 2005 to SQL Server 2008, but it still reports 2005

    Did the upgrade succeed? Did you upgrade the database engine or just the client tools? Are you looking at the right instance?

    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

    October 16, 2012 at 8:49 am

    #1549616

  • RE: 'DBCC' is not recognized as an internal or external command

    You execute DBCC commands exactly as you execute any database query (select, update, insert, delete, etc). The error suggests you're trying to run them from the OS command prompt, that...

    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

    October 16, 2012 at 8:26 am

    #1549605

  • RE: TRANSACTION and @@IDENDITY

    C# Gnu (10/16/2012)

    GilaMonster (10/16/2012)

    C# Gnu (10/16/2012)

    Addition: so this in effect was my worry - that systems would be locked out while the transaction is open

    If they try to read rows...

    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

    October 16, 2012 at 8:24 am

    #1549604

  • RE: Would a smaller number of VLFs in the log speed up the redo phase of recovery of a mirror snapshot?

    :rolleyes:

    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

    October 16, 2012 at 8:21 am

    #1549602

  • RE: TRANSACTION and @@IDENDITY

    C# Gnu (10/16/2012)

    Addition: so this in effect was my worry - that systems would be locked out while the transaction is open

    If they try to read rows that are locked,...

    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

    October 16, 2012 at 7:53 am

    #1549573

  • RE: TRANSACTION and @@IDENDITY

    Readpast hint.

    Snapshot isolation

    Read committed snapshot isolation

    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

    October 16, 2012 at 7:52 am

    #1549572

  • RE: Shrinking Transaction Log File "the right way"

    No need to truncate the log and break the log chain to fix fragmentation. Pick a time the DB is not heavily used (not used at all is better) and...

    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

    October 16, 2012 at 7:48 am

    #1549566

  • RE: TRANSACTION and @@IDENDITY

    C# Gnu (10/16/2012)

    Can I confirm I understand this correctly - I believe no other connection will be able to insert into the Orders Table until commit or rollback, and upon...

    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

    October 16, 2012 at 7:12 am

    #1549534

Viewing 15 posts - 16,081 through 16,095 (of 49,552 total)