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
Posted Tuesday, June 08, 2010 10:09 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:46 PM
Points: 381, Visits: 535
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 08, 2010 10:47 PM



Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 20,455, Visits: 14,067
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


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


Group: General Forum Members
Last Login: Monday, July 01, 2013 2:47 PM
Points: 15, Visits: 67
I am having an arithmetic overflow in the view on a smallint datatype but cannot find any smallint types in the view. Any suggestions?
Post #935487
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse