Forum Replies Created

Viewing 15 posts - 24,181 through 24,195 (of 49,552 total)

  • RE: Tricky Questions

    J Thaddeus Klopcic (8/12/2011)

    Dude63 (8/12/2011)

    One of toughest situations came when I was asked what a particular error code was in Sybase. I tried the usual response "I would refer...

    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 12, 2011 at 12:09 pm

    #1368141

  • RE: DTS Packegs migration

    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/Topic1159404-1549-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 12, 2011 at 11:27 am

    #1368124

  • RE: resta value from column to column

    Can you explain a lot more what you're after? Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 12, 2011 at 11:24 am

    #1368122

  • RE: How do I get an entry level job with a cert?

    SQL Kidd (8/12/2011)

    I just want an extremely basic job that I can get some hands on experience in. I don't care if it's the most rudimentary job, as long...

    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 12, 2011 at 11:23 am

    #1368119

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (8/12/2011)

    Steve think you should add a third title. "How I Manage My Time to do all the Chores I want/have to do" Might be considered less 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 12, 2011 at 10:16 am

    #1368073

  • RE: Does SQL Server issue when we shut down windows/SQL Server ?

    Say there's been an update running for 5 hours and someone initiates a shutdown. Since that hasn't committed, SQL would have to roll it back. A rollback typically takes longer...

    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 12, 2011 at 9:38 am

    #1368022

  • RE: Error with "Withevents"

    That ASP.Net? You may get better answers on an ASP.Net forum. Try the ones at Microsoft.

    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 12, 2011 at 9:18 am

    #1368006

  • RE: Using Variables increases Scans and Logical Reads

    http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-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 12, 2011 at 8:10 am

    #1367948

  • RE: Transaction Log Fills Up?

    Please read through this - Managing Transaction Logs[/url] and this http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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 12, 2011 at 8:09 am

    #1367945

  • RE: Simple? Deadlock in SQL Server 9.0

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    DBCC TRACEON(1222,-1)

    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 12, 2011 at 8:09 am

    #1367944

  • RE: How can I take a FULL Backup of a Log Shipping Secondary Database in Standby/Read-Only Mode???

    Via the full/diff perhaps? It's possible for corruption to get into the log and hence into the log backup, but it requires bulk-logged recovery and an odd chain of events.

    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 12, 2011 at 5:39 am

    #1367831

  • RE: Tricky Questions

    Rutulian (8/12/2011)

    One of the more fun interviews I have had:

    You are standing on the bank of the Thames.

    How can you find out the flow rate, assuming the internet doesn't exist?

    That'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

    August 12, 2011 at 5:07 am

    #1367813

  • RE: How can I take a FULL Backup of a Log Shipping Secondary Database in Standby/Read-Only Mode???

    chris.mcgowan (8/12/2011)

    The only thing i would say make sure of is that you verify your backups. If you get corruption on one of your database on your primary server...

    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 12, 2011 at 5:05 am

    #1367812

  • RE: "Normal" tables vs local temporary (i.e. #) tables

    Pre-size it based on how big it gets in test runs. Sensible autogrow settings for the size (eg don't have a 10GB file growing in 2MB increments). Files on 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

    August 12, 2011 at 5:02 am

    #1367810

  • RE: "Normal" tables vs local temporary (i.e. #) tables

    Indexes on your temp tables?

    Optimised TempDB setup?

    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 12, 2011 at 4:52 am

    #1367804

Viewing 15 posts - 24,181 through 24,195 (of 49,552 total)