SQLServerCentral: Content tagged Indexing, T-SQL

Use of Key Column

By Bilal Mahmood 2013/05/28 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,762 reads

Clustered Index

By demonfox 2013/03/05 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,048 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns. Read more...

By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 17,689 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas. Read more...

By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 7,228 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters. Read more...

By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 1,277 reads

Altering a Column

By Andre Guerreiro Neto 2012/04/25 | Category: alter table

Rating: (not yet rated) |

Discuss |

Briefcase | 3,143 reads

Tips to optimize your SQL statements

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly. Read more...

By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning

Rating:

|

Discuss |

Briefcase | 40,317 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation. Read more...

By Boka 2012/01/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 4,463 reads

Index Fragmentation

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed. Read more...

By Sergio Govoni 2011/10/21 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 3,982 reads

Get all user def table info

Get space for all user defined table information like size and row counts. Read more...

By Mohit Nayyar 2011/06/06 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 6,743 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started. Read more...

By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,169 reads

Index Fragmentation Status (includes Partitioned Tables/Indexes)

This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup. Read more...

By Richard Doering 2010/12/16 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 4,161 reads

Creating indexes on computed columns

By Manie Verster 2010/09/30 | Category: computed column

Rating: (not yet rated) |

Discuss |

Briefcase | 2,840 reads

Tips to optimize your SQL statements

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly. Read more...

By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning

Rating:

|

Discuss |

Briefcase | 40,317 reads

Clustered indexes

By Hugo Kornelis 2010/05/06 | Category: indexing

Rating: (not yet rated) |

Discuss |

Briefcase | 3,977 reads

Index Fragmentation Status (includes Partitioned Tables/Indexes)

This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup. Read more...

By Richard Doering 2010/12/16 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 4,161 reads

Data searches that leverage existing indexes

Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on data searches, which leverage existing indexes, taking into account such features as noise words and thesaurus files. Read more...

By Additional Articles 2010/01/07 | Source: Database Journal | Category: indexing

Rating: (not yet rated) Rate this |

Briefcase | 2,350 reads

An Un-indexed Foreign Key Gotcha

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency. Read more...

By Alok Dwivedi 2009/11/09 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 10,650 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons. Read more...

By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 1,259 reads