Forum Replies Created

Viewing 15 posts - 3,256 through 3,270 (of 5,841 total)

  • RE: Revisited: RAID10 vs RAID1 SQL

    You are screwed, no matter what you do, from an IO throughput perspective. Best is to max out memory and hope your database fits in RAM. 🙂

    I would go...

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

    July 11, 2011 at 8:30 am

    #1351108

  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    rfr.ferrari (7/11/2011)

    I agree with Jim Murphy, but with relation to disks 5-8, i'm prefer raid 5 or 6, because with raid 10 I have more performance on writes on...

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

    July 11, 2011 at 8:26 am

    #1351105

  • RE: High Safety W/O Automatic Failover (Synchronous)

    GilaMonster (7/8/2011)

    Jonathan Marshall (7/8/2011)

    If it has to be forced then there is possible data loss.

    You have to force it, but in synchronous mirroring (because transactions are committed on both sides...

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

    July 8, 2011 at 2:07 pm

    #1350640

  • RE: Recovery mode change for Big databases like > 2TB

    Ola has an entire maintenance suite which does more than just index stuff. also very well documented and it can create sql agent jobs for you, etc.

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

    July 8, 2011 at 10:08 am

    #1350473

  • RE: Recovery mode change for Big databases like > 2TB

    How much your tlog will grow cannot be known ahead of time unless you are doing a rebuild, which builds a completely new index in total. If doing a...

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

    July 8, 2011 at 9:30 am

    #1350423

  • RE: sp VS adhoc query peformance?

    GilaMonster (7/7/2011)

    Please note: 3 year old thread.

    Why would you recommend setting every single statistic in the database to not get automatically updated again? Very dangerous setting without some manual stats...

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

    July 8, 2011 at 9:25 am

    #1350421

  • RE: error : subquery returned more than 1 value

    thundersplash845 (7/6/2011)

    Try using DISTINCT...

    Using this command will eliminate the duplicate records.

    Eg : Select distinct id,name from table1

    Thanks

    This isn't a solution. Note OP is using this in a subquery....

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

    July 8, 2011 at 9:22 am

    #1350415

  • RE: Too much code for this T-SQL

    Sounds like you got a sweet gig there!

    My only thing was that I have not seen many-table joins be efficient outside of tight PK/FK scenarios. The slightest variance in...

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

    July 7, 2011 at 8:22 pm

    #1350122

  • RE: Too much code for this T-SQL

    Ninja's_RGR'us (7/7/2011)

    TheSQLGuru (7/7/2011)

    Ninja's_RGR'us (6/28/2011)

    No offense but I run reports on 10s of millions of record in subseconds with 10-40 tables in joins on a 2 core 4 GB ram server......

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

    July 7, 2011 at 3:44 pm

    #1350073

  • RE: Memory pressure

    TheSQLGuru (7/7/2011)

    sqlfriends (7/7/2011)

    Thanks, can you explain a little bit more about :

    9 of 12 is ok for a start, but may need to be lower if you see paging.

    Thanks

    You...

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

    July 7, 2011 at 3:03 pm

    #1350056

  • RE: Mortgage amortization table

    Common Language Runtime. It is a way to do .NET flavor development from within the database engine. Very good for certain operations such as string manipulation, complex mathematics,...

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

    July 7, 2011 at 3:02 pm

    #1350055

  • RE: Memory pressure

    sqlfriends (7/7/2011)

    Thanks, can you explain a little bit more about :

    9 of 12 is ok for a start, but may need to be lower if you see paging.

    Thanks

    You said...

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

    July 7, 2011 at 1:28 pm

    #1349973

  • RE: Mortgage amortization table

    I would think CLR would be a great fit for doing an amortization calculation and/or schedule.

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

    July 7, 2011 at 12:17 pm

    #1349922

  • RE: Reg : DATA files Growing Fast

    I think it is inappropriate to recommend compression without a LOT more knowledge of the user's database.

    In any case, I am curious to know how much data size...

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

    July 7, 2011 at 12:15 pm

    #1349921

  • RE: Too much code for this T-SQL

    Ninja's_RGR'us (6/28/2011)

    No offense but I run reports on 10s of millions of record in subseconds with 10-40 tables in joins on a 2 core 4 GB ram server... not...

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

    July 7, 2011 at 12:13 pm

    #1349919

Viewing 15 posts - 3,256 through 3,270 (of 5,841 total)