Index usage overview

Question

Post reply

Index usage overview

Viewing 6 posts - 31 through 35 (of 35 total)

You must be logged in to reply to this topic. Login to reply

Toby Harman SSCarpal Tunnel Points: 4169 More actions · Answer 1

Silly little thing, but we use a case sensitive collation.

Change "cte" in the actual select near the bottom to be "CTE"

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Wilfred van Dijk (5/5/2010)
5/5: New version deployed
- FILEGROUP_NAME() function implemented (actually ... discovered :Whistling:)
- removed join to sysindexes (not used)
Waiting for approval!

Thanks for the update!!

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

R_Casey SSC Veteran Points: 293 More actions · Answer 3

Greetings.

I am having an arithmetic overflow in the view on a smallint datatype but cannot find any smallint types in the view. Any suggestions?

Thanks

Megan Brooks Old Hand Points: 378 More actions · Answer 4

I just tried your script and it works for smaller databases but fails on any of our large (and heavily fragmented) production databases with

Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 65602.

The problem doesn't seem to be in the view itself. I will troubleshoot it when I can find time. It may work once I can bring the fragmentation issues under control, but that may be months or years from now.

j-1064772 SSCertifiable Points: 5316 More actions · Answer 5

In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.

Megan Brooks Old Hand Points: 378 More actions · Answer 6

j-1064772 (2/12/2015)
In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.

That works -- thanks!

Index usage overview

Cookies on SQLServerCentral