Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Index usage overview Expand / Collapse
Author
Message
Posted Tuesday, June 8, 2010 10:09 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:17 PM
Points: 434, Visits: 636
Silly little thing, but we use a case sensitive collation.

Change "cte" in the actual select near the bottom to be "CTE"
Post #934372
Posted Tuesday, June 8, 2010 10:47 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 19,171, Visits: 17,468
Wilfred van Dijk (5/5/2010)
5/5: New version deployed

- FILEGROUP_NAME() function implemented (actually ... discovered )
- 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
Post #934383
Posted Thursday, June 10, 2010 9:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 7, 2015 12:31 PM
Points: 15, Visits: 70
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
Post #935487
Posted Thursday, February 12, 2015 11:29 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:20 AM
Points: 25, Visits: 128
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.
Post #1660030
Posted Thursday, February 12, 2015 3:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:18 PM
Points: 162, Visits: 684
In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.
Post #1660094
Posted Thursday, February 12, 2015 6:33 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:20 AM
Points: 25, Visits: 128
j-1064772 (2/12/2015)
In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.


That works -- thanks!
Post #1660110
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse