Forum Replies Created

Viewing 15 posts - 24,346 through 24,360 (of 49,552 total)

  • RE: Problem: SQL-Database with 4 GB

    You want to delete in chunks, so that the log doesn't blow out.

    Simple recovery or full recovery model?

    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

    August 8, 2011 at 8:15 am

    #1365244

  • RE: Temp table vs Table variable

    Ninja's_RGR'us (8/8/2011)

    Not to be too anal here, but you can't really add NC indexes, you can only add NC constraints.

    And a unique constraint is enforced by a unique index,...

    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

    August 8, 2011 at 7:37 am

    #1365216

  • RE: Temp table vs Table variable

    skcadavre (8/8/2011)

    "Table variables are not the same as temporary tables. The biggest differences are that: -

    •Temporary tables can be altered with DDL statements whereas table variables cannot.

    Essentially, this means...

    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

    August 8, 2011 at 6:40 am

    #1365166

  • RE: i got fixed with file ..... i trying to ..plz help....plz...plz

    sqlmaverick (8/7/2011)

    i selected fixed width option, but i am displayed with only one column in preview

    Yes, because you then have to go and specify where the columns are (SQL can't...

    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

    August 8, 2011 at 6:29 am

    #1365158

  • RE: Are the posted questions getting worse?

    I suspect he was answering Kraig's question 'So who are you?'

    Of course, anyone who's watched Season 2 of Babylon 5 knows that's completely the wrong answer (and it's the wrong...

    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

    August 8, 2011 at 6:08 am

    #1365131

  • RE: Problem: SQL-Database with 4 GB

    Use a delete query (in a T-SQL query window), not the table editor.

    The table editor's got a fair few bugs and does the deletes one row at a time.

    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

    August 8, 2011 at 3:52 am

    #1365081

  • RE: Can REBUILDING the index cause deadlock?

    GilaMonster (8/5/2011)

    You need to identify the queries, look at the locks taken and the length of the transactions and optimise as much as possible. Short transactions, efficient queries and objects...

    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

    August 8, 2011 at 3:40 am

    #1365080

  • RE: LOg files Growth - Out of Control

    No, the sys.databases view is instance-wide, there's one row in it for each database on that SQL instance.

    Try including a couple of the other columns from it (look in Books...

    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

    August 8, 2011 at 3:16 am

    #1365072

  • RE: LOg files Growth - Out of Control

    And which of those is for the database with the full 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

    August 8, 2011 at 3:01 am

    #1365067

  • RE: LOg files Growth - Out of Control

    Why are you trying to shrink a file when the error is that it's full.

    Full means that all space is used. To make space (ie to fix a full 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

    August 8, 2011 at 2:00 am

    #1365054

  • RE: Why I can't shrink the log file?

    Careful trying to shrink tempDB, it can cause problems that will require a server restart. You should quiesce the server completely (no user connections at all) before trying to shrink...

    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

    August 8, 2011 at 1:59 am

    #1365053

  • RE: How will you write a query for this scenario

    Jeff Moden (8/7/2011)

    GilaMonster (8/7/2011)

    I had to do something like that for a client a couple years back. The eventual solution was partially set-based, with a while loop tossed in 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

    August 8, 2011 at 1:46 am

    #1365045

  • RE: How will you write a query for this scenario

    I had to do something like that for a client a couple years back. The eventual solution was partially set-based, with a while loop tossed in and came out at...

    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

    August 7, 2011 at 2:34 pm

    #1364918

  • RE: compare two database?

    RedGate has 2 tools - SQLCompare and SQLDataCompare

    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

    August 7, 2011 at 9:05 am

    #1364883

  • RE: Using SQL Server 2005 for 2008 exams

    SQL does not use excessive CPU when it's not active. Sure, it'll use that while queries are running, but it uses around 0 when it's idle.

    You can also (as has...

    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

    August 7, 2011 at 4:05 am

    #1364866

Viewing 15 posts - 24,346 through 24,360 (of 49,552 total)