level is column but myvalue is just a label (but changes) on each union.

I wanted to make level andy Myvalue as a paramter. Can that be done?

WITH CTE (col1, col2, col3) AS

(

SELECT '1' col1,'abc' col2, 'bbc' col3 UNION ALL

SELECT '2'col1,'nbc' col2, 'zhi' col3 UNION ALL

SELECT '3'col1, NULL col2, 'abc' col3 UNION ALL

SELECT '4'col1, 'gef' col2, NULL...

Row with abc shouldn't show up since abc is the exclusion list. On yours it is appearing twice. In row 1 and 2.

Thanks Gail. Should I expect 10GB growth everytime I rebuild the index? This happened on only one DB that had snapshot. But I dropped snapshot before rebuilding index.

Any idea why DB grows to 10GB more after index maintenance? Should I opt for shrinkfile?

I ran the following statments

SELECT ps.database_id, ps.OBJECT_ID,

ps.index_id, b.name,

ps.avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps

INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID

AND ps.index_id = b.index_id

WHERE ps.database_id = DB_ID()

ORDER...

Thank you. Thanks for the query to find out heavily used indexes. Using this, as far as statistics are concerened, we won't be able to capture _WA statistics but only...

Thank you so much for your suggestion. How about is there a way to figure out which stats are mostly used and needs updated?

Another question...For two 150 GB database.....both of...

Anybody can shed light on this would be much appreciated.

Each record will be unique though as it will be identified by AccountID.

It stores an account. Users will either and new account or update existing account.

All are varchar(50) except a pk which is an int. To clarify further, users enter/ update data through the web to this table. It is kind of necessary to show...

That is absolutely correct.

Thanks. Also noticed its increasing about 1GB per day; which is not realistic. What should I check for?