Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 5,843 total)

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

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

    March 14, 2012 at 12:19 pm

    #1459433

  • RE: TempDB in RAM

    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 then not available...

    March 14, 2012 at 8:18 am

    #1459218

  • RE: DataBase Max Server Memory Setting

    1) Never EVER leave sql server max memory setting at the default.

    2) For 32GB system with JUST sql server running I would start at 27GB and monitor for execessive paging...

    March 13, 2012 at 8:03 am

    #1458492

  • RE: Query help urgent!!

    There is ABSOLUTELY NO WAY the optimizer can routinely produce an optimal plan with that query. SOOOO many things in that query are getting in the way of good...

    March 13, 2012 at 8:00 am

    #1458489

  • RE: HOW TO WRITE SEARCH ENGINE QUERY FOR A DATABASE CONTAIN 3 TABLES

    er.sivaganesh (3/12/2012)

    how to use this

    Full-Text Search (SQL Server)

    in my select query

    iam not getting the point in reading this related article

    Full Text Search is...

    March 13, 2012 at 7:54 am

    #1458481

  • RE: SQL Server 2012 - Column Store Index

    isuckatsql (3/10/2012)

    Has anyone tried this?

    Is it really as fast as they say ?

    Thanks

    If you use them within their (currently narrow) allowed parameters, they are STUNNINGLY efficient. As someone else...

    March 12, 2012 at 10:04 am

    #1457977

  • RE: Long running query on only one server

    SQLJocky (3/8/2012)

    I have a query that ran in 3 seconds on a 2008 server, then we moved the database and everything to a different 2008R2 server (backup, restore) and now...

    March 12, 2012 at 10:01 am

    #1457976

  • RE: Large table cleanup with minimal locks

    cfradenburg (3/6/2012)

    TheSQLGuru (3/6/2012)

    In the vast majority of cases I have come across at clients a PK (or any index for that matter) on temp objects was NOT helping the query...

    March 6, 2012 at 9:51 am

    #1455443

  • RE: Large table cleanup with minimal locks

    cfradenburg (3/6/2012)

    ChrisTaylor (3/6/2012)

    Your statement is incorrect - if you have a reference that says otherwise please provide it.

    In this particular case a table variable will likely be best,...

    March 6, 2012 at 9:29 am

    #1455425

  • RE: Large table cleanup with minimal locks

    cfradenburg (3/6/2012)

    jberg-604007 (3/6/2012)

    can't index a table variable

    But you can declare a primary key which does have an effect on how the query is processed.

    In the vast majority of cases I...

    March 6, 2012 at 9:20 am

    #1455417

  • RE: FusionIO

    ryan.offord (3/5/2012)

    I'm currently doing a trial of some FusionIO cards. From my initial tests it all looks as good as I'd hoped with any IO intensive stuff being monstered (a...

    March 6, 2012 at 7:51 am

    #1455327

  • RE: sp_recomplie - recompile all stored procedures and fuctions

    ravisamigo (3/4/2012)

    Hi All,

    Can someone please provide the script for " sp_recomplie - recompile all stored procedures and fuctions" in all databases in SQLServer2005.

    Thanks and Regards,

    Ravi.

    Anytime I see a question like...

    March 6, 2012 at 7:49 am

    #1455321

  • RE: Large table cleanup with minimal locks

    ChrisTaylor (3/6/2012)

    jay.dunk (3/6/2012)

    I do something similar on a 24/7 db, 365 days a year with all files on a single raid 5 partition!?! I use the same approach but with...

    March 6, 2012 at 7:48 am

    #1455317

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

    wclemmer (2/27/2012)

    Just a quick poll(ish) question. [No pun intended.]

    True or False: If the SQL Server service is the only thing running (dedicated server), the default max memory setting of (bignum)...

    February 28, 2012 at 10:36 am

    #1452726

Viewing 15 posts - 3,016 through 3,030 (of 5,843 total)