<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tags
Indexing
,
T-SQL
Items 1 to 20 of 33
Next 20 >>
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
|
32,079 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
Read more...
By
Boka
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
4,073 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
3,681 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
|
1,972 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
3,885 reads
Creating indexes on computed columns
Read more...
By
Manie Verster
2010/09/30
|
Category:
computed column
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,730 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
|
32,079 reads
Clustered indexes
Read more...
By
Hugo Kornelis
2010/05/06
|
Category:
indexing
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,910 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
3,885 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,285 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,532 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,177 reads
Unique constraints
Read more...
By
ARUN SAS
2009/07/29
|
Category:
indexing
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,241 reads
view, index and schemabinding!
Read more...
By
VM-723206
2009/06/29
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,916 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
|
811 reads
SQL 2008 Indexes
Read more...
By
SA-1
2009/02/03
|
Category:
indexing
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,207 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,555 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
|
1,994 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,732 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:
indexing
Rating:
|
Discuss
|
Briefcase
|
6,025 reads
Items 1 to 20 of 33
Next 20 >>
Tags
performance tuning
(15)
administration
(13)
sql server 2005
(10)
t-sql aids
(9)
utility
(9)
maintenance
(8)
maintenance and management
(8)
sql server 7
(6)
list indexes
(5)
miscellaneous
(5)
pivot
(5)
sys.dm_db_partition_stats
(5)
configuring
(4)
crosstab
(4)
for xml path
(4)
backup / restore
(3)
foreign keys (fk)
(3)
xml
(3)
dts
(2)
installation
(2)
security
(2)
stored procedures
(2)
strategies
(2)
triggers
(2)
user defined function (udf)
(2)
automation
(1)
check constraint
(1)
computed column
(1)
create
(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)
performance
(1)
performance and tuning
(1)
primary key (pk)
(1)
programming
(1)
replication
(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)
updategrams
(1)
xsl
(1)
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
