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 12»»

Indexes Expand / Collapse
Author
Message
Posted Thursday, March 20, 2014 9:16 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Comments posted to this topic are about the item Indexes

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1553306
Posted Friday, March 21, 2014 1:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,258, Visits: 11,042
Thanks for the question.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1553332
Posted Friday, March 21, 2014 2:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:02 AM
Points: 2,560, Visits: 2,419
Remember that "Filtered indexes" are used only if the WHERE clause matches or is compatible with the filter.
View http://www.sqlservercentral.com/questions/T-SQL/105826/
Post #1553351
Posted Friday, March 21, 2014 5:31 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:22 PM
Points: 4,219, Visits: 3,654
I love indexing questions. Good way to end the week.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1553430
Posted Friday, March 21, 2014 5:34 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, October 17, 2014 2:30 AM
Points: 2,581, Visits: 144
They can also be used on a view as long as it is a persisted view.
Post #1553433
Posted Friday, March 21, 2014 7:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:25 PM
Points: 1,851, Visits: 2,186
Thanks for the great question! Inspired me to do a little refresher study of indexes (and views too). Got me to working on a couple of needed views for reporting. Can't get too carried away, as the next version of our ERP software is "just around the corner" (where it has been for 6 months) and involves major changes to the DB. But, I digress ...

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1553483
Posted Friday, March 21, 2014 7:38 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:05 AM
Points: 668, Visits: 261
Thanks for the question.

Almost got it wrong when I read this from SQL Authority, Pinal Dave: "They can be used on Views only if they are persisted views."
- http://blog.sqlauthority.com/2008/09/01/sql-server-2008-introduction-to-filtered-index-improve-performance-with-filtered-index/

So I was wondering if there were 4 correct answers until I read in BOL, "You cannot create a filtered index on a view."
- http://technet.microsoft.com/en-us/library/cc280372.aspx
Post #1553492
Posted Friday, March 21, 2014 8:49 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
nice question..
Post #1553520
Posted Friday, March 21, 2014 9:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 1,003, Visits: 2,284
Ed Wagner (3/21/2014)
I love indexing questions. Good way to end the week.


+1


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1553536
Posted Friday, March 21, 2014 2:26 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:42 AM
Points: 3,014, Visits: 3,099
Nice question! I love filtered indexes. They are very useful for the data mining algorithms.

Thanks
Igor




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1553664
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse