Forum Replies Created

Viewing 15 posts - 39,166 through 39,180 (of 49,552 total)

  • RE: Need help--very urgent..

    Please run the following and post all the results here.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/

    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

    May 12, 2009 at 1:36 am

    #992671

  • RE: Data error (cyclic redundancy check) failed. with 24 consistency errors

    RPSql (5/11/2009)

    Here's issue. I am not able to backup that corrupted database. This is the error it gives...

    BackupIoRequest::WaitForIoCompletion: read failure on backup device 'E:\Data\abc.mdf'. Operating system error 23(Data error (cyclic...

    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

    May 12, 2009 at 1:36 am

    #992670

  • RE: disk space issue due to .ldf file.

    Please read through this - Managing Transaction Logs[/url]

    If you are backing it up and it's still growing too much, back it up more often.

    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

    May 12, 2009 at 1:32 am

    #992668

  • RE: SQLMAINT Running Too Long! (SQL 2005)

    Paul Randal (5/10/2009)

    [Edit: thought I deleted this post right after I posted it]

    Delete doesn't do anything anymore. Couple issues with people posting insults and then deleting the posts after others...

    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

    May 11, 2009 at 3:46 pm

    #992511

  • RE: Trying to set up a profiler trace programatically

    Is the setting of the status succeeding? It may fail without throwing an error. Check the return code, is it 0?

    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

    May 11, 2009 at 2:28 pm

    #992452

  • RE: Temp Explanation required

    Table could have been created in a parent procedure. This, for eg, will work

    CREATE PROCEDURE OuterProc

    AS

    CREATE TABLE #Temp (id INT)

    INSERT INTO #Temp values (1)

    EXEC InnerProc

    GO

    CREATE PROC...

    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

    May 11, 2009 at 2:27 pm

    #992450

  • RE: Remote Connection to SSAS

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic714417-391-1.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

    May 11, 2009 at 2:25 pm

    #992448

  • RE: Case Statement Within TSQL

    Please post table definitions, sample data and desired output. I'm not 100% sure I follow what you want. Read this to see the best way to post this to get...

    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

    May 11, 2009 at 2:23 pm

    #992441

  • RE: Fatal error involving a specific table

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/ The fixes, if any, depends on the results of that command. I prefer not to speculate ahead of time.

    It may not 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

    May 11, 2009 at 2:12 pm

    #992434

  • RE: Checking Up on Developers

    If you want a rant - http://sqlinthewild.co.za/index.php/2009/04/17/developers-vs-dbas/

    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

    May 11, 2009 at 2:09 pm

    #992430

  • RE: Are the posted questions getting worse?

    Gaby Abed (5/11/2009)

    Ahhh...those were the days, I actually had an Enterprise technical manual and briefly had in my posession the Klingon/English dictionary.

    But not anymore... (<-- he adds hastily) 😀

    I...

    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

    May 11, 2009 at 2:08 pm

    #992428

  • RE: How Do You Find a DBA?

    Steve Jones - Editor (5/11/2009)

    hey, just hire a monkey, give him a macro that gets to the forums here 🙂

    As long as his salary gets spread among the people who...

    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

    May 11, 2009 at 2:06 pm

    #992425

  • RE: Trying to set up a profiler trace programatically

    Dean Jones (5/11/2009)

    Also, I thought it was the other way around according to MS

    To remove the trace definition you need to set the status to 0 (stopped) and then set...

    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

    May 11, 2009 at 2:02 pm

    #992423

  • RE: Trying to set up a profiler trace programatically

    Dean Jones (5/11/2009)

    The value of the trace file is constantly at 0kb even though there are queries running on the system.

    The trace file only gets populated if I restart 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

    May 11, 2009 at 10:25 am

    #992294

  • RE: INSERTS - (Full recovery model ; Bulk load recovery model)

    Bulk logged recovery just allows some operations (not many) to be minimally logged. The details are in Books Online and there are a lot of details. BULK INSERT, bcp, might...

    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

    May 11, 2009 at 10:10 am

    #992279

Viewing 15 posts - 39,166 through 39,180 (of 49,552 total)