Forum Replies Created

Viewing 15 posts - 166 through 180 (of 186 total)

  • RE: New Code not running

    GilaMonster (11/20/2009)


    Double (triple) check that you're looking at the same server from the Quest tool and management studio. Double (triple) check that it's the same database. Double (triple) check that...

  • RE: New Code not running

    GilaMonster (11/20/2009)


    select <column list>

    from sys.dm_exec_cached_plans cp

    Cross Apply sys.dm_exec_query_plan(cp.plan_handle) qp

    Inner Join sys.objects o On o.objectid = qp.object_id

    Run this in the DB that the object is in rather than master, otherwise you'll...

  • RE: New Code not running

    Quest Performance Analysis shows it in it's "Top 25" CPU consuming procedures and when I click on "View SQL Text", it doesn't have my code change, it still says MAXDOP...

  • RE: New Code not running

    Hi Gail, thanks for the responses...I'll work on the query plan stuff in a little bit.

    In regards to your first reponse, if I go to Management Studio, navigate to the...

  • RE: New Code not running

    Wow! A failover of the sql server did NOT fix my stored procedure.

    As a side question to this, I'm trying to query for the execution plan for this specific proc...

  • RE: New Code not running

    By the way, SQL Server 2005 running in 2000 compatibility mode (80 I think). Running on Windows Server 2003 sp2

  • RE: substring more than 4000 characters

    This is what I use, except it's for text data types. I thought that varchar (if that's what your field is set as) is a max lenght of 4000. Anyway,...

  • RE: Problem with Management Studio scripting/Bug ID FDBK44155

    It isn't even fixed in 08 either, and another post/article I read said the fix was so tricky (or some word like that) that they weren't even going to include...

  • RE: Twenty tips to write a good stored procedure

    Grasshopper, by the way, I'm not putting them in master.....just using a dbname as an example (obviously a bad example).

    Thanks for your response, but I'm having a little trouble understanding...

  • RE: Twenty tips to write a good stored procedure

    Here's a question about one of the items. You mentioned that writing "master.dbo.proc_name" is better than just "proc_name", well, what about writing "master..proc_name"? My company does not specify...

  • RE: Indexing Question...

    Here is the proc:

    SELECTCSH.Non_Cash_Act_IDAS [NonCashActivityID],

    Pmt.Pmt_IDAS [PmtID],

    Pmt.Statement_IDAS [StatementID],

    CSH.AmountAS [Amount]

    FROMNon_Cash_Act CSH

    INNER JOINCD_Session SES ON SES.CD_Session_ID = CSH.CD_Session_ID

    INNER JOINPmt ON CSH.Pmt_ID = Pmt.Pmt_ID

    INNER JOINStatement ST ON ST.Statement_ID = Pmt.Statement_ID

    WHERESES.Cash_Drawer_ID = @Cash_Drawer_ID

    ANDST.StatementVoidIndicator = @False

    ANDCSH.Active...

  • RE: Indexing Question...

    Yep, there are already a few indexes on this table that cover the PK and other "ID's" in the table, but one specific SP always comes back via Quest Perfomance...

  • RE: Sql cursor is not returning data

    Also, do you need a "@" symbol in front of your cursor variable name? I've never typed mine that way...

  • RE: Locking Tables with Trans

    Luke and Steve, just to let you guys know. This issue was resolved for me.

    We found out that security patches went onto our SQL Server two nights before the...

  • RE: Locking Tables with Trans

    Thanks again Luke and Steve!

    To give you guys more background information on my process/problem that I have (if you care)...

    On a day-to-day basis, there are approximately 2000 inserts into table...

Viewing 15 posts - 166 through 180 (of 186 total)