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

XML Indexes

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

Index Behaviour

By Shiva N (Virtusa) 2014/11/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,861 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: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,811 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,344 reads

Order My Data

By Steve Jacobs 2013/12/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,869 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: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,811 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,579 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,214 reads

Indexing in views

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

Use of Key Column

By Bilal Mahmood 2013/05/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,094 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,788 reads

Clustered Index

By demonfox 2013/03/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,275 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,708 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,508 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,593 reads

Altering a Column

By Andre Guerreiro Neto 2012/04/25 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 3,429 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,717 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,683 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,165 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,344 reads
   Items 1 to 20 of 78    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)    
xml (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 constraint (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)