Forum Replies Created

Viewing 15 posts - 32,041 through 32,055 (of 49,552 total)

  • RE: SQL Table Insert rate?

    virender.singh (7/2/2010)

    @paul-2 : I will cheer for newzeland during next india-newzeland battle;-)

    Cheer for South Africa next time we play India! We're more likely to win. 😉 :hehe:

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

    #1188063

  • RE: When this SQL error?

    Don't understand your question. i have a question for you though. Why are you using a cursor?

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

    #1188062

  • RE: Backup restore

    sachinsoni84 (7/2/2010)

    one more thng wanna knw, if a stored procedure has 50 Tsql statment and is it is suddenly showing slow performance how wud i trouble shoot n tune it??

    Please...

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

    #1188050

  • RE: Backup restore

    sachinsoni84 (7/2/2010)

    IS it possible??

    Yes. Full backups do not truncate the transaction log.

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

    #1188047

  • RE: Check Statement aborted. Database contains deferred transactions.

    Enterprise edition has a feature called fast recovery. It means that, after an unexpected shutdown, the database will come online after phase 2 of the restart recovery has completed, instead...

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

    #1188040

  • RE: Check Statement aborted. Database contains deferred transactions.

    What's the state of the database? (query sys.databases)

    What's the exact version (patch, CU and hotfix) and edition of SQL? (select @@version)

    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 2, 2010 at 1:19 am

    #1188027

  • RE: Database mirroring

    alokmishra0 (7/2/2010)

    For enabling mirroring in SQLserver 2005 SP2 ,we need to add trace flan in startup option (try this -t(1400)),then restart the server u ll see mirroring happens.

    You do...

    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 2, 2010 at 12:59 am

    #1188025

  • RE: Is there a Do While loop?

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 1, 2010 at 3:15 pm

    #1187932

  • RE: SQL Server 2005 backup file

    laddu4700 (7/1/2010)

    So you want to update all tables which has user data?

    Yup. You'll only have to write the script once, besides you should be able to use the system...

    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 1, 2010 at 3:07 pm

    #1187928

  • RE: SQL Server 2005 backup file

    Restore it, do the necessary changes, take another 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

    July 1, 2010 at 2:56 pm

    #1187920

  • RE: copying a system table

    You can't insert into sys.types. Modifications to the system tables aren't allowed on SQL 2005+. Besides, sys.types is a view, not a table.

    I would suggest select both into a user...

    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 1, 2010 at 2:41 pm

    #1187914

  • RE: Are the posted questions getting worse?

    Jack Corbett (7/1/2010)

    Steve Jones - Editor (7/1/2010)

    Congrats to Gail and the other MVPs awarded today.

    Let me add my congrats as well Gail.

    Thanks. Mail came in early this year,...

    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 1, 2010 at 2:35 pm

    #1187909

  • RE: Are the posted questions getting worse?

    I should bloody hope that a test with 1000 rows returns in under a second. It requires a really bad query to process 1000 rows in more than 1 sec.

    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 1, 2010 at 2:30 pm

    #1187905

  • RE: I really need some recommendations for this query

    Table definitions?

    Index definitions?

    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 1, 2010 at 1:55 pm

    #1187888

  • RE: DMV access to non-admin account

    What I was trying (badly) to say is that you would still need the view server state or view database state, you can't grant a permission to avoid the need...

    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 1, 2010 at 1:52 pm

    #1187886

Viewing 15 posts - 32,041 through 32,055 (of 49,552 total)