no response - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

no response

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-02-17 : 09:10:25

Hi,
There are several tables which I can not run select query against.
The query analyser just says "Executing query".
How can I solve this issue please?
Thanks

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-17 : 10:10:18

Sounds like a poorly written Query and it's executing

Did you do a show plan?

Can you do select count(*) against the tables in the query?

You need to post the query and the DDL for the tables including the contraints

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-17 : 14:06:08

also check if there's an open transaction or blocking using sp_who2

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources