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: 2 days ago @ 6:38 AM
Points: 2,782, Visits: 2,159
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:27 AM
Points: 14,449, Visits: 12,441
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:50 AM
Points: 2,856, Visits: 2,731
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: Yesterday @ 5:42 PM
Points: 5,964, Visits: 5,389
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: Wednesday, June 10, 2015 6:00 AM
Points: 2,834, Visits: 161
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: Yesterday @ 12:27 PM
Points: 894, Visits: 362
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 @ 3:46 AM
Points: 1,290, Visits: 2,727
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 @ 3:03 AM
Points: 3,374, Visits: 3,628
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