Forum Replies Created

Viewing 15 posts - 38,341 through 38,355 (of 49,552 total)

  • RE: MVP vs MCA

    GSquared (6/18/2009)

    As to which will be in first place, it'll depend on how fast they run. If, for example, I were an MCA (I'm not), and Gail were an...

    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

    June 18, 2009 at 8:33 am

    #1011804

  • RE: Filtered indexes and statistics

    Any findings/conclusions from testing?

    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

    June 18, 2009 at 8:29 am

    #1011800

  • RE: grouping results for stats

    For the table definitions, you can generate them from Management studio. Open object explorer, connect to the server, expand out the tree until you get to the tables, right click...

    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

    June 18, 2009 at 8:28 am

    #1011797

  • RE: MVP vs MCA

    Dugi (6/18/2009)

    Ha, seems you are more stupid than Q, so it is hard for you to understand!

    Insulting him is uncalled for.

    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

    June 18, 2009 at 8:25 am

    #1011795

  • RE: grouping results for stats

    What is it you don't understand?

    I can't really help you out, because I'm not sure what it is that you want exactly. That's why I'm asking for sample data and...

    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

    June 18, 2009 at 7:11 am

    #1011714

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/17/2009)

    RBarryYoung (6/17/2009)

    Jeff Moden (6/17/2009)

    ...All they really need to do is make SUM() OVER work according to ANSI standards (or so I've heard). Of course, that particular documented...

    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

    June 18, 2009 at 6:41 am

    #1011690

  • RE: ISQLW Replacement

    Have you looked at Toad? It's 3rd party and not free, but I've heard good things about it. Other option if you still have 2000 disk lying around is 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

    June 18, 2009 at 6:23 am

    #1011675

  • RE: select max(sal) of employee

    SELECT TOP 1 Employee.*

    FROM Employee inner join salary on employee.empid = salary.empid

    Order by Salary DESC

    Test it out and see if it's better or worse than the one that you have.

    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

    June 18, 2009 at 6:17 am

    #1011672

  • RE: Transaction log not shrinking after Maintenance Task

    jordonpilling (6/18/2009)

    Now, I have a weekly Index rebuild task which may be bloating the log file considerably as you say. What I will do then is, alter my Weekly Rebuild...

    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

    June 18, 2009 at 6:13 am

    #1011670

  • RE: Get Indexes associated with an SQL Query

    You can have a look at a query's execution plan. It'll show what indexes were used on that execution.

    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

    June 18, 2009 at 5:54 am

    #1011655

  • RE: Transaction log not shrinking after Maintenance Task

    The log files won't shrink. Backup log just makes the space inside reusable, it doesn't reduce the size of the file.

    Personally, I would leave the file that big. If it's...

    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

    June 18, 2009 at 5:46 am

    #1011651

  • RE: ISQLW Replacement

    Oh, sorry. I misread. ISQLW is Query Analyser. It's ISQL that SQLCMD's a replacement for.

    I'm curious why management studio's not acceptable. You can always open multiple copies of it if...

    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

    June 18, 2009 at 5:45 am

    #1011650

  • RE: MVP vs MCA

    Dugi (6/18/2009)

    And your vote is ...?

    Neither. As I said in the other thread. Apples and grapefruit.

    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

    June 18, 2009 at 5:43 am

    #1011649

  • RE: Transaction log not shrinking after Maintenance Task

    Are you sure the log backups are running? Check that someone hasn't added the WITH NO_TRUNCATE to the backup log statement.

    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

    June 18, 2009 at 5:16 am

    #1011633

  • RE: MVP vs MCA

    Also posted here - http://www.sqlservercentral.com/Forums/Topic737277-61-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

    June 18, 2009 at 5:14 am

    #1011632

Viewing 15 posts - 38,341 through 38,355 (of 49,552 total)