Forum Replies Created

Viewing 15 posts - 44,221 through 44,235 (of 49,552 total)

  • RE: Tables are big?

    Could you explain your problem a little more? How are you viewing the space used by tables?

    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

    September 24, 2008 at 1:21 pm

    #876646

  • RE: Sql Server 2005, Express Editn- Backing up db / trn log

    SQL express doesn't include the agent and therefore can't run maintenance plans.

    You can use the windows scheduler to run backup commands (using SQLCMD)

    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

    September 24, 2008 at 1:19 pm

    #876645

  • RE: Transaction Log and Recovery Model

    From what I can see from that, your log backups are failing due to insufficient space available on disk. How large is the log and how much space is available...

    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

    September 24, 2008 at 1:10 pm

    #876639

  • RE: LDF file advice appreciated

    Andrew Smith (9/24/2008)

    That's the bit I hadn't understood. Sorry for being dumb. I'll do some database shrinking through EM.

    Don't shrink the database. Shrink just the log file and shrink it...

    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

    September 24, 2008 at 1:08 pm

    #876636

  • RE: Performance Implications of Database Snapshots

    matt stockham (9/24/2008)

    Re. inserts ... wouldn't it have to write an entire page of null bytes, so still the same data size?

    Logically it shouldn't need to do anything...

    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

    September 24, 2008 at 1:05 pm

    #876633

  • RE: Disaster and Recovery, SQL 2K5 x64

    Database and backup formats are the same across all architectures (x86, x64, IA64)

    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

    September 24, 2008 at 7:26 am

    #876336

  • RE: LDF file advice appreciated

    Andrew Smith (9/24/2008)

    Thank you for the reply. Sorry I should have stated that. It's in full mode. I assume your suggesting simple mode to check whether it's old transactions 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

    September 24, 2008 at 7:25 am

    #876335

  • RE: Transaction Log and Recovery Model

    You may want to change the schedule for the log backup so that they run right through the night (rather than stopping at 9pm).

    The back ups jobs are sucesseding,...

    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

    September 24, 2008 at 7:13 am

    #876320

  • RE: How to update and select the updated records in a single T-Sql statement

    Have a look at the OUTPUT clause. If I'm understanding you correctly, it'll do what you need.

    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

    September 24, 2008 at 1:14 am

    #876146

  • RE: How to update and select the updated records in a single T-Sql statement

    Duplicate post.

    Replies to the following thread please:

    http://www.sqlservercentral.com/Forums/Topic574925-338-1.aspx

    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

    September 24, 2008 at 1:13 am

    #876143

  • RE: How to update and select the updated records in a single T-Sql statement

    Duplicate post.

    Replies to the following thread please:

    http://www.sqlservercentral.com/Forums/Topic574925-338-1.aspx

    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

    September 24, 2008 at 1:13 am

    #876142

  • RE: Index Vs Select criteria sequence

    Can you post the proc, the table and the index defs? Are there certain columns that will be more frequently searched than others?

    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

    September 24, 2008 at 1:08 am

    #876141

  • RE: Can we create database on clustered drives in sql server 2000 and sql server 2005

    What do you mean by 'clustered drive'?

    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

    September 24, 2008 at 1:07 am

    #876140

  • RE: Installation Confusion

    Did you select the client tools during the install?

    Note if you have developer on CD, that there are 2 CDs, one with the server components and one with the client...

    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

    September 24, 2008 at 12:44 am

    #876138

  • RE: Error conecting because of Login Trigger

    Ah. Makes sense.

    Biggest things to keep in mind is to not reference any DB other than master within the trigger, make sure that there are no permissions issues (I recommend...

    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

    September 24, 2008 at 12:41 am

    #876136

Viewing 15 posts - 44,221 through 44,235 (of 49,552 total)