Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 5,841 total)

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

    ganesh.babu-840100 (3/29/2012)

    Try for table partioning. You can send DDL of your table for some more analysis or tips on this.

    This is simply bad advice. There are MANY avenues to...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 30, 2012 at 8:19 am

    #1466961

  • RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

    WRACK (3/28/2012)

    Did not realise that this topic was still going. Well I have something to report. The client has finally appointed a DBA and I shall gladly handover everything I...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 29, 2012 at 9:09 am

    #1466415

  • RE: Primary Key: GUID vs. INT

    I've already said where! Auto-trading apps, they need to be super quick to find discrepancies in market prices and try to get some profit from it. As you can guess...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 28, 2012 at 6:13 am

    #1465608

  • RE: SQL Instance on a VM Image

    I think most admins will use sysprep to get an image ready to use as a deployable template.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 27, 2012 at 10:17 pm

    #1465454

  • RE: Primary Key: GUID vs. INT

    wagner-670519 (3/26/2012)

    Hi Folk,

    is it a big performance loose when using GUIDs as Primary Keys?

    Greetz Teutales

    Yes, it is. Integers are 4 bytes, and CPUs and code are optimized for their...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 27, 2012 at 10:14 pm

    #1465453

  • RE: Testing Secondary database in Log Shipping

    alark (3/27/2012)

    GilaMonster, You heard me right. I will bring the secondary databases for testing the apps in DR environment, meanwhile primary databases will continue running in real production. Then after...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 27, 2012 at 10:05 pm

    #1465452

  • RE: SQL Instance on a VM Image

    itpcpro (3/22/2012)

    I was wondering if anyone has attempted this? We are wanting to create a VM image with SQL already on it so when we create a new VM Server...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 27, 2012 at 6:54 am

    #1464945

  • RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

    >>but I have this strange feeling that you do not know how to do things efficiently in SQL Server.

    Absolutely correct - and it shouldn't be a 'strange feeling' either, but...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 27, 2012 at 6:48 am

    #1464939

  • RE: not getting rid of physical reads

    GilaMonster (3/27/2012)

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 27, 2012 at 6:46 am

    #1464935

  • RE: Index Strategy

    I think you absolutely, positively must split the inputs into a firstname and lastname in the UI. That must be part of an efficient solution I think, and it...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 27, 2012 at 6:40 am

    #1464931

  • RE: not getting rid of physical reads

    Confusing Queries (3/26/2012)

    GilaMonster (3/26/2012)

    Confusing Queries (3/26/2012)

    Is it the case we should consider flushing buffers?

    No, not unless you want SQL to suddenly have to work much harder than normal.

    so, under...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 26, 2012 at 5:09 pm

    #1464644

  • RE: not getting rid of physical reads

    Robert Davis (3/26/2012)

    Thanks for the explanation, Gail! That makes a lot of sense.

    +1. I like that much better than chewing through plans to evict!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 26, 2012 at 4:03 pm

    #1464603

  • 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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 26, 2012 at 10:02 am

    #1464385

  • RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

    1) if you want to really see what is going on, run a STATEMENT COMPLETED profiler while this query is running. But BEWARE doing this on a production box!!

    2)...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 26, 2012 at 8:50 am

    #1464311

  • RE: not getting rid of physical reads

    Confusing Queries (3/23/2012)

    We did not have proper indexes on production and almost all the queries were using clustered index scan having high physical reads.

    Now we have created new indexes specially...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    March 26, 2012 at 7:18 am

    #1464229

Viewing 15 posts - 2,986 through 3,000 (of 5,841 total)