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: Tuesday, July 15, 2014 1:10 AM
Points: 401, Visits: 546
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:24 PM
Points: 21,209, Visits: 14,896
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #934383
Posted Thursday, June 10, 2010 9:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 1, 2013 2:47 PM
Points: 15, Visits: 67
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
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse