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 79    Older >>
 

Secondary XML Indexes

By Steve Jones 2015/03/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,316 reads

XML Indexes

By Steve Jones 2015/03/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,371 reads

Index Behaviour

By Shiva N (Virtusa) 2014/11/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,907 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Redgate | Category: tips
Rating:  Rate this |   Briefcase | 15,896 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,351 reads

Order My Data

By Steve Jacobs 2013/12/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,885 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Redgate | Category: tips
Rating:  Rate this |   Briefcase | 15,896 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

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

Indexing in views

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

Use of Key Column

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

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,796 reads

Clustered Index

By demonfox 2013/03/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,282 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,771 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,527 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,622 reads

Altering a Column

By Andre Guerreiro Neto 2012/04/25 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 3,443 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

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,698 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,180 reads
   Items 1 to 20 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)