Forum Replies Created

Viewing 15 posts - 42,361 through 42,375 (of 49,552 total)

  • RE: Login failure

    Not enough information.

    Can you post the message 1 line above that in the error log. The one that reads Error ... Severity .. State ...

    With a login failure, 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

    December 15, 2008 at 1:24 pm

    #912758

  • RE: what is mean by notification services?

    Is google down?

    http://www.microsoft.com/sqlserver/2005/en/us/notification-services.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

    December 15, 2008 at 6:58 am

    #912435

  • RE: Replace trigger due to deadlock - but with what?

    Post the deadlock graph please?

    To get deadlock graph, turn traceflag 1222 on. Deadlock graph will then be written into the error log everytime a deadlock occurs.

    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

    December 15, 2008 at 6:51 am

    #912428

  • RE: How to delete transaction logs without accessing the Database?

    sanjeev_krs2004 (12/15/2008)

    HCan any of you guide me how to delete the transaction logs without accessing the database.

    Never ever delete transaction logs. It's the fastest way to get a corrupt 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

    December 15, 2008 at 6:50 am

    #912427

  • RE: what is difference between restore and recovery?

    Restore is what you do with backups. Take the backup file and turn it back into a database.

    Recovery is something that SQL does every time it brings a database online....

    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

    December 15, 2008 at 4:43 am

    #912375

  • RE: Selecting more recent child record with parent

    Rich Caine (12/10/2008)

    How could I change the sub query above to get the highest DateCreated yet still return Versions.Ref (which I need in the emcompassing join)?

    If you change the subquery...

    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

    December 15, 2008 at 4:33 am

    #912373

  • RE: Taking backup of particular table from the Database

    ps (12/15/2008)

    Even if the database is online; since i'm restoring the primary filegroup, i need to put the database in single_user mode right?

    It's never necessary to put a DB into...

    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

    December 15, 2008 at 4:09 am

    #912365

  • RE: Taking backup of particular table from the Database

    Is the database still online?

    SQL 2000, 2005 or 2008?

    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

    December 15, 2008 at 1:02 am

    #912327

  • RE: Taking backup of particular table from the Database

    ps (12/14/2008)

    You can move those four tables in a different database file. take file/filegroup backup. You'll be able to restore them.

    http://msdn.microsoft.com/en-us/library/ms189906.aspx

    http://msdn.microsoft.com/en-us/library/ms179401.aspx

    You'd still need to backup and restore the primary filegroup...

    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

    December 15, 2008 at 12:25 am

    #912320

  • RE: hi

    ganesha2181 (12/15/2008)

    One of my site have a more than 41,000,00 data. Problem is i want to this data into 41 tables, per table i have a keep 1,000,00 data.

    Why?

    So, how...

    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

    December 15, 2008 at 12:24 am

    #912319

  • RE: which is fast -- where clause or inner joins

    viji (12/14/2008)

    I'm querying on a tera byte storage data. so i want to know which will be faster the where condition or the inner joins for example

    expecting a advice...

    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

    December 15, 2008 at 12:19 am

    #912318

  • RE: How to pass a table to a sql server stored procedure

    ps (12/14/2008)

    Gail, I think he needs to run 2nd SP for each Row.

    I don't think so, seeing as he was asking how to pass a resultset to a stored...

    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

    December 15, 2008 at 12:10 am

    #912316

  • RE: How to pass a table to a sql server stored procedure

    gamaz (12/14/2008)

    Thanks Journeyman for the nice example. One thing is still different from my scenario. That is in the cursor example you have shown the select statement of cursor does...

    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

    December 15, 2008 at 12:02 am

    #912315

  • RE: Converting Varchar Data to Datetime Data

    Nicholas Cain (12/14/2008)

    I am sure that there are far more elegant versions of this that would work with a simple convert, I just couldn't figure any out.

    I don't know about...

    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

    December 14, 2008 at 11:52 am

    #912241

  • RE: How to pass a table to a sql server stored procedure

    ps (12/14/2008)

    You can also use cursors or Loop within the first SP and calling the 2nd SP for each rowset from within the cursor/loop.

    You can, but that's an exceedingly slow...

    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

    December 14, 2008 at 11:44 am

    #912237

Viewing 15 posts - 42,361 through 42,375 (of 49,552 total)