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

   Items 1 to 20 of 73    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,322 reads

Order My Data

By Steve Jacobs 2013/12/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,813 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,561 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,193 reads

Indexing in views

By Kapil Singh 2013/07/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,290 reads

Use of Key Column

By Bilal Mahmood 2013/05/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,068 reads

Clustered Index

By demonfox 2013/03/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,243 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 | 18,525 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,450 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,545 reads

Altering a Column

By Andre Guerreiro Neto 2012/04/25 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 3,360 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,659 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,638 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 | 4,118 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 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,322 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,238 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,317 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,659 reads

Clustered indexes

By Hugo Kornelis 2010/05/06 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 4,004 reads
   Items 1 to 20 of 73    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)    
configuring (4)    
crosstab (4)    
for xml path (4)    
foreign keys (fk) (3)    
xml (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 constraint (1)    
computed columns (1)    
create (1)    
create index (1)    
data warehousing (1)    
deadlock (1)    
distributed queries (1)    
dm_db_index_physical_stats (1)    
duplicate indexes (1)    
english query (1)    
execute (1)    
missing indexes (1)    
monitoring (1)    
openxml (1)    
primary key (pk) (1)    
programming (1)    
scripting (1)    
search (1)    
selectivity (1)    
statistics (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
table (1)    
tables (1)    
unique (1)    
unique constraint (1)    
updategrams (1)    
xsl (1)