Forum Replies Created

Viewing 15 posts - 24,541 through 24,555 (of 49,552 total)

  • RE: Random timeout occurring

    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

    August 2, 2011 at 8:37 am

    #1362214

  • RE: Are the posted questions getting worse?

    SQLkiwi (8/2/2011)

    GilaMonster (8/2/2011)

    I also pay around R400/month for my cellphone...

    I have a prepay phone. It has a black-and-white screen, can make and receive calls (apparently) and also send 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

    August 2, 2011 at 8:34 am

    #1362211

  • RE: Binary Tree Counting Left and Right Node..

    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/Topic1152220-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

    August 2, 2011 at 8:24 am

    #1362196

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (8/2/2011)

    75MB??? I get more e-mails than that in a week!

    That's just my phone's data allowance. Email is done on PC and that's via the ADSL with 10GB allowance....

    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

    August 2, 2011 at 8:20 am

    #1362192

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/2/2011)

    Gianluca Sartori (8/2/2011)

    I pay 42 Euros / month for my ADSL Internet line, no telephone, ADSL only.

    I pay about the same. But I got a *censored* download limit...

    R600/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

    August 2, 2011 at 8:17 am

    #1362189

  • RE: Adding/Removing Columns

    calvo (8/2/2011)

    ALTER TABLE test.Tmp_test SET (LOCK_ESCALATION = TABLE)

    Why? Table is the default for lock escalation.

    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

    August 2, 2011 at 6:17 am

    #1362083

  • RE: How can we get the SQL server Intelligence

    Buy SQLPrompt from Redgate.

    SQL 2008 has intellisense only when working against a SQL 2008 server, but it's very bad a lot of the time.

    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

    August 2, 2011 at 6:01 am

    #1362070

  • RE: Are the posted questions getting worse?

    BrainDonor (8/2/2011)

    I was seconded to a company in Zimbabwe many years ago for 6 months.

    Before or after around 1997?

    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

    August 2, 2011 at 4:10 am

    #1362025

  • RE: MCTS Cert - Implementing and maintaining a 2008 SQL SERVER

    It doesn't. Express is just the core database instance. No SSRS, no SSAS, no SSIS.

    I would like to get MCTS certified for SQL SERVER and start actively looking for "entry...

    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

    August 2, 2011 at 3:40 am

    #1362011

  • RE: Speeding Up Database Access Part 3 - Fixing Missing Indexes

    Some corrections...

    The article implies (thought doesn't outright say) that the rows in a table are physically sorted by the clustered index. This is not necessarily true, the order that 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

    August 2, 2011 at 3:34 am

    #1362007

  • RE: using dbcc commands

    bipan (8/2/2011)

    Better to use dbcc command on table wise rather than executing it on whole databases.It may lead space crunch if you dont hv enough in your machine.

    And which of...

    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

    August 2, 2011 at 3:12 am

    #1362000

  • RE: Error: 18456, Severity: 14, State: 16. The log for database 'PICAPROD' is not available.

    subbaraju.jay (8/1/2011)

    If anyone knows how to resolve this issue. I checked with system admin they said that disk side no issue. I checked dbcc checkdb command also. no error 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

    August 2, 2011 at 3:06 am

    #1361996

  • RE: Error: 18456, Severity: 14, State: 16. The log for database 'PICAPROD' is not available.

    Sachin Nandanwar (8/2/2011)

    Try detaching and then attaching the database.

    No. Please no. Worst thing possible.

    Unless by some miraculous chance the database was cleanly shut it will not reattach. You should never...

    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

    August 2, 2011 at 3:04 am

    #1361994

  • RE: Are the posted questions getting worse?

    Tom.Thomson (8/1/2011)

    I guess whoever provides phones in SA manages to be worse that POTS on installation and much worse than BT on problem fixing - and that's quite an achievement!

    Government-supported...

    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

    August 2, 2011 at 2:59 am

    #1361993

  • RE: Are the posted questions getting worse?

    4 days? That's excellent service.

    Here a telephone fault often takes a few weeks to sort out. I had a fault several years ago where I reported the line as...

    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

    August 1, 2011 at 3:05 pm

    #1361866

Viewing 15 posts - 24,541 through 24,555 (of 49,552 total)