Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Indexing Rss

<< Newer    Items 21 to 40 of 79    Older >>
 

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,351 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,258 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,402 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,733 reads

Clustered indexes

By Hugo Kornelis 2010/05/06 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 4,013 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,402 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,386 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,740 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,320 reads

Unique constraints

By ARUN SAS 2009/07/29 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 4,320 reads

view, index and schemabinding!

By VM-723206 2009/06/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,986 reads

The Ultimate Dupe Finder & Performance Test Parameter Set Researcher

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!  Read more...
By Jesse Roberge 2009/05/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 873 reads

SQL 2008 Indexes

By SA-1 2009/02/03 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 4,289 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,217 reads

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.  Read more...
By Jesse Roberge 2008/10/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,070 reads

The Ultimate Duplicate Index Finder

Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.  Read more...
By Jesse Roberge 2008/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,997 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,525 reads

The Ultimate Index Lister (Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,417 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,582 reads
<< Newer    Items 21 to 40 of 79    Older >>
 
Tags
maintenance and management (24)    
miscellaneous (24)    
performance tuning (15)    
administration (13)    
sqlinsider scripts (11)    
sql server 2005 (10)    
utility (9)    
maintenance (8)    
sql server 7 (6)    
backup / restore (5)    
list indexes (5)    
pivot (5)    
sys.dm_db_partition_stats (5)    
xml (5)    
configuring (4)    
crosstab (4)    
for xml path (4)    
foreign keys (fk) (3)    
automation (2)    
dts (2)    
full-text search (2005) (2)    
installation (2)    
lock and connection management (2)    
replication (2)    
security (2)    
stored procedures (2)    
strategies (2)    
triggers (2)    
user defined function (udf) (2)    
alter column (1)    
alter table (1)    
check constraints (1)    
checksum (1)    
computed columns (1)    
create (1)    
create index (1)    
data warehousing (1)    
database design (1)    
database development (1)    
database performance (1)    
deadlock (1)    
distributed queries (1)    
dm_db_index_physical_stats (1)    
duplicate indexes (1)    
english query (1)    
execute (1)    
hashbytes (1)    
missing indexes (1)    
monitoring (1)    
openxml (1)    
orm (1)    
performance (1)    
primary key (pk) (1)    
programming (1)    
scripting (1)    
search (1)    
selectivity (1)    
sql server (1)    
statistics (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
table (1)    
tables (1)    
tips (1)    
unique (1)    
unique constraint (1)    
updategrams (1)    
xsl (1)