Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tags
Indexing
,
T-SQL
Items 1 to 20 of 21
Next 20 >>
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,001 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
|
9,782 reads
Unique constraints
Read more...
By
ARUN SAS
2009/07/29
|
Category:
indexing
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,970 reads
view, index and schemabinding!
Read more...
By
VM-723206
2009/06/29
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,679 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
|
664 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
2009/01/28
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,283 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:
index management
Rating:
|
Discuss
|
Briefcase
|
1,861 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:
index management
Rating:
|
Discuss
|
Briefcase
|
2,346 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
2008/10/13
|
Source:
SQLServerCentral.com
|
Category:
index management
Rating:
|
Discuss
|
Briefcase
|
5,059 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:
index management
Rating:
|
Discuss
|
Briefcase
|
1,924 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
2008/10/07
|
Source:
SQLServerCentral.com
|
Category:
index management
Rating:
|
Discuss
|
Briefcase
|
2,393 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
2008/10/06
|
Source:
SQLServerCentral.com
|
Category:
index management
Rating:
|
Discuss
|
Briefcase
|
12,230 reads
XML Index
Checking XML indexs with a sample.
Read more...
By
SQL Species
2008/09/19
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
791 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
2008/07/09
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
2,160 reads
SQL Maintenance Plans
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
Read more...
By
Andy Warren
2005/03/04 (first published: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
32,416 reads
Review of SQL 2000 Fast Answers
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
Read more...
By
Andy Warren
2003/04/18
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
|
Discuss
|
Briefcase
|
18,160 reads
Cluster That Index!
Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.
Read more...
By
Christoffer Hedgate
2003/03/30
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
16,394 reads
Analyzing and Optimizing T-SQL Query Performance on SQL Server
This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes
Read more...
By
Additional Articles
2003/03/14
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
2,049 reads
Review of SQL Server 2000 Programming (MSPress)
Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!
Read more...
By
Andy Warren
2002/06/04
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
6,396 reads
SQL Maintenance Plans - Under the Covers!
In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!
Read more...
By
Andy Warren
2002/05/21
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
8,593 reads
Items 1 to 20 of 21
Next 20 >>
Tags
performance tuning
(13)
administration
(12)
sql server 2005
(9)
indexes
(8)
t-sql aids
(8)
utility
(8)
index management
(7)
maintenance
(7)
maintenance and management
(7)
sql server 7, 2000
(6)
list indexes
(5)
miscellaneous
(5)
pivot
(5)
sys.dm_db_partition_stats
(5)
configuring
(4)
crosstab
(4)
for xml path
(4)
backup and recovery
(3)
basic querying
(2)
dts
(2)
index usage
(2)
installation
(2)
security
(2)
stored procedures
(2)
strategies
(2)
triggers
(2)
user defined function (udf)
(2)
xml
(2)
deadlock
(1)
distributed queries
(1)
dm_db_index_physical_stats
(1)
duplicate indexes
(1)
english query
(1)
foreign key
(1)
index tuning
(1)
missing indexes
(1)
monitoring
(1)
openxml
(1)
programming
(1)
replication
(1)
selectivity
(1)
sys.dm_db_index_usage_stats
(1)
sys.dm_db_missing_index_details
(1)
updategrams
(1)
xsl
(1)
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use