Forum Replies Created

Viewing 15 posts - 38,161 through 38,175 (of 49,552 total)

  • RE: To get a query

    Do you want to see the IDs in table 1 that aren't in table2?

    If so, this will work

    -- same sample tables as ARUN SAS created

    select a.ID,a.Name

    from #TableA a LEFT OUTER...

    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

    June 26, 2009 at 1:50 am

    #1015820

  • RE: Can I install sql server 2000 on Vista home edition

    No. The minimum version of SQL that will run on Vista is 2005 SP2

    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

    June 26, 2009 at 1:48 am

    #1015818

  • RE: Failed BackUp

    Jeffrey Williams (6/25/2009)

    I would make sure that Backup Exec is not running a step to truncate the log or switch the recover model. If it is doing either of...

    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

    June 26, 2009 at 1:44 am

    #1015815

  • RE: printing 1 to 100 in SQL Server as a batch....

    Peso (6/26/2009)

    According to OP, he wants the numbers PRINTED, because they then are stored in the log file.

    I considered that, but seeing as one of his initial examples just had...

    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

    June 26, 2009 at 1:40 am

    #1015814

  • RE: Problem with Commit

    You need a rollback in the error handling, otherwise the transaction remains open and uncommitted if either GOTO runs.. Either like this:

    BEGIN TRANSACTION

    SELECT FROM TABLE1

    UPDATE TABLE2

    IF ERROR GOTO ERRORHANDLER

    SELECT FROM...

    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

    June 25, 2009 at 4:12 pm

    #1015679

  • RE: Database stuck in single user mode

    In the management studio login dialog, click on Options (bottom right). That will take you to another dialog where you can change the default database. Pick master.

    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

    June 25, 2009 at 3:32 pm

    #1015661

  • RE: Database stuck in single user mode

    jimmie.roberts (6/25/2009)

    Thanks for the quick reply. But the problem still is I cannot login to the SQL db at all because it's in Single-user mode, so how can 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

    June 25, 2009 at 3:07 pm

    #1015643

  • RE: inserts not working when trigger is turned on

    Does com_SL have an identity column? @@Identity returns the last identity value assigned, so if the trigger inserts into a table with an identity, it'll be that identity value 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

    June 25, 2009 at 3:01 pm

    #1015639

  • RE: Altering tempdb to have multiple files

    Please note, 5 year old 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

    June 25, 2009 at 2:58 pm

    #1015629

  • RE: Making Demands

    Fresh-brewed coffee on demand, high-speed internet access and to please be left alone.

    Last year at TechEd South Africa, the MVP lead ran a 'hunt the MVP contest' where there were...

    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

    June 25, 2009 at 2:54 pm

    #1015626

  • RE: Break up SQL Statement into smaller queries

    And since this is a performance problem, please have a look at this article. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    June 25, 2009 at 2:44 pm

    #1015615

  • RE: Database stuck in single user mode

    sysprocesses is a server-level view, it's not database-specific. It returns all of the sessions connected to the server and, as one of the columns, has the id of the 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

    June 25, 2009 at 2:40 pm

    #1015613

  • RE: Database stuck in single user mode

    Query sysprocesses and see what connection is connected to that 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

    June 25, 2009 at 2:24 pm

    #1015601

  • RE: Failed BackUp

    Tom Breit (6/25/2009)

    I guess I was not explicit. The Backup Exec backup job was NOT called by the Maintenance Plan, BE runs on a different server, and does a 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

    June 25, 2009 at 2:20 pm

    #1015598

  • RE: Trusting Online

    Lynn Pettis (6/25/2009)

    GilaMonster (6/25/2009)

    Gaby Abed (6/25/2009)

    I can only imagine the discussions that Paul and his wife, Kimberly Tripp[/url], have when they catch each other's mistakes, rare as they may be....

    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

    June 25, 2009 at 12:36 pm

    #1015544

Viewing 15 posts - 38,161 through 38,175 (of 49,552 total)