Forum Replies Created

Viewing 15 posts - 45,526 through 45,540 (of 49,552 total)

  • RE: Restoring .dat file into SQL server 2005

    .dat?

    That's not a standard SQL file exention. Is it a backup? How did you ceate the .dat file?

    Also, what have you tried and what have the results been?

    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

    July 22, 2008 at 6:42 am

    #846359

  • RE: installing sql server

    Not sure about SQL 2000. Enterprise edition won't, standard edition won't. Personal edition should.

    SQL 2005, only Developer and Express will install on XP Home and you need to be on...

    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

    July 22, 2008 at 6:30 am

    #846355

  • RE: Suggestion on Updating Statistics

    Grant Fritchey (7/22/2008)

    However, some tables statistics get out of date despite the automatic updates. So we update them manually, on most systems once a week or less, during off-hours, on...

    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

    July 22, 2008 at 6:25 am

    #846350

  • RE: Regarding extended stored procedure.

    Please give more info about what you're trying and what permission level various users have.

    Is the owner of that proc a sysadmn? If not, that particular execute as is useless....

    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

    July 22, 2008 at 6:08 am

    #846330

  • RE: Sudden performance issues

    sharon.bender (7/22/2008)

    Since the users refresh manually via a button in our app in order to ensure they are looking at fresh data , it's no problem showing them a snapshot.

    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

    July 22, 2008 at 6:06 am

    #846327

  • RE: very large complex queries

    No. The max number of tables in a query n SQL 2005 is 256.

    My I suggest you break the query down, create temp tables to store interim results then join...

    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

    July 22, 2008 at 12:56 am

    #846188

  • RE: Idle Time, Lock and Log

    What's wrong with the one Jack gave you in the other thead?

    Please reply there. Multiple threads just waste people's time.

    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

    July 22, 2008 at 12:54 am

    #846185

  • RE: Create Statistics. Why do we need it?

    Sandy (7/22/2008)

    if you believe it or not, I just changed the * to 'x' in select statements, its changed from index scan to index seek, i got surprised, why query...

    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

    July 22, 2008 at 12:47 am

    #846182

  • RE: Idle Time, Lock and Log

    No need to ask this again. There are already a number of answers to your older post.

    Duplicate thread. No replies to this please. Direct replies to the older thread at:

    http://www.sqlservercentral.com/Forums/FindPost537514.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

    July 22, 2008 at 12:43 am

    #846179

  • RE: Handling Tempdb space full situtation?

    rames.net (7/21/2008)

    reply with more than 2 diff answers?

    Why?

    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

    July 22, 2008 at 12:40 am

    #846178

  • RE: Backing up database larger than 50GB

    Hae you consided backing up to disk then copying the backup file across the network?

    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

    July 22, 2008 at 12:36 am

    #846177

  • RE: Create Statistics. Why do we need it?

    Probably not much. You'll still get a clustered index scan (cause there's no other way to get those rows), the optimiser will just know more accuratly how many rows will...

    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

    July 22, 2008 at 12:35 am

    #846175

  • RE: Sudden performance issues

    The problem is that there are no absolute hard and fast rules for indexing. It depends on the queries been run and the data.

    Could you post some sample code, 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

    July 22, 2008 at 12:28 am

    #846173

  • RE: Parallel Processing Query in Sql Server 2008

    Michael Earl (7/21/2008)

    From the CLR, you can do this, but I think you have to run it as unsafe to create a new thread. Also, the context connection is...

    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

    July 22, 2008 at 12:23 am

    #846171

  • RE: Create Statistics. Why do we need it?

    I'm trying to figure out what you were trying to say there.

    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

    July 22, 2008 at 12:16 am

    #846169

Viewing 15 posts - 45,526 through 45,540 (of 49,552 total)