Forum Replies Created

Viewing 15 posts - 19,561 through 19,575 (of 49,552 total)

  • RE: Primary Key: GUID vs. INT

    Eugene Elutin (3/27/2012)

    Nothing wrong with a guid primary key...

    Nothing wrong! But with a real life experience you learn, that it would be much better to stick with INTs or BIGINTs...

    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

    March 27, 2012 at 5:08 am

    #1464871

  • RE: Reduce the store Procedure execution time

    paul.knibbs (3/27/2012)

    Jeff Moden (3/25/2012)

    Jeez... someone was crazy about order. The code that populates the variables has another ORDER BY in it. Lose the ORDER BY in the following...

    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

    March 27, 2012 at 5:06 am

    #1464867

  • RE: Testing Secondary database in Log Shipping

    He's making changes to the secondary. Hence the LSNs won't be in sync after that. I don't read that as asking how to switch log shipping around, just how 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

    March 27, 2012 at 2:45 am

    #1464786

  • RE: Maxdop - Good for few queries - Not so good for rest

    A cost threshold for parallelism of 1 would make just about every query parallel, which is a bad idea. Most people who have opinions on that matter recommend a figure...

    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

    March 27, 2012 at 2:24 am

    #1464780

  • RE: Testing Secondary database in Log Shipping

    Since you're bringing the secondary DB online and making changes, there's no 'go back' after that. Take a full backup from primary, restore on the secondary WITH NORECOVERY and 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

    March 27, 2012 at 2:15 am

    #1464773

  • RE: How to increase performance of a table which is having 16 GB data

    Cool. Sounds like a good plan. If you need advice on specific queries, feel free to post a thread on that specific query. Also maybe look up Grant Frichey's book...

    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

    March 27, 2012 at 1:52 am

    #1464759

  • RE: not getting rid of physical reads

    TheSQLGuru (3/26/2012)

    I have a client with OLD ADO Classic crappy code on SQL 2005 RTM that gets MASSIVE plan cache bloat. I run a job every 30 minutes around...

    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

    March 27, 2012 at 1:51 am

    #1464758

  • RE: not getting rid of physical reads

    Confusing Queries (3/26/2012)

    so, under what circumstances people consider flushing buffers?

    In production just about never, and if it is done it's as an interim workaround while resolving whatever the root problem...

    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

    March 26, 2012 at 4:33 pm

    #1464627

  • RE: Trying to determine if there's anything I should include from the former DBA's backups

  • Third subplan weekly_full_backup has 2 tasks/steps

  • Full backup of all user databases

  • Backup of transactlon logs for all user databases

    • [/li]

    I really don't like having log backups 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

    March 26, 2012 at 3:37 pm

    #1464585

  • RE: Gaining experience with no experience?

    ilanham (3/26/2012)

    I have a predicament: I work as a Windows sysadmin, and I watch over a database server. By that, I mean I make sure it's running, I make sure...

    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

    March 26, 2012 at 2:26 pm

    #1464548

  • RE: How can we extract each query(Statement) in a procedure??

    In T-SQL that would be near-impossible beyond trivial statements. I would suggest a CLR procedure using what's shown here

    http://blogs.msdn.com/b/gertd/archive/2008/08/21/getting-to-the-crown-jewels.aspx (assuming those DLLs can be used within SQLCLR)

    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

    March 26, 2012 at 11:04 am

    #1464434

  • RE: not getting rid of physical reads

    Confusing Queries (3/26/2012)

    since plans are not flushed, we are allocating cache memory to the unused plans?

    Yes, but they'll be removed if they aren't used for a while. Also 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

    March 26, 2012 at 10:55 am

    #1464424

  • RE: How to increase performance of a table which is having 16 GB data

    Write code that can use indexes

    Create indexes to support the queries.

    Not much I can say without more details. These might help

    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

    March 26, 2012 at 10:42 am

    #1464413

  • RE: not getting rid of physical reads

    Robert Davis (3/26/2012)

    TheSQLGuru (3/26/2012)

    1) it is my understanding that if you alter the schema/indexes of a table the plan cache is flushed of plans that hit that object.

    If you modify...

    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

    March 26, 2012 at 10:37 am

    #1464409

  • RE: how to ensure the data is evenly among multiple data files

    It's telling you that all the files must be the same size, so the sizes set by alter database or in the file dialog should be the same for all...

    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

    March 26, 2012 at 8:56 am

    #1464318

Viewing 15 posts - 19,561 through 19,575 (of 49,552 total)