Index usage overview

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by wfvdijk » Index usage overview

33 posts, Page 4 of 4

«««1 2 3 4

Index usage overview

Rate Topic

Display Mode

Topic Options

Author

Message

Toby Harman

Posted Tuesday, June 08, 2010 10:09 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 8:38 PM
Points: 322, Visits: 477

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

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

Post #934372

SQLRNNR

Posted Tuesday, June 08, 2010 10:47 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

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 2008

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

R_Casey

Posted Thursday, June 10, 2010 9:57 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 01, 2013 8:50 AM
Points: 15, Visits: 66

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 »

33 posts, Page 4 of 4

«««1 2 3 4

Permissions