I am using Management studio. I want to save the Execution plan on a stored procedure, but the Save Execution plan option is disabled. Even on the File menu the Save Execution plan option is disabled. Is this some security issue or Is it because of Express
addition. Is there any way to get around this problem.
Thanks in advance.
View Complete Post
I have a query that is taking over 2 hours to run. When I look at the execution plan for a major segment of it, 75% of the cost is on three instances of "Table Spool" (25% each). What is "Table Spool" and how do you address it? The execution plan lists this as
Table Spool(Eager Spool)
There are actually 2 queries involved. One loops through a series of dates and calls the second one. All joining fields have indexes in their corresponding tables:
-- Process all quarters declare @lastQtrStart datetime declare @currentQtrStart datetime declare @currentQtrEnd datetime
set @currentQtrStart = '1/1/2008' set @lastQtrStart = '1/1/2020'
while @currentQtrStart < @LastQtrStart begin set @currentQtrEnd = dateadd(d , -1 , dateadd(MM , 3 , @currentQtrStart))
Can you please help me out to figure out the problem ?
I am not able to debug ASP.Net applications on my localhost. What could be the reason. When I checke project properties (for all my asp.net websites) i observered that the "Use Custom Web Server" option is disabled for all websites.
Any guesses what could be the reason. I am using Windows Xp SP 3 and have IIS installed on my computer. The issue was not there couple of days ago, but started creating problem since last night.
We have 4 QUAD core processors and we have set max degree of parellelism to 4(as suggested by Microsoft). As of now we are using the default value for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)".
Please suggest how to estimate the best value for for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)"?
This was working until a few days ago. I dont know if I change some config.
FROM sys.dm_exec_query_stats as EQS
CROSS APPLY sys.dm_exec_sql_text(EQS.sql_handle)
CROSS APPLY sys.dm_exec_query_plan(EQS.plan_handle)
Return a Xml "<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver......"
When I click at cell, I want to see Graphical Execution Plan, not the XML.
One of my customer db there is one maintenance plan(full backup / Transaction log backup ) schedule time for the full backup is 11:00:00 PM daily and for transaction log backup 12.30 pm Sunday to Friday ,I
checked the job created by maintenance plan there also schedule time is same but when i check the history of the job it shows it happened at 7:00:00 pm every day. why there is time difference ?
Product version is 8.00.2055(SP4)
i checked the MSDB.dbo.sysjobschedules table and the next_run_date is not updated properly,it is showing yesterday 11:00:00 pm
please help me to resolve this issue