June 8, 2010 at 10:09 pm
Silly little thing, but we use a case sensitive collation.
Change "cte" in the actual select near the bottom to be "CTE"
June 8, 2010 at 10:47 pm
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
June 10, 2010 at 9:57 am
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
February 12, 2015 at 11:29 am
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.
February 12, 2015 at 3:12 pm
In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.
February 12, 2015 at 6:33 pm
j-1064772 (2/12/2015)
In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.
That works -- thanks!
Viewing 6 posts - 31 through 35 (of 35 total)
You must be logged in to reply to this topic. Login to reply