Forum Replies Created

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

  • RE: High CPU usage due to bad execution plan occurs unexpectedly

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

    sdelachapelle (7/11/2011)

    Hi, thanks for the proposal but I work in Paris 😉

    Close enough! :w00t:

    I'm 10 minutes away from the airport in case of emergency!

    HAH - I am 0 minutes...

    July 12, 2011 at 6:42 am

    #1351530

  • RE: saving maintenance plan failed in sql2008

    Stop using maintenance plans. go to ola.hallengren.com and use the FREE and fully documented goodness there! Awesome stuff.

    July 12, 2011 at 6:37 am

    #1351524

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

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

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

    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.

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

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

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

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

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

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

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

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

    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.

    July 7, 2011 at 12:17 pm

    #1349922

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