Viewing 15 posts - 5,311 through 5,325 (of 18,926 total)
remove the nooutput so you can see what's going on.
You could also run that from the real cmd line so you get the real error message (if there's one)
June 23, 2011 at 8:23 am
So the single query sometimes take 5 seconds and sometimes 15 minutes?
Are the stats up to date? When was the last stats update and what type of date is...
June 23, 2011 at 8:03 am
John Mitchell-245523 (6/23/2011)
OK, let's try this a different way. Please run this and post the results:
USE <InsertYourDBNameHere>SELECT type_desc, name, physical_name, size * 8.0/1024/1024 AS file_size
FROM sys.database_files
Thanks
John
Sys schema for sql...
June 23, 2011 at 7:48 am
vinod.saraswat (6/23/2011)
Its business key column not from the DTA
Please post table definition including keys and actual execution plan (as attached file).
June 23, 2011 at 6:36 am
anthony.green (6/23/2011)
June 23, 2011 at 6:24 am
vinod.saraswat (6/23/2011)
Hi All,Its doing the clustered index scan.
... any reason you can't add the non clustered index on the item column??
June 23, 2011 at 6:18 am
anthony.green (6/23/2011)
Is this Dynamics AX by any chance?
... I see the same kind of things with Dynamics Nav. Nice application to code in... not the fastest to run queries...
June 23, 2011 at 6:17 am
Rhox (6/23/2011)
You can save this query and run the Database Engine Tuning Advisor against it...This will create scripts to make your indexes
NEVER a good idea to blindly do what the...
June 23, 2011 at 6:04 am
Warwick rudd (6/23/2011)
Does your table have an index on the column in your where condition ?
That's the only it'll ever run fast... and ideally that index needs to have...
June 23, 2011 at 6:03 am
Is this just 1 query or a series of queries in a loop (most likely client side)?
June 23, 2011 at 6:01 am
vivekvinodhraj (6/23/2011)
i think, iam using sql 2005.. i will try to download 2008 express edition and copy the database to it..
On the same server where your query is running slowly...
June 23, 2011 at 5:37 am
vivekvinodhraj (6/23/2011)
Ok fine then, i will do onething. i will try to download new version of sql and try it..
Won't help if you don't plan to upgrade.
What version are you...
June 23, 2011 at 5:06 am
It takes over 1 second to return 1-5 rows from 1 table????
Then you have serious problem somewhere on the hardware. The thing is I've never tuned a sql 7...
June 22, 2011 at 7:20 pm
Does the table have a clustered index? Is the table fragmented?
I see no use of the index, are you sure it's there?
What's the plan when the query runs fast?
June 22, 2011 at 5:48 pm
Did you consider doing this sequence?
select * from base into ##temp
truncate base
insert into base select * from ##temp
Might have solved it for you.
June 22, 2011 at 5:47 pm
Viewing 15 posts - 5,311 through 5,325 (of 18,926 total)