Forum Replies Created

Viewing 15 posts - 241 through 255 (of 341 total)

  • RE: Allocate memory to SELECT statement in sql server 2005

    sqlbuddy123 (1/13/2011)

    You can't allocate memory at the individual query level.

    ...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    January 13, 2011 at 1:54 pm

    #1273278

  • RE: cpu bottleneck

    Koen (da-zero) (1/13/2011)

    Grant Fritchey (1/13/2011)

    Koen (da-zero) (1/12/2011)

    TheSQLGuru (1/12/2011)

    I am curious what you mean by "advisor" here. Hopefully you do NOT mean Database Tuning Advisor!! Avoid that like the...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    January 13, 2011 at 12:08 pm

    #1273225

  • RE: Allocate memory to SELECT statement in sql server 2005

    Sachin Nandanwar (1/12/2011)

    It can be done for a particular login using resource governer but not for a query or a SP.What you do basically is create resource pool and assign...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    January 13, 2011 at 11:37 am

    #1273204

  • RE: Moving SQL 2000 to 2008

    So I gave up daisy chaining in favor of scripting out deletion of the old merge articles between 2000 and 2000 and creating new merges between 2008 and 2000 stores....

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    November 21, 2010 at 8:41 pm

    #1253567

  • RE: Potential Issue with Re-Naming Stored Procedures

    Linked on my LinkedIn profile. I wonder how wide the scope of this issue is. I have seen rename used many times and I bet there are alot of DBA's...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    October 7, 2010 at 9:06 am

    #1233678

  • RE: Can I use a saved execution plan?

    GilaMonster (8/14/2010)

    Twinsoft SME (8/13/2010)

    I wish I could go to some conferences...... !!!!!!!!!!!!

    Start saving up. I've been paying for myself the last 2 years.

    By speaking at the conference, the conference fee...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 14, 2010 at 2:23 pm

    #1207057

  • RE: A Server is Not a Machine

    While I agree that SQL Server has come a long way, after spending a week with 2 professional and experienced IBM DB2 DBA's and 2 professional and experienced Oracle DBA's,...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 14, 2010 at 1:10 pm

    #1207053

  • RE: Can I use a saved execution plan?

    Twinsoft SME (8/13/2010)

    I wish I could go to some conferences...... !!!!!!!!!!!!

    Get a great job in a great company like Centriq Training of Kansas City! 🙂 We are always on...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 13, 2010 at 4:57 pm

    #1206968

  • RE: Can I use a saved execution plan?

    Wow, I really missed it 🙂

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 12, 2010 at 2:58 pm

    #1206334

  • RE: Can I use a saved execution plan?

    I missed it!!! I was in New Orleans this year...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 12, 2010 at 11:28 am

    #1206223

  • RE: Can I use a saved execution plan?

    hehe.... the first words out of my mouth today were, " I would never recommend doing this but IF you wanted to..."

    🙂 I have always known it could be done...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 11, 2010 at 5:53 pm

    #1205772

  • RE: Can I use a saved execution plan?

    Yes, I tried it and it works. And I could even modify it carefully and it still works.

    Thanks for the info!

    BTW, and I am aware that using a plan is...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 11, 2010 at 8:15 am

    #1205379

  • RE: Can I use a saved execution plan?

    To use it in conjunction with a T-SQL statement... could I use it with an OPTION (USE PLAN...) clause? The examples I have found are calling .xml... It looks...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    August 11, 2010 at 7:46 am

    #1205360

  • RE: Incompetent or Malicious

    Question Guy (7/20/2010)

    My title is DBA, but I have no official responsibility for database backups, clustering, or restores, or anything to do with hardware. I don't even have access to...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    July 20, 2010 at 9:25 am

    #1195625

  • RE: Incompetent or Malicious

    jeff.mason (7/20/2010)

    Some do, some don't. It's the same old thing -- people all say that you need a DBA but no one accepts what a DBA says because they...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

    July 20, 2010 at 9:13 am

    #1195607

Viewing 15 posts - 241 through 255 (of 341 total)