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: Friday, March 20, 2015 5:52 AM
Points: 2,643, Visits: 2,070
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 @ 2:07 PM
Points: 14,159, Visits: 12,132
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 @ 9:01 AM
Points: 2,748, Visits: 2,604
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
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:39 PM
Points: 5,168, Visits: 4,633
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: 2 days ago @ 10:34 AM
Points: 2,737, Visits: 153
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, March 8, 2015 4:47 PM
Points: 2,013, Visits: 2,242
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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, March 23, 2015 7:26 AM
Points: 811, Visits: 322
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 13, 2015 12:40 PM
Points: 2,070, Visits: 595
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 @ 8:35 AM
Points: 1,199, Visits: 2,632
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: Today @ 1:41 PM
Points: 3,257, Visits: 3,449
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