Forum Replies Created

Viewing 15 posts - 39,601 through 39,615 (of 49,552 total)

  • RE: Missing data restore

    David O'Reilly (4/21/2009)

    Looking again at the MSDB database, there was a full database backup created this morning. How do i found out where these backups are?

    This morning's not going 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

    April 21, 2009 at 5:48 am

    #981338

  • RE: Regarding Query Optimisation

    mithun.gite (4/21/2009)

    Can any one give me a link for Query Optimization, using that i can start optimizing my queries?

    I can suggest some books.

    Inside SQL Server 2005: Query Tuning and Optimisation

    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

    April 21, 2009 at 5:30 am

    #981327

  • RE: Splitting varchar fields into separate nonclustered index fields

    brd123 (4/21/2009)

    (what the heck is wrong with this forum..this is the 3rd time i have tried to post this)

    Seeing as it's posted 3 times, I'd say absolutely nothing.... 😀

    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

    April 21, 2009 at 5:28 am

    #981326

  • RE: Missing data restore

    No backup = no data. Simple as that. There is no way you're going to restore data lost several days ago if you have no backup.

    Are you sure there's absolutely...

    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

    April 21, 2009 at 5:26 am

    #981325

  • RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

    TECHBABU (4/21/2009)

    - Check the disk space where the .mdf .ndf or ldf files are located.

    - If the disk space is full due .ldf

    detach the database and add new...

    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

    April 21, 2009 at 5:21 am

    #981322

  • RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

    What does the SQL error log say? There will be a much more detailed error there. Please check the error log and post any errors relating to database Common.

    This 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

    April 21, 2009 at 5:19 am

    #981319

  • RE: Creating Indexes on every Column of a table..

    AShehzad (4/21/2009)

    Also you may analyze the SQL Server recommendations about missing indexes http://blog.dbdigger.com/2009/04/get-information-about-missing-indexes.html

    Just bear in mind that the missing index info is a suggestion. It's not always the best index,...

    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

    April 21, 2009 at 4:57 am

    #981307

  • RE: SP Execution Error

    Firstly this is a problem

    If Exists(Select Name from tempdb.sys.objects Where Name like '#Export%' and type = 'U')

    Begin

    Drop Table #Export

    End

    That exists will find any instance of that table, even one 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

    April 21, 2009 at 4:57 am

    #981304

  • RE: convert timestamp to varchar

    Helical Johan (9/11/2008)

    hi...

    how can i convert a timestamp field to varchar?

    thanks....

    Why do you need the timestamp column as a varchar? Despite it's name, timestamp has absolutely nothing to do with...

    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

    April 21, 2009 at 4:44 am

    #981295

  • RE: Creating Indexes on every Column of a table..

    Noman Tariq (4/21/2009)

    Do i create seperate 10 indexes on every column? is it a good approach?

    That's only really useful if you have queries that filter on only one column at...

    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

    April 21, 2009 at 4:30 am

    #981291

  • RE: SP Execution Error

    Post the procedure?

    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

    April 21, 2009 at 4:28 am

    #981289

  • RE: want to know unstricted database of sql server

    Technically it's not exactly a bug. The max allowable size for a transaction log file is 2 TB, so unrestricted or not, a log file cannot grow larger than 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

    April 21, 2009 at 4:26 am

    #981288

  • RE: 2008 Compatibility

    What, exactly are you doing to get that error?

    SQL 2008? Why is this posted in the SQL 2000 forums?

    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

    April 21, 2009 at 2:53 am

    #981256

  • RE: Please Help me Very Urgent

    Thanks Paul

    S.saravanan: Out of curiosity, how did you fix it?

    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

    April 21, 2009 at 2:43 am

    #981252

  • RE: Index Fragmentation

    SQL_Quest (4/20/2009)

    index_name avg_fragmentation_in_percent page_count

    eg. CLUSTERED INDEX0.675260896255371 ...

    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

    April 21, 2009 at 2:41 am

    #981251

Viewing 15 posts - 39,601 through 39,615 (of 49,552 total)