Forum Replies Created

Viewing 15 posts - 39,241 through 39,255 (of 49,552 total)

  • RE: tempdb backup

    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/Topic712281-148-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

    May 7, 2009 at 11:57 am

    #990587

  • RE: Performance implications of writing to tempdb all the time

    Alex Prusakov (5/7/2009)

    Also, never ever use SELECT DISTINCT if you want good performance.

    I wouldn't say never. There are times when it's needed, when you do really need distinct data...

    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

    May 7, 2009 at 11:54 am

    #990584

  • RE: Concat truncates in SQL 2005

    No one's suggesting that you enter IP addresses manually. The Table variable that Lynn and Flo had in there code was a substitite for the real table. To implement their...

    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

    May 7, 2009 at 11:12 am

    #990540

  • RE: Performance implications of writing to tempdb all the time

    Dean Jones (5/7/2009)

    I was just wondering where SQL 2005 could help here in terms of improvements and new features, I do notice that a lot of my stored procedures, pull...

    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

    May 7, 2009 at 11:04 am

    #990532

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/7/2009)

    Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals?...

    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

    May 7, 2009 at 11:02 am

    #990528

  • RE: Finding Page Splits

    Lynn Pettis (5/7/2009)

    You can query the t-log??

    Yup. Undocumented command.

    SELECT * FROM fn_dblog(null, null)

    The two parameters are starting and ending LSNs. Good luck deciphering it. Tran log's not exactly 'readable'

    For SQL...

    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

    May 7, 2009 at 10:05 am

    #990469

  • RE: Chaning the Recover model from full to simple

    Either there's a job that has a command in it to change the recovery model, or someone ran a command to do it directly. SQL won't automatically change recovery models.

    There...

    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

    May 7, 2009 at 9:47 am

    #990448

  • RE: NON-Clustered Indexes on table but no Clustered Indexes

    No formal process.

    If I'm considering the indexes from missing indexes DMV, first I'll make sure there are no partial redundancies within the index recommendations. I'll also make sure that there...

    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

    May 7, 2009 at 9:33 am

    #990432

  • RE: Finding Page Splits

    Dunno if you noticed, but I asked the question almost a year and a half ago.

    What I ended up doing was querying the tran log before each backup, looking 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

    May 7, 2009 at 9:32 am

    #990429

  • RE: integrity checks on very large databases

    CheckDB uses a database snapshot anyway. Running it against a snapshot is not going to make any difference. It doesn't take any locks as it works (and never has), 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

    May 7, 2009 at 9:29 am

    #990427

  • RE: integrity checks on very large databases

    http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Consistency-Checking-Options-for-a-VLDB.aspx

    How often are you running CheckDB at the moment?

    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

    May 7, 2009 at 8:31 am

    #990378

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/7/2009)

    What about good?

    What about evil?

    What about right?

    What about wrong?

    Is there a Vorlon in the building?

    If you do not watch the water fall, the pebbles will never speak.

    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

    May 7, 2009 at 8:25 am

    #990375

  • RE: Stress test IO szstem.

    Google for SQLIOSim. It's an app designed to stress test an IO system with similar IO patterns to what SQL generates.

    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

    May 7, 2009 at 5:43 am

    #990248

  • RE: Are the posted questions getting worse?

    Google must be down again - http://www.sqlservercentral.com/Forums/Topic711884-146-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

    May 7, 2009 at 5:24 am

    #990240

  • RE: Lazy Writer

    Is google down again?

    Ratheesh.K.Nair (5/7/2009)

    Hi Experts,

    What is Lazy writer ?

    http://www.google.com/search?q=SQL+%22Lazy+writer%22

    What are ACID PROPERTIES?Please Explain..

    http://www.google.com/search?q=SQL+ACID

    What happens when we issue a checkpoint? and wat all things triggers a checkpoint?

    http://www.google.com/search?q=SQL+checkpoint

    If you still 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

    May 7, 2009 at 5:23 am

    #990239

Viewing 15 posts - 39,241 through 39,255 (of 49,552 total)