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
Items 1 to 20 of 2223
Next 20 >>
Credit Card Number Validation Escalar Function
Evaluate credit card numbers based on ISO 2894 algorithm.
Read more...
By
thor the viking
2010/03/24
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
37 reads
Index usage overview
This view reports almost everything you want to know about your indexes
Read more...
By
Wilfred van Dijk
2010/03/23
|
Source:
SQLServerCentral.com
|
Category:
index
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
210 reads
Password to Phonetics converter script
This script will display phonetics for a given password
Read more...
By
Vijay Anisetti
2010/03/22
|
Source:
SQLServerCentral.com
|
Category:
phonetics
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
79 reads
Check status of HEAP tables
This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!
Read more...
By
Wilfred van Dijk
2010/03/18
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
547 reads
Truncate Table Partition command in SQL Server
This script helps with the truncate Table Partition command in SQL Server
Read more...
By
Adeoye Omoboya
2010/03/19
|
Source:
SQLServerCentral.com
|
Category:
partition
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
308 reads
Automated T-Log Restore
Sequential transaction log restore
Read more...
By
Tony Savoie
2010/03/15
|
Source:
SQLServerCentral.com
|
Category:
t-log
Rating:
|
Discuss
|
Briefcase
|
503 reads
EXECute SQL Commands over entire sets of parameters!
A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.
Read more...
By
RBarry Young
2010/03/16
|
Source:
SQLServerCentral.com
|
Category:
admin
Rating:
|
Discuss
|
Briefcase
|
1,112 reads
Script to check current identity of Tables
Used to check all current identities on all user tables
Read more...
By
Sean Kotze
2010/03/17
|
Source:
SQLServerCentral.com
|
Category:
identity
Rating:
|
Discuss
|
Briefcase
|
622 reads
Rebuild partition
Rebuilds online a table partition with all indexes
Read more...
By
fediori
2010/03/12
|
Source:
SQLServerCentral.com
|
Category:
rebuild
Rating:
|
Discuss
|
Briefcase
|
481 reads
Clustered Index Analyser
Analysing clustered indexes on user tables by looking at the columns that comprise them
Read more...
By
Cameron Wells
2010/03/11
|
Source:
SQLServerCentral.com
|
Category:
indexing
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
983 reads
Backup or Restore progess
This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.
Read more...
By
Purushotham Kumar Katakam
2010/03/05
|
Source:
SQLServerCentral.com
|
Category:
backup/ restore
Rating:
|
Discuss
|
Briefcase
|
723 reads
ServerProperty query with case function
Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition.
Read more...
By
Jon McGhee
2010/03/08
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
537 reads
Unused Objects in the Server
This Script is used to List out the objects lying in the box which were un used from the day of the sql server recycled.
Read more...
By
Purushotham Kumar Katakam
2010/03/09
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
888 reads
Track database growth
Script to keep track your database growth - Works with SQL 2000, 2005 & 2008
Read more...
By
Irwan Tjanterik
2010/03/10
|
Source:
SQLServerCentral.com
|
Category:
database growth
Rating:
|
Discuss
|
Briefcase
|
1,687 reads
Retrieve numbers from a string
This function will take a string parameter and find all numbers in it.
Read more...
By
Boyd Tyrrell
2010/03/04
|
Source:
SQLServerCentral.com
|
Category:
string manipulation
Rating:
|
Discuss
|
Briefcase
|
1,279 reads
SQL Server Access Restriction
Restrict Access to SQL by HostName, IP, Application Name, etc...
Read more...
By
Gregory Ferdinandsen
2010/03/03
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
1,015 reads
Missing PK and Clustered indexes
This script will find missing PK and Clustered indexes Script or Heap Tables
Read more...
By
G T
2010/02/25
|
Source:
SQLServerCentral.com
|
Category:
clustered indexes
Rating:
|
Discuss
|
Briefcase
|
854 reads
Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
Read more...
By
Vidyadhar Pandekar
2010/02/24
|
Source:
SQLServerCentral.com
|
Category:
change foreign key name
Rating:
|
Discuss
|
Briefcase
|
700 reads
Changing Primary key names to standard naming convention across the DB
This script will rename the Primary keys to standard notation - PK_TableName
Read more...
By
Vidyadhar Pandekar
2010/02/26
|
Source:
SQLServerCentral.com
|
Category:
rename primary key
Rating:
|
Discuss
|
Briefcase
|
754 reads
Serial ID Auto Generation
Scripts used to create the functionality to auto-generate your very own customized serial IDs.
Read more...
By
Larry Sumuri
2010/02/22
|
Source:
SQLServerCentral.com
|
Category:
serial id
Rating:
|
Discuss
|
Briefcase
|
1,037 reads
Items 1 to 20 of 2223
Next 20 >>
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use