Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
SQL Server 2005
Refine your search with one of the following additional tags (with number of items):
T-SQL
(38)
Backup
(2)
Database Files
(1)
Puzzle
(1)
Administration
(37)
Backup / Restore
(2)
database options administration
(1)
Queries
(1)
Maintenance and Management
(27)
BCP
(2)
Database Roles
(1)
quotename
(1)
T-SQL Aids
(25)
Buffer Cache
(2)
database size
(1)
Random Numbers
(1)
Utility
(21)
data file management
(2)
DBCC
(1)
Reindex
(1)
Maintenance
(20)
Fragmentation
(2)
DDL Triggers
(1)
Restore
(1)
SQL Server 7, 2000
(15)
games
(2)
Defragment
(1)
Running aggregate
(1)
Index Management
(14)
Index Usage
(2)
Dependencies
(1)
Running Totals
(1)
Indexes
(13)
Jobs
(2)
DM_DB_Index_Physical_Stats
(1)
Schema
(1)
Miscellaneous
(13)
Linked Server
(2)
DROP
(1)
script
(1)
Indexing
(11)
Lock and Connection Management
(2)
dump
(1)
Selectivity
(1)
Performance Tuning
(11)
Monitoring
(2)
Duplicate Indexes
(1)
setup
(1)
Advanced Querying
(8)
report
(2)
dynamic
(1)
shrink
(1)
Development
(8)
routine database growth
(2)
ETL
(1)
shrinkdatabase
(1)
Search
(8)
routine growth
(2)
Files and Filegroups
(1)
SHRINKFILE
(1)
Admin
(7)
SQL Agent
(2)
Foreign Key
(1)
sieve
(1)
nums
(7)
SQL Server 2008
(2)
foreign key constraints
(1)
Size estimation
(1)
SQLInsider Scripts
(7)
Stored Procedures
(2)
foreign keys
(1)
sp_msforeachdb
(1)
sys.dm_db_partition_stats
(7)
sys.dm_exec_query_plan
(2)
Growth
(1)
sp_spaceused
(1)
Table of Numbers
(7)
sys.dm_exec_requests
(2)
growth trend
(1)
SQL Server 2000
(1)
tables
(7)
sys.dm_exec_sessions
(2)
index maintenance
(1)
status
(1)
tally
(7)
sys.dm_exec_sql_text
(2)
Index Tuning
(1)
sybase linked server
(1)
counter
(6)
sys.dm_os_buffer_descriptors
(2)
Indexed Views
(1)
sys.columns
(1)
parse
(6)
sys.partitions
(2)
Information
(1)
sys.dm_db_index_usage_stats
(1)
pivot
(6)
Troubleshooting
(2)
Integration Services (SSIS)
(1)
sys.dm_db_missing_index_details
(1)
Storage
(6)
Aggregates
(1)
like
(1)
sys.dm_exec_connections
(1)
Arrays
(5)
ASCII
(1)
Log directory
(1)
sys.dm_exec_cursors
(1)
automated DBA
(5)
automatic
(1)
log file
(1)
sys.dm_tran_session_transactions
(1)
Crosstab
(5)
Backup directory
(1)
Log path
(1)
sys.foreign_key_columns
(1)
Delimited Strings
(5)
Backup path
(1)
Logins
(1)
sys.foreign_keys
(1)
List Indexes
(5)
bulk insert
(1)
Metadata
(1)
sys.sql_modules
(1)
Security
(5)
CLR functions
(1)
Missing Indexes
(1)
sys.systypes
(1)
String Manipulation
(5)
CLR Stored Procedures
(1)
Partitioning
(1)
sys.tables
(1)
FOR XML PATH
(4)
CLR UDT
(1)
Passwords
(1)
Sysobjects
(1)
index
(4)
Clustering
(1)
Performance
(1)
Table
(1)
Management
(4)
column
(1)
Permissions
(1)
Table search
(1)
sys.allocation_units
(4)
columns
(1)
prime
(1)
TSQL
(1)
Space Usage
(3)
Data directory
(1)
prime number
(1)
whitespace
(1)
2-Dimensional Arrays
(2)
Data path
(1)
Procedure
(1)
XML
(1)
auto-growth
(2)
Data Types
(1)
Search for
any
content tagged
SQL Server 2005
Add a script
Items 1 to 20 of 103
Next 20 >>
SQL Server 2005 - Work with Flat Files
It's a scripts about working with Flat Files
Read more...
By
Luan Moreno M. Maciel
2009/11/03
|
Source:
SQLServerCentral.com
|
Category:
ETL
Rating:
|
Discuss
|
Briefcase
|
911 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
|
516 reads
The Ultimate Object Searcher
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.
Read more...
By
Jesse Roberge
2009/10/06
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
600 reads
Automatic Generation of Insert, Update and Delete stored procedures
This script automatically generates stored procedures for insert, update and delete operations on the given table
Read more...
By
Samardeep Khera
2009/08/12
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
1,007 reads
Search for a Table in all databases
This Script can be used for searching a Table in SQL server 2005
Read more...
By
Sandesh Segu
2009/08/04
|
Source:
SQLServerCentral.com
|
Category:
Table search
Rating:
|
Discuss
|
Briefcase
|
697 reads
Get DDL for any SQL 2005 table
returns CREATE TABLE script for any table. including schema name,calculated columns, indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.
Read more...
By
Lowell Izaguirre
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
76 reads
Sybase linked server in sql 2005
How to create and configure Sybase linked server in SQL Server 2005
Read more...
By
umar iqbal
2009/07/21
|
Source:
SQLServerCentral.com
|
Category:
Linked Server
Rating:
|
Discuss
|
Briefcase
|
275 reads
Table Index Store and Create
Query to save all index metadata
Read more...
By
Jorge Novo-396570
2009/07/17
|
Source:
SQLServerCentral.com
|
Category:
Indexes
Rating:
|
Discuss
|
Briefcase
|
425 reads
Three Sample reports for the Automated DBA: Space Usage SnapShotter
1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot
Read more...
By
Jesse Roberge
2009/07/13
|
Source:
SQLServerCentral.com
|
Category:
Admin
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,157 reads
Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
Read more...
By
Jesse Roberge
2009/07/15
|
Source:
SQLServerCentral.com
|
Category:
Advanced Querying
Rating:
|
Discuss
|
Briefcase
|
808 reads
The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
Read more...
By
Jesse Roberge
2009/06/22
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
516 reads
The Automated DBA: Batch Database File Grower - SQL 2005 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
Read more...
By
Jesse Roberge
2009/06/23
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
556 reads
The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)
Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.
Read more...
By
Jesse Roberge
2009/06/15
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
660 reads
The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)
Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.
Read more...
By
Jesse Roberge
2009/06/17
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,083 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
|
598 reads
The Ultimate Running Requests Reporter
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
2,324 reads
Table size estimation (MS SQL 2005)
Procedure to estimate table size in accordance with http://msdn.microsoft.com/en-us/library/ms187445(SQL.90).aspx
Read more...
By
Igor Nikitin
2009/05/20
|
Source:
SQLServerCentral.com
|
Category:
Size estimation
Rating:
|
Discuss
|
Briefcase
|
928 reads
usp_PartitionDatabase
Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.
Read more...
By
Pedro Lopes-389536
2009/05/12
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
609 reads
Cluster Information
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
Read more...
By
Rudy Panigas
2009/05/08
|
Source:
SQLServerCentral.com
|
Category:
Clustering
Rating:
|
Discuss
|
Briefcase
|
496 reads
What SQL JOb's are running on 2005 Server
This script returns the information of all SQL Jobs that are running on the server with the latest status.
Read more...
By
Sreedhar Kantae
2009/05/01
|
Source:
SQLServerCentral.com
|
Category:
Jobs
Rating:
|
Discuss
|
Briefcase
|
860 reads
Items 1 to 20 of 103
Next 20 >>
Most popular
SQL Server 2005 & 2008 - Backup, Integrity Check & Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005 and SQL Server 2008. Updated 05 Sep 2009.
Read more...
By
Ola Hallengren
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
22,098 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
|
10,648 reads
The Ultimate Running Requests Reporter
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
2,324 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use