Forum Replies Created

Viewing 15 posts - 39,991 through 40,005 (of 49,552 total)

  • RE: How to write this SELECT better

    Thang.Nguyen10 (4/3/2009)

    Sorry guys, I was in the meeting until now. Here is the implicated tables relationship diagram. Is that enough or you need more information on table definition...

    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 3, 2009 at 1:25 pm

    #971814

  • RE: need help with consistent database corruption

    In 99% of cases, corruption (especially recurring corruption) is a result of a problem with the IO subsystem. It may be faulty drivers, it may be faulty SAN controllers, 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 3, 2009 at 12:40 pm

    #971780

  • RE: How to write this SELECT better

    J-F Bergeron (4/3/2009)

    You really should post the execution plan as a zipped file, it will help see what is happening with your query, and give us a hint at where...

    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 3, 2009 at 12:28 pm

    #971769

  • RE: Are the posted questions getting worse?

    Gaby Abed (4/3/2009)

    BTW, Congrats Gail on your new MVP status.

    Thanks, but it's not particularly new. I was awarded last year July. (http://www.sqlservercentral.com/articles/SQLServerCentral/63590/)

    Grant's the new kid on the block this month...

    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 3, 2009 at 12:27 pm

    #971768

  • RE: How to write this SELECT better

    Christopher Stobbs (4/3/2009)

    WHERE

    /*

    isnull(FIRSTNAME,'') like '%%'

    AND isnull(MIDDLEINITIAL,'') like '%%'

    AND isnull(LASTNAME,'') like '%%'

    AND isnull(EMAIL,'') like '%%'

    */

    This can't be removed, at least until we know why it's there 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

    April 3, 2009 at 11:25 am

    #971734

  • RE: ADDING COLUMNS VALUES!

    josephptran2002 (4/3/2009)

    This is not an issue at the front end problem, if you don't know how to solve it please please don't misguide people to different direction. I solved...

    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 3, 2009 at 8:59 am

    #971641

  • RE: SQl server gets Restarted when i run the DBCC Check table command

    Strange. No stack dumps? (.mdmp files in the SQL log directory)

    What happens if you run a full checkDB rather than the individual check tables?

    DBCC CHECKDB (< Database Name > )...

    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 3, 2009 at 8:57 am

    #971640

  • RE: How to add multiple columns from different tables into one column of new table

    josephptran2002 (4/3/2009)

    Some people in here, they are here to show off and intimidate new developer. Not try to help them out and misguide others to different issues.

    Want to name...

    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 3, 2009 at 8:56 am

    #971639

  • RE: How to write this SELECT better

    Looking at the nicely cleaned up version posted by Chris (Thanks Doc) part of your problem is fairly easily apparent.

    You have a cross join in there. The users and the...

    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 3, 2009 at 8:22 am

    #971601

  • RE: HIGH CPU activity last 4 days!!!

    What changed 4 days ago? This kind of thing doesn't just happen, something changed.

    What you're probably going to have to do is find the worst performing queries and tune them....

    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 3, 2009 at 7:45 am

    #971557

  • RE: How to write this SELECT better

    Is it blocked by some other process?

    Can you post table definitions, index definitions, aprox row counts and the execution plan, saved as a .sqlplan file, zipped and attached?

    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 3, 2009 at 7:42 am

    #971549

  • RE: Are the posted questions getting worse?

    Chris Morris (4/3/2009)

    No need, Barry - somehow in my misspent youth I managed to "satisfy the requirements" for a PhD. GF bullies me to use the title.

    So we need 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 3, 2009 at 7:38 am

    #971546

  • RE: How to stop automatic date entering in row

    josephptran2002 (4/3/2009)

    But I don't know how to post the table with sample data in this forum. That why I am asking you to show me how?

    I just showed 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

    April 3, 2009 at 7:36 am

    #971544

  • RE: How to stop automatic date entering in row

    I don't understand what you're struggling with.

    To post a sample table, paste the CREATE table statement into the edit window, like this:

    CREATE TABLE [dbo].[LargeTable](

    [ID] [int] NULL,

    [SomeString] [char](6) NULL,

    [RandomDate] [datetime] NULL,

    [Big]...

    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 3, 2009 at 3:12 am

    #971367

  • RE: Want to close the inactive connections in sleeping mode (SE)

    Sleeping just means not currently running queries. While you can kill them, doing so may well cause problems for the applications if the assume that the connection will remain open.

    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

    April 3, 2009 at 2:54 am

    #971360

Viewing 15 posts - 39,991 through 40,005 (of 49,552 total)