Forum Replies Created

Viewing 15 posts - 27,811 through 27,825 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Craig Farrell (2/12/2011)

    I personally always try to look at the timestamps when that happens. I quite often will go through the recent posts and open up the 20 or...

    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

    February 12, 2011 at 1:55 pm

    #1286067

  • RE: dbcc checkdb

    Regularly.

    When someone complains about corruption it's already too late. To recover from corruption without data loss you need to know when it started so that you know what backup...

    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

    February 12, 2011 at 1:39 pm

    #1286064

  • RE: Are the posted questions getting worse?

    george sibbald (2/12/2011)

    And why do people post a reply thats almost a verbatim copy of a previous post? Being proved wrong I can just about take (with embarrasement) but ignored,...

    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

    February 12, 2011 at 1:20 pm

    #1286063

  • RE: how can chage column positions

    Why? Column order has no meaning in SQL. If you want to retrieve the columns in a particular order, specify the order in your select statement.

    To change the order 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

    February 12, 2011 at 4:41 am

    #1286010

  • RE: Top 10 Queries

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    February 12, 2011 at 1:29 am

    #1286001

  • RE: Truncating transaction logs

    Why are you truncating your transaction logs?

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

    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

    February 12, 2011 at 1:26 am

    #1286000

  • RE: Output 1 Record from 12 million records table ?

    Is the query slow? IF not, why are you even worrying?

    The costs are estimates, they can be wrong. Even if they're right, the total cost % of a plan...

    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

    February 12, 2011 at 1:24 am

    #1285999

  • RE: Difference between active-active and active-passive clusters?

    Please post new questions in a new thread. Thank 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

    February 12, 2011 at 1:20 am

    #1285998

  • RE: “SELECT 1? rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”.

    amenjonathan (2/11/2011)

    I also use SELECT NULL.

    Personally if something is faster and there's virtually no complexity difference, I use the faster version. Why waste where there is no need is my...

    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

    February 12, 2011 at 1:20 am

    #1285997

  • RE: “SELECT 1? rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”.

    luckysql.kinda (2/11/2011)

    Cost Analysis Among EXISTS (SELECT 1), EXISTS (SELECT COUNT(1)), EXISTS (SELECT *) AND EXISTS (SELECT TOP 1) should help

    Not really. Firstly there's no cost analysis there, no testing, no...

    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

    February 12, 2011 at 1:17 am

    #1285996

  • RE: Accessing SSRS Reports via Sharepoint from Silverlight...!

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1062776-150-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

    February 11, 2011 at 1:27 pm

    #1285886

  • RE: Return Type from SYS.OBJECTS table

    DB_Newbie2007 (2/11/2011)

    OK, I have an application what requires a value being returned from a SQL query. In this particular case, I am checking for the existence of a table 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

    February 11, 2011 at 10:59 am

    #1285831

  • RE: Unable to truncate sql log file

    Yes, the log would continue to grow. I do suggest at this point that you restart SQL as soon as convenient, then shrink the log down to say half 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

    February 11, 2011 at 10:55 am

    #1285827

  • RE: Unable to truncate sql log file

    24 GB is not necessarily large for a log. How large is the DB? How active is the DB? What's the frequency of your log backups? What's the max space...

    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

    February 11, 2011 at 10:38 am

    #1285813

  • RE: Unable to truncate sql log file

    newbee dba (2/11/2011)

    you want me to stop and start the sql server services

    Not right now, I've asked some others for a second opinion. I just wanted to know if 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

    February 11, 2011 at 9:37 am

    #1285779

Viewing 15 posts - 27,811 through 27,825 (of 49,552 total)