Forum Replies Created

Viewing 15 posts - 36,391 through 36,405 (of 49,552 total)

  • RE: New Code formatting engine rolled out

    Jeffrey Williams-493691 (10/8/2009)

    Edit: interesting, worked on preview - then gets modified as above.

    Yeah, I noticed that earlier.

    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

    October 8, 2009 at 1:32 pm

    #1063695

  • RE: Transaction Log full issue

    stricknyn (10/8/2009)

    Could not allocate space for object 'dbo.CLAIM_DETAIL'.'idx_CLAIM_DETAIL_7' in database 'Claim' because the 'PRIMARY' filegroup is full.

    That's not a log full error. That's saying that the primary data file 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

    October 8, 2009 at 1:23 pm

    #1063692

  • RE: New Code formatting engine rolled out

    That doesn't really help me. I've got a fair few 'templates' that I have set up for quick insert via a firefox plugin. Cutting them to management studio and pasting...

    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

    October 8, 2009 at 1:08 pm

    #1063679

  • RE: database gor corrupted what to do

    Krasavita (10/8/2009)

    Before I run DBCC CHECKDB ({Database Name}) WITH NO_INFOMSGS, ALL_ERRORMSGS. Is this going to cause my webside to go down?

    No, but it may slow things down.

    Make sure you replace...

    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

    October 8, 2009 at 12:34 pm

    #1063665

  • RE: database gor corrupted what to do

    Krasavita (10/8/2009)

    corruption happend at 1256 with messages:... page header is all zeroes

    Error: 0, Severity: 19, State: 0

    Attempt to fetch logical page (1:38) in database 'dbdata' belongs to object '0', not...

    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

    October 8, 2009 at 12:33 pm

    #1063664

  • RE: New Code formatting engine rolled out

    Testing....

    Using an inequality character

    SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

    Using escape codes for inequality

    SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

    Using angle brackets to designate a placeholder

    USE <Database Name>

    Using...

    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

    October 8, 2009 at 12:22 pm

    #1063658

  • RE: Page header is all zero

    Please don't cross post. I'm dealing with your corruption problem in the other thread you started

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

    October 8, 2009 at 12:12 pm

    #1063653

  • RE: database gor corrupted what to do

    Krasavita (10/8/2009)

    yes, I have a clean backup. My last transaction job ran at 12 and corruption happend at 1256

    Did the corruption happen at 12:56 or did you detect it 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

    October 8, 2009 at 12:11 pm

    #1063652

  • RE: database gor corrupted what to do

    First, read this. http://www.sqlservercentral.com/articles/65804/

    Second, run the following code, post the full results here.

    DBCC CHECKDB ({Database Name}) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Do you have a clean backup? One that doesn't have the corruption...

    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

    October 8, 2009 at 11:55 am

    #1063643

  • RE: SQL SERVER PROFILER 2005

    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/Topic800194-360-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

    October 8, 2009 at 11:22 am

    #1063627

  • RE: How I can make look like I expert on SQL Server?

    ItalianOlgi (10/8/2009)

    I am not sayign I will be lazy and just occupy space waiting to lose job! When some problem happen,I will do my best to resolve, find answers in...

    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

    October 8, 2009 at 11:18 am

    #1063625

  • RE: How I can make look like I expert on SQL Server?

    GSquared (10/8/2009)

    And, honestly, it's way more than I'd expect from most people in the US. Our "education" system is so weak that most don't know how to find answers,...

    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

    October 8, 2009 at 10:46 am

    #1063602

  • RE: How I can make look like I expert on SQL Server?

    torpkev (10/8/2009)

    Gail, I love MSDN and forums/blogs..

    got a job for me 😉

    I'm consulting these days. If you'd asked that a year ago, the answer would have been yes. Providing you...

    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

    October 8, 2009 at 9:41 am

    #1063548

  • RE: How I can make look like I expert on SQL Server?

    GSquared (10/8/2009)

    On the other hand, I'd consider it a positive if it started with, "I haven't had to do that, so I'm not sure, but what I'd start with 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

    October 8, 2009 at 9:29 am

    #1063541

  • RE: Table variable in Dynamic SQL

    Al-279884 (10/8/2009)

    that is the table declaration as a parameter, not as a variable within your current session. The idea is that sp_executesql opens up a new session and runs 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

    October 8, 2009 at 9:17 am

    #1063530

Viewing 15 posts - 36,391 through 36,405 (of 49,552 total)