Forum Replies Created

Viewing 15 posts - 24,451 through 24,465 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    GSquared (8/4/2011)

    I've never yet had a bad experience with it either. But past performance doesn't necessarily predict future outcomes, or whatever it is that financial firms are required 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

    August 4, 2011 at 1:42 pm

    #1363947

  • RE: Using a copy of a backup

    Specify the log file name as well, give it a new name.

    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 4, 2011 at 1:40 pm

    #1363945

  • RE: sqlserver 2005 died have database on usb drive need to attache to a 2008 server

    Just log files? What about the data files? You can't recreate a database from just the log files.

    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 4, 2011 at 1:22 pm

    #1363930

  • RE: Estimate transaction log backup size

    rafa.aborges (8/4/2011)

    Got an interesting information from a friend of mine.

    He said that in 16 hours, it generated 29 GB of transaction log backup file and on the DBCC SQLPERF (LOGSPACE)...

    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 4, 2011 at 1:22 pm

    #1363927

  • RE: Using a copy of a backup

    You can change the name of the database in the attach dialogue. It's just a default. Same with the default of the log file. Change it to point to 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

    August 4, 2011 at 1:20 pm

    #1363925

  • RE: sqlserver 2005 died have database on usb drive need to attache to a 2008 server

    Do you have backups? Data and log files?

    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 4, 2011 at 12:56 pm

    #1363908

  • RE: Using a copy of a backup

    CREATE DATABASE ...

    FOR ATTACH

    Just one problem though - copies of the mdf and ldf are NOT backups. Unless your backup tool interfaced with SQL and quiesced the database while 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

    August 4, 2011 at 12:56 pm

    #1363907

  • RE: If statement within a Where Clause

    Beulah Kingsly (8/4/2011)

    If you just want to check for null, you can use the following:

    Select * from TableNameWhere Firstname = ISNULL(@Firstname, FirstName)

    and Surname = IsNull(@Surname, SurName) and EyeColor = ISNULL(@EyeColor,...

    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 4, 2011 at 12:49 pm

    #1363900

  • RE: If statement within a Where Clause

    Philip Yale-193937 (8/4/2011)

    IF @arg1 IS NULL

    select * from mytable

    ELSE

    select * from mytable

    where mytable.mycolumn = @arg1

    may not be as exciting for a...

    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 4, 2011 at 12:47 pm

    #1363899

  • RE: Estimate transaction log backup size

    rafa.aborges (8/4/2011)

    Thank you, I already got this information, but how accurate is this? There are logfile with 900 MB, so the size of the backup will be 900 MB?

    Thanks

    It's 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

    August 4, 2011 at 12:44 pm

    #1363898

  • RE: Database--Suspect mode question

    Imran Nadeem (8/4/2011)

    Hi

    Could be various reasons; mostly hardware failure or deleted ldf's

    A deleted log file (or deleted mdf or ndf) results in a state of RECOVERY_PENDING, not suspect.

    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 4, 2011 at 11:04 am

    #1363831

  • RE: Database--Suspect mode question

    It's caused when SQL either fails to complete a transaction rollback due to corruption or when it start but can't complete crash recovery, usually due to the same.

    Fix is restore...

    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 4, 2011 at 11:01 am

    #1363828

  • RE: MERGE statement to include new column that is an identity column. Don't know how to populate.

    It's not going to be an integer column. They return arithmetic overflow errors, not 'string or binary data...'.

    It's a string column (varchar, nvarchar) or binary (varbinary)

    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 4, 2011 at 11:00 am

    #1363826

  • RE: Are the posted questions getting worse?

    GSquared (8/4/2011)

    GilaMonster (8/3/2011)

    Tom.Thomson (8/3/2011)

    which stopped happening 11 years ago) because US immigration control has deteriorated to the point where no-one in his right mind wants to travel to the USA...

    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 4, 2011 at 10:45 am

    #1363819

  • RE: SQL Server 2010

    river1 (8/4/2011)

    Did Microsoft allready told when it will release the sql denali ?

    No.

    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 4, 2011 at 10:11 am

    #1363790

Viewing 15 posts - 24,451 through 24,465 (of 49,552 total)