Try rebuilding this index with any of your newly added columns in it's include list.

[IDX_AccountID_Activated_eVs_IsDemo_Type_CreatedDate].

Are there any nonclustered indices on the table?

Maybe this is a dumb question, but was there a covering index on your query before you added the new columns? You saying that including any of the new columns...

Another twist (although does basically the same thing)

declare @t table (order_key int, comment char(1))

insert into @t (order_key, comment)

values (1,'a'),(1,'b'),(1,'c'),(2,'a'),(2,'b')

select

order_key,

stuff((select ','...

Hi Query Sheperd,

Grant makes some good points. If his response answered your question then read no further.

For my two cents, I would find it helpful to know a bit...

Check this out:

http://blog.sqlauthority.com/2014/01/20/sql-server-how-to-validate-syntax-and-not-execute-statement-an-unexplored-debugging-tip/

I use SSMS Tools Back by Mladen Prajdic

http://www.ssmstoolspack.com/

Way cheaper than redgate, and I get quite a bit out of it. I find the most useful feature is the snippet generator....

As I'm thinking about this more (with the somewhat limited amount of information I have) two things come to mind.

The first is to build a calendar table; basically an enhanced...

Hi sgmunson,

Thank you for all the code and data you provided, but there's a lot going on there, and as is, those functions can't be run (since they call other...

Unless you need a more granular breakdown, you can just run sp_spaceused on the database itself. e.g.

use AdventureWorks2014

go

exec sp_spaceused

First off, great series. My problem is this. I built the lookup operation verbatim, but it's giving me the following error:

"The component has detected a potential metadata corruption during validation....

So what you're saying is if there are any duplicate records for name and address, those records should be excluded from your select statement.

What you want to do then is...

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

I'd also familiarize yourself with xpath and xquery.

Thank you both for the replies and examples. These have been quite helpful.

Also, as a side note, even though this is a 2008 specific forum, if you have 2012 +, if all you need is the number and you don't care about...