Forum Replies Created

Viewing 15 posts - 13,621 through 13,635 (of 49,552 total)

  • RE: abrupt SQL Server restarts

    Could you post your 2008 problem in a new thread (in the 2008 forum) and include the last portion of the error log from before an abrupt restart?

    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 2, 2013 at 12:03 pm

    #1602918

  • RE: Best Way to Speed Up Queries

    timotech (4/2/2013)

    My question is that can i make my queries run more faster, since they are online on another server.

    You probably can, same process, identify the poorly performing areas, fix...

    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 2, 2013 at 11:44 am

    #1602909

  • RE: 2k5 MDF Emptyfile -> NDF

    DuncEduardo (4/2/2013)

    ok thanks Gail - just one last thing however - failed to mention that I have already shrunk the mdf.

    Will the action you suggest work ok in this scenario?

    Yes.

    I...

    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 2, 2013 at 11:40 am

    #1602906

  • RE: SQL Compatibility Mode Questions

    amy26 (4/2/2013)

    GilaMonster (4/2/2013)

    amy26 (4/2/2013)

    I'm really bummed about this cause now I can't use some of the new features of SQL 2008 :angry:

    Why not?

    Comparability level doesn't disable new features, it just...

    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 2, 2013 at 11:32 am

    #1602904

  • RE: Is AutoShrink Logged ?

    All operations that change the database in any way are logged, no exceptions.

    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 2, 2013 at 10:08 am

    #1602879

  • RE: SQL Compatibility Mode Questions

    amy26 (4/2/2013)

    I'm really bummed about this cause now I can't use some of the new features of SQL 2008 :angry:

    Why not?

    Comparability level doesn't disable new features, it just changes how...

    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 2, 2013 at 10:06 am

    #1602878

  • RE: 2k5 MDF Emptyfile -> NDF

    ShrinkFile with the EmptyFile option the ndf then drop it. Then just shrink the remaining data file to a reasonable size and rebuild your indexes afterwards.

    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 2, 2013 at 10:04 am

    #1602877

  • RE: find total amount of procedure cache (In GB) used by a stored procedure

    With the exception of different set options, a procedure will only have a single plan in cache at a time, so measured more likely in kB than GB.

    Query sys.dm_exec_cached_plans, cross...

    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 2, 2013 at 10:02 am

    #1602874

  • RE: recovery model

    Master because you can never restore log backups of the master database (it can't be restored WITH NORECOVERY)

    Model set to whatever you want new databases to have, default is full,...

    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 2, 2013 at 9:58 am

    #1602870

  • RE: Do views use an optimised execution plan?

    invisibleduncan (4/2/2013)

    So although it could be argued that I was correct, any query that uses the view would create a cached execution plan in the same way that it would...

    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 2, 2013 at 9:53 am

    #1602868

  • RE: Best Way to Speed Up Queries

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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 2, 2013 at 9:11 am

    #1602850

  • RE: Cant Restore Differential Backup

    There was another full backup taken (without the copy_only option) sometime between the full that you took and the diff that you took.

    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 2, 2013 at 9:09 am

    #1602849

  • RE: Do views use an optimised execution plan?

    Views don't have stored execution plans, because they're just saved SQL statements and are replaced by their definition early in the parsing phase of a query. They're not executed 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

    April 2, 2013 at 9:03 am

    #1602846

  • RE: VARCHAR(200) vs VARCHAR(2000)

    theashishtrivedi (4/2/2013)

    If I define VARCHAR(8000) and store 10-20 characters in it, there should be some performance issue in long run (i.e. SQL Server will reserve the space for 8000 characters...

    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 2, 2013 at 8:43 am

    #1602838

  • RE: 2k5 MDF Emptyfile -> NDF

    Shrinking with EmptyFile will give you just as much fragmentation as shrinking without that option. It's not a magic good shrink.

    If all you're trying to do is remove empty 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

    April 2, 2013 at 8:41 am

    #1602835

Viewing 15 posts - 13,621 through 13,635 (of 49,552 total)