Forum Replies Created

Viewing 15 posts - 5,671 through 5,685 (of 7,164 total)

  • RE: SQL Compilations/sec equals Batch Requests/sec with ad-hoc inserts possibly causing high CPU utilisation

    jimmerthy (7/3/2011)

    Just so I definitely understand your recommendation of using 'a series of INSERT statements' - are you saying that it's good to continue to batch up n INSERT statements...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 5, 2011 at 10:27 am

    #1348429

  • RE: Wait Stats & Oledb wait

    Do you use a lot of Linked Servers?

    Found this too:

    http://www.sqlservercentral.com/Forums/Topic336973-146-1.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 5, 2011 at 10:23 am

    #1348421

  • RE: How to change model db owner?

    EdVassie (7/5/2011)

    Sometimes things are not working the way they should and you have to go behind the scenes to fix it. For example fixing satellites[/url]

    Thanks for the chuckle on...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 5, 2011 at 9:49 am

    #1348384

  • RE: parallel execution of a stored proc?

    I know you're capable Ben but if you have not used it and get shy about SSB one time saver I'll throw out there about Agent jobs: make one schedule...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 5, 2011 at 9:41 am

    #1348376

  • RE: How to change model db owner?

    EdVassie (7/5/2011)

    However, if you do end up with model or another system db owned by something other than sa and want to set it back to its rightful owner, the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 5, 2011 at 9:28 am

    #1348360

  • RE: Increasing CPUs hurts Perf

    ** Sweet ** Plan Guides are available in 2008 Web Edition.

    as2higpark (7/5/2011)

    ...

    Any ideas on how to deal with this offender or am I left to try to convince the developers...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 5, 2011 at 9:10 am

    #1348344

  • RE: Increasing CPUs hurts Perf

    ooops...checking on something in Web Edition

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 5, 2011 at 9:06 am

    #1348339

  • RE: Increasing CPUs hurts Perf

    repicurus (7/4/2011)

    ...abbreviated...

    I would check to see if HYPER-THREADING (not "Hyper-V") is enabled in the BIOS for these servers.

    If so - disable it.

    ...abbreviated...

    I have disabled Hyperthreading on a server suffering from...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 4, 2011 at 6:12 pm

    #1348030

  • RE: loop through linked servers

    You could also use Dynamic SQL for the task but it seems like a waste of resources to incur the overhead of looking up the list of linked servers and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 4, 2011 at 8:47 am

    #1347900

  • RE: tracking who does inserts, deletes etc

    Some options:

    > SQL Trace can provide those details on a macro level.

    > Use SQL Audit to capture "Database-Level Audit Actions" (Enterprise Edition only)

    > manually capture DDL events in a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 4, 2011 at 8:41 am

    #1347897

  • RE: Creating CLR Procedures and Assembly in SQL Server using Visual Studio

    pandu.72 (7/3/2011)

    Thanks for the Reply..... Here is the reason why I am going for the UNSAFE setting

    As per my requirement I need to call a normal SQL server stored procedure...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 4, 2011 at 8:04 am

    #1347869

  • RE: Increasing CPUs hurts Perf

    CXPACKETs are going to happen as long as MAXDOP != 1, the trick is to reduce them. If this is primarily an OLTP system there may not be much point...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 4, 2011 at 7:50 am

    #1347853

  • RE: Using VSS for data mining

    Are you trying to initiate a shadow copy on your own? Typically a backup software or hardware management software interacts with VSS for you. What are you trying to do?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 4, 2011 at 7:38 am

    #1347843

  • RE: Transaction Log

    opc.three (7/2/2011)

    Lynn Pettis (7/2/2011)

    As far as when the compatibility views will go away, Microsoft doesn't always tell you. I haven't load Denali, so I can't say if they exist...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 2:09 pm

    #1347486

  • RE: SQL Compilations/sec equals Batch Requests/sec with ad-hoc inserts possibly causing high CPU utilisation

    PS This is fresh in my mind due to another spirited thread but here is your query to look at execution use counts rewritten to use the current set of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 1:48 pm

    #1347483

Viewing 15 posts - 5,671 through 5,685 (of 7,164 total)