Groups > comp.databases.ms-sqlserver > #894

indexes

From	"m" <web12master@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	indexes
Date	2012-01-09 15:34 +0100
Organization	B.net Hrvatska d.o.o.
Message-ID	<jeett7$h4p$1@gregory.bnet.hr> (permalink)

Show all headers | View raw

Hello,

I've been trying to run this sql:

SELECT b.fill_factor, b.type_desc, a.index_id, b.name, 
a.avg_fragmentation_in_percent, a.avg_page_space_used_in_percent

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

JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = 
b.index_id;

We have few database on our server.

On most of them this sql statement works fine, but on few of them I got 
error

Msg 102, Level 15, State 1, Line 8

Incorrect syntax near '('.

What could be a problem?

I don't get it? The statement is exactly the same, once it works fine, next 
time there is error?!

Thanks in advance

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

indexes "m" <web12master@gmail.com> - 2012-01-09 15:34 +0100
  Re: indexes Erland Sommarskog <esquel@sommarskog.se> - 2012-01-09 23:33 +0100
    Re: indexes "m" <web12master@gmail.com> - 2012-01-10 08:39 +0100

csiph-web