Viewing 15 posts - 166 through 180 (of 186 total)
GilaMonster (11/20/2009)
November 20, 2009 at 10:25 am
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...
November 20, 2009 at 10:19 am
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...
November 20, 2009 at 9:25 am
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...
November 20, 2009 at 9:18 am
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...
November 20, 2009 at 7:49 am
By the way, SQL Server 2005 running in 2000 compatibility mode (80 I think). Running on Windows Server 2003 sp2
November 19, 2009 at 10:02 am
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,...
November 10, 2009 at 7:37 am
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...
September 24, 2009 at 8:02 am
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...
August 10, 2009 at 8:30 am
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...
August 10, 2009 at 8:03 am
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...
July 30, 2009 at 9:47 am
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...
July 30, 2009 at 8:26 am
Also, do you need a "@" symbol in front of your cursor variable name? I've never typed mine that way...
July 30, 2009 at 7:55 am
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...
July 23, 2009 at 8:21 am
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...
July 16, 2009 at 12:50 pm
Viewing 15 posts - 166 through 180 (of 186 total)