When I try to execute
select object_name(object_id), index_id, index_type_desc, avg_fragmentation_in_pctfrom sys.dm_db_index_physical_stats(db_id(),null,null,null,'limited')
on my server, I get the following error:
Server: Msg 102, Level 15, State 1, Line 5Incorrect syntax near '('.
Anybody else having this problem? If you can, please reply to bscrivener@hcad.org. Thanks.
Actually this is more of a web site comment.
Because of the layout style there's no way for me to view the ends of all the sentances. Even with IE full screen the right side is cut off. This happens a lot.
eg "Data warehouse designs, on the othe" [... hidden text...] "Star or Snowflake design" or "As ragmentation increases, data will become spread out over mo" [... hidden text...] "your query needs to retrieve, the slower the query." Whole sentances inbetween are missing.
An unfortunate disservice to an article the 2/3rds of which I could read looks very interesting.
This is a great site and I've come here for a couple years but the unconstrained content area is really frustrating. If this happens to you please join me in patient occasional reminders to the busy guys who run SSC. I'll chime in again about it in a few months, this is my third one.
To their credit there is no other site on earth I'm willing to read via view source.
just my 2c
