A question regarding the logic rather than syntax: what do you want to do with it?

sp_helpdb together with sys.tables doesn't seem to make much sense though...

SELECT 'sp_helpdb ''' + name + '''' FROM sys.tables

Please also note the added space after sp_helpdb.

I'm not sure about your data structure but maybe all that's missing is to include a join on the Seq columns: xr.ProgramID = d.ProgramID AND d.PrgSeq = xr.Seq

Edit: and as...

john-902052 (1/1/2011)

---

Please forgive me but I just am not understanding. CInstID is an identity column so there can not be two in the same table. The data only...

The result makes perfectly sense to me:

Let's look at an example:

[cInstID]=187

Without the two columns in question you have one row only. But as soon as you include one of the...

You might want to read this[/url] article to verify your data types are as efficient as possible.

Aother issue might be the indexing strategy itself. Maybe you can narrow it down...

If you're talking about such a table size, you should apply several changes:

Don't use 'Play','Stop' and the like. Make it a tinyint number and use a Lookup-Table if needed.(Edit: Gianluca...

You need the 4-part name. In your case it seems like the schema is missing.

Assuming it's dbo, the query would look like

select * from DATA2.DB_name.dbo.TableName

Less than 6 hrs here in Europe.

I watched the Firework (TV) they had in HongKong. Very impressive!

Please save the execution plan as .sqlpaln file and attach it.

Why Excel???

You won't be able to open it anyway...

Use BCP (see BooksOnLine for details) or SSIS and store the data in a txt or csv format.

koolme_85 (12/31/2010)

---

hi ,

well i have created nonclustered indexes on the the colums thats used in where and group by claus

but the seems to be having no improvements in...

Why don't you give it a try and change the query?

The fix isn't that complicated...

Here's a short example. Please note that I used full seconds instead of 0.4 frictions. But it should be easy to adjust that.

DDL and Sample data for those who'll continue...

Ali,

the links you provided seem to be broken. Neither can I find a picture of the data nor the graph. Please add the pictures as attachements to your post (there...