Hi Nancy! Is there any other error message on the job history? Then try marking the "Show step details" checkbox (if you haven't marked yet) and look...
First of all, I'd like to ask you to forgive me if this is a repost, I tried to search the forum but got Timeout Expired errors. I also checked the 9...
Hello Luis! Thanks for your reply!<br /><br />It's not really a need, just curiosity also! <img src='/community/emoticons/emotion-5.gif' alt=';)'...
Hi folks!<br /><br /><br />Does anyone knows if it's possible to review the execution plan for a running query without generating an Estimated...
Thanks everybody again! I didn't knew that a non clustered index could be useful to an count(*)... I made some tests in the development environment...
Thanks very much for your reply, Keith and Luis! Really helpful! Regards, Fernando Toledo
quote:Originally posted by kpayne Are you able to change the COUNT(*) query? If you aren't then you are SOL. COUNT(*) is a table or clustered...
quote:Originally posted by LuisMartin What about execution plan?. May be you need and index. Oh, my bad! I forgot to post it! The plan is like...
Hello everybody! I have database used by a 3rd party app [xx(] and users are complainting about a "select count(*) from table with (nolock)"...
Hello there! Depending on your needs, you can create a separated table, containing only the large table's row count information, updated thru a...
Separate names with a comma.
