Forum Replies Created

Viewing 15 posts - 32,296 through 32,310 (of 49,552 total)

  • RE: Restore with point in time

    Saravanan_tvr (6/22/2010)

    Am not serious, My problem is unable to understand our Gila replies..

    What part of my replies are unclear?

    If you want to restore to 1 May, you need a backup...

    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 22, 2010 at 5:24 am

    #1183233

  • RE: Database frequently going to suspect Mode

    jamessdba (6/22/2010)

    1)Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical device

    Something's locking the file and preventing 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 22, 2010 at 5:02 am

    #1183224

  • RE: Are the posted questions getting worse?

    Schadenfreude-Mei (6/22/2010)

    I think this one qualifys:

    http://www.sqlservercentral.com/Forums/Topic940758-146-1.aspx

    Seriosly, how do these people get to a point where they are even alowed to look at a live server :crazy:

    That's mild for him.

    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 22, 2010 at 4:58 am

    #1183221

  • RE: Implementing INSERT INTO with condition

    Add

    WHERE NOT EXISTS (<check for matching rows in destination table>)

    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 22, 2010 at 4:56 am

    #1183220

  • RE: INSERT INTO SELECT WITH ORDER BY

    Eugene Elutin (6/22/2010)

    The "quirky update" method is based on the assumption/fact that the simpe query is always retrieves or operates with data in the order of the clustered index by...

    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 22, 2010 at 4:54 am

    #1183219

  • RE: Slow Query Performance (View)

    Can you post the actual execution plan please, rather than the estimated plan

    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 22, 2010 at 4:35 am

    #1183207

  • RE: How to retrieve most recent records inserted in sql server 2005 db log?

    Arjun Sivadasan (6/22/2010)

    @karthik - If you are to create two columns indeed, then don't give a default value for Time_of_Creation, as you want it to be filled only the first...

    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 22, 2010 at 4:31 am

    #1183203

  • RE: How to retrieve most recent records inserted in sql server 2005 db log?

    Arjun Sivadasan (6/22/2010)

    If you have a timestamp, you can query like 'select * from table where timestamp > dateadd(d,-1,getdate())'

    If you're talking about the timestamp data type, it is not 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

    June 22, 2010 at 4:21 am

    #1183196

  • RE: Slow Query Performance (View)

    niteen2009 (6/22/2010)

    Is there any other way to join between these to tables as that joins incurs much cost.

    Joins between properly indexed columns of the same data type are not very...

    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 22, 2010 at 4:17 am

    #1183194

  • RE: Slow Query Performance (View)

    niteen2009 (6/22/2010)

    ya.. we can create unique index on StartIP and EndIP.

    But this will not solve my problem.

    Why not? Have you tested the index and has it not improved...

    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 22, 2010 at 4:07 am

    #1183188

  • RE: Slow Query Performance (View)

    The first thing that you need to do is to fix the data types.

    [startIP] [nvarchar](100) NULL,

    [endIP] [nvarchar](100) NULL,

    ...

    [IPAddress] [varchar](20) NULL,

    ..

    MaskedIPAddress [bigint]

    These columns need the same data types. Pick one data...

    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 22, 2010 at 4:07 am

    #1183187

  • RE: Slow Query Performance (View)

    Are you always querying the entire table? No limitation on portions of the visitors? No where clause?

    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 22, 2010 at 3:06 am

    #1183164

  • RE: Torn page

    Then check out the article I linked 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

    June 22, 2010 at 2:53 am

    #1183151

  • RE: Slow Query Performance (View)

    Table definitions and index definitions as well please.

    How many rows (approx) in the tables?

    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 22, 2010 at 2:53 am

    #1183150

  • RE: Slow Query Performance (View)

    That triangular join you have there (join on >=) is not likely to perform well on large rowcounts. What is it that you're trying to do here?

    How many rows are...

    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 22, 2010 at 2:38 am

    #1183143

Viewing 15 posts - 32,296 through 32,310 (of 49,552 total)