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: Tuesday, July 14, 2015 4:43 AM
Points: 2,793, Visits: 2,163
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: 2 days ago @ 9:12 AM
Points: 14,608, Visits: 12,669
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 SQLKover.

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: 2 days ago @ 2:11 AM
Points: 2,909, Visits: 2,787
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 @ 12:39 PM
Points: 6,396, Visits: 5,836
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: Tuesday, August 4, 2015 2:09 AM
Points: 2,880, Visits: 164
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: Wednesday, June 24, 2015 5:03 PM
Points: 2,106, Visits: 2,251
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: 2 days ago @ 8:58 AM
Points: 942, Visits: 373
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: Monday, August 17, 2015 1:50 PM
Points: 2,077, Visits: 601
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: Tuesday, August 4, 2015 9:45 AM
Points: 1,319, Visits: 2,736
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: Thursday, August 13, 2015 3:23 PM
Points: 3,427, Visits: 3,696
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