Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 5,841 total)

  • RE: How much memory should be allocated to SQL Server 2008 R2 64 Bit Enterprise

    GilaMonster (3/25/2012)

    Lian (3/24/2012)

    Now if you were to set it to use 9 gig out of 10 gigs the server administrators are seriously concerned and raise the alarms and...

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

    March 26, 2012 at 7:06 am

    #1464220

  • RE: Parallel DB availability

    sqlquest2575 (3/23/2012)

    Well..SQLGuru..first of all i would like to thank everyone who responded to my question and secondly..i was just trying to get some expert advice and was not trying to...

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

    March 24, 2012 at 8:07 am

    #1463913

  • RE: Index rebuild suddenly takes 5 times as long ?!?

    Divine Flame (3/23/2012)

    TheSQLGuru (3/23/2012)

    I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad for your...

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

    March 23, 2012 at 9:23 am

    #1463483

  • RE: sargability, optimized execution plans, their caching, dynamic sql, and or highly modularized stored procedures.

    GilaMonster (3/23/2012)

    TheSQLGuru (3/23/2012)

    Snargables (3/22/2012)

    If parametized dynamic sql will result in more cache hits then why would anyone write non parameterized dynamic sql?

    There are MANY times where you don't WANT the...

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

    March 23, 2012 at 9:21 am

    #1463480

  • RE: Index rebuild suddenly takes 5 times as long ?!?

    I want to jump on the "you MUST adjust your fill factors to avoid such huge index fragmentation" bandwagon!! That is just crazy bad for your IO subsystem AND...

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

    March 23, 2012 at 7:15 am

    #1463364

  • RE: Index Fragmentation and SANs

    adrienne.lore (3/22/2012)

    OK... so I guess my concern is more with index fragmentation then, not disk. I was also told that in a thin-provisioned sql environment, this also meant...

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

    March 23, 2012 at 7:14 am

    #1463362

  • RE: Is this a bug?

    From the OP:

    >>But it just picks the last one.

    Jeff kinda touched on this, but I wanted to reiterate something: there is NO ordering in set based processing unless...

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

    March 23, 2012 at 7:08 am

    #1463355

  • RE: sargability, optimized execution plans, their caching, dynamic sql, and or highly modularized stored procedures.

    Snargables (3/22/2012)

    If parametized dynamic sql will result in more cache hits then why would anyone write non parameterized dynamic sql?

    There are MANY times where you don't WANT the engine to...

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

    March 23, 2012 at 7:00 am

    #1463339

  • RE: Generate insert statement from table

    opc.three (3/22/2012)

    The SSMS Tools Pack has a built-in feature to help you generate INSERT statements from a table, or even from a specific query...very handy.

    SSMS Tools Pack > Generate Insert...

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

    March 23, 2012 at 6:56 am

    #1463334

  • RE: Parallel DB availability

    sqlquest2575 (3/21/2012)

    Hello Friends, I was wondering if you can help me finding a solution....We need to extract data on a daily basis from production database but since this is production...

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

    March 23, 2012 at 6:54 am

    #1463332

  • RE: By Backup job is getting failed

    Go to ola.hallengren.com and use the AWESOME database maintenance stuff found there. Fully documented and incredibly flexible - and FREE!

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

    March 22, 2012 at 6:59 am

    #1462671

  • RE: TempDB in RAM

    Devil's Bloody Advocate (3/20/2012)

    TheSQLGuru (3/14/2012)

    ............. FusionIO cards take up a LOT of system memory.........l:

    I thought that FusionIO cards sat in the PCI slots on the motherboard and were not...

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

    March 21, 2012 at 9:35 am

    #1462232

  • RE: SQL Source Control

    Since you are looking for options, ApexSQL has source control built into their Edit product. AFAIK they were the first to have that functionality baked into an editor.

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

    March 15, 2012 at 10:43 pm

    #1460314

  • RE: TempDB in RAM

    SQLKnowItAll (3/14/2012)

    TheSQLGuru (3/14/2012)

    Gianluca Sartori (3/14/2012)

    TheSQLGuru (3/14/2012)

    I would really question putting TEMPDB on a RAM disk in this scenario. FusionIO cards take up a LOT of system memory - which...

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

    March 14, 2012 at 2:36 pm

    #1459493

  • RE: TempDB in RAM

    Gianluca Sartori (3/14/2012)

    TheSQLGuru (3/14/2012)

    I would really question putting TEMPDB on a RAM disk in this scenario. FusionIO cards take up a LOT of system memory - which is obviously...

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

    March 14, 2012 at 12:19 pm

    #1459433

Viewing 15 posts - 3,001 through 3,015 (of 5,841 total)