Forum Replies Created

Viewing 15 posts - 43,141 through 43,155 (of 49,552 total)

  • RE: Restore Problem

    I don't think you will be able to restore it with corruption. On the SQL 2000 server, please run the following and post the results.

    DBCC CHECKDB(< Database 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

    November 13, 2008 at 2:02 am

    #897929

  • RE: 70-443 is not a good exam.

    deven.yadav (11/13/2008)

    read this link carefully

    I m sure everyone must be having P4S and Actualtests.

    Its just an correction to the questions appered so far.

    Using braindumps is cheating and can get your...

    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

    November 13, 2008 at 1:57 am

    #897928

  • RE: SQl Statement for Trigger

    The trigger has to go on the table that the insert is been done into. In this case, that'll be on Table_1 in DB1

    The trigger just has to insert 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

    November 13, 2008 at 1:17 am

    #897922

  • RE: Inserted seems to remember values between updates/inserts

    Indeed. With an update, the inserted table contains the rows as they are after the insert and the deleted contains the rows as they were before.

    Sorry, I misread your question...

    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

    November 13, 2008 at 12:56 am

    #897919

  • RE: when i run exec xp_cmdshell 'del "c:\windows\temp\*.*"', got promt for [Y/N]...

    Add the /Q switch to the del command. It puts delete into silent mode so it won't prompt.

    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

    November 13, 2008 at 12:37 am

    #897915

  • RE: Avoid order by to use a sql in a view

    Juergen Gleiss (11/13/2008)

    Ali: your link does not work - please update the working one.

    Try removing the square bracket from the end of the URL

    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

    November 13, 2008 at 12:27 am

    #897911

  • RE: How to optimize join performing table scan

    Robert (11/12/2008)

    I could post it, but it's huge and wouldn't do much good without the whole model.

    Thing is, without seeing the exec plan I can't give you more than vague...

    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

    November 13, 2008 at 12:14 am

    #897909

  • RE: SQL 2000 DB to 2008

    Run it on the SQL 2000 server in the database that you are trying to upgrade.

    The query will always return a result on SQL 2008, as that's one of 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

    November 12, 2008 at 2:17 pm

    #897786

  • RE: SQL 2000 DB to 2008

    What does the query I posted return when run against the original SQL 2000 database?

    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

    November 12, 2008 at 2:10 pm

    #897783

  • RE: Questions about full database backup

    Phil Auer (11/12/2008)

    Thank you very much for the on-point answers.

    1. Is removing the inactive entries on a full backup an option (which I would want to NOT select) in SQL...

    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

    November 12, 2008 at 1:45 pm

    #897765

  • RE: SQL 2000 DB to 2008

    Looks like a conversion problem. If I'm interpreting the error correctly, it's saying that it can't create one of the new system tables because an object with that name already...

    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

    November 12, 2008 at 1:44 pm

    #897764

  • RE: Avoid order by to use a sql in a view

    That is valid, but the order by will not be honoured. Order bys are only honoured by the query processor if they are in the outermost select statement, i.e. 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

    November 12, 2008 at 1:38 pm

    #897761

  • RE: Transaction log filling up - transactional replication issue

    TRACEY (11/12/2008)

    Oh someone changed it to FULL Recovery mode - oh that may do it if your not backing up logs every x minutes.

    That would make the log grow, 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

    November 12, 2008 at 1:20 pm

    #897755

  • RE: Transaction log filling up - transactional replication issue

    Animal Magic (11/12/2008)

    What is happening (and i should have clicked earlier) was one of the statements this app runs is an update with no where clause, every 3 seconds. ...

    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

    November 12, 2008 at 1:19 pm

    #897754

  • RE: Transaction log filling up - transactional replication issue

    Animal Magic (11/12/2008)

    I have a feeling this is what my problem was. the amended table has 6 indexes including the PK clustered index, so the alter table would have...

    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

    November 12, 2008 at 1:17 pm

    #897753

Viewing 15 posts - 43,141 through 43,155 (of 49,552 total)