What you have left to do is not going to be easy. Especially since you have no reliable method of determining that the first element in the space delimited...

As written - your trigger is only valid when you can guarantee (for all time) that there will only ever be a single row updated at a time.

If you try...

Sorry - that is a typo, it should be COALESCE.

Because you are not referencing the table CFD in the from clause. You need something like:

UPDATE a

SET {columns}

FROM CFD AS a

...

Lookup GROUP BY and COUNT in Books Online.

When you say blank, do you mean an empty string? If so, try:

select ID, cltattn, cltemail from clients where cltattn is not NULL and cltemail is not NULL

SELECT ID

...

Well, with that small of an index - it will always show some level of fragmentation. It really doesn't mean much anyways if you think about it. With...

Here is another method that is a bit simpler:

select convert(char(10), getdate(), 101)

+ ' ' + convert(char(5), getdate(), 108);

You can also get this information using SMO and the properties DataSpaceUsage and IndexSpaceUsage.

Not sure if you can use that, since you can't use fileproperty().

How many pages in that index? Small tables will always show some level of fragmentation. If this is a larger table (1000 pages or more) and it still...

Also, you might be running into different execution plans between SSMS and ADO. That would depend upon the connection parameters being setup in ADO. One thing I have...

SELECT * FROM TableA

EXCEPT SELECT * FROM TableB;

The result will be rows from TableA that do not have a corresponding row in TableB (exact match on all columns). If...

Jeff Moden wrote an article on this site that addresses the issue of Running Totals. However, he apparently has pulled the article to correct some issues he found with...

To only affect those indexes that have more than 1000 pages:

Selectobject_id As ObjectId

,index_id As IndexId

,partition_number As PartitionNumber

,avg_fragmentation_in_percent As AvgFrag

,page_count As PageCount

,index_type_desc As IndexType

Into #work_to_do

...

If you are running Enterprise Edition - you have the option of rebuilding indexes ONLINE. As it is currently written, those indexes being rebuilt will not be available -...