<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
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
Content with tag
Administration
Refine your search with one of the following additional tags (with number of items):
SQL Server 7, 2000
(332)
Naming Standards
(4)
XML
(2)
OLAP Server
(1)
SQL Server 2005
(182)
routine database growth
(4)
2005 Compact Edition
(1)
OpenXML
(1)
T-SQL
(92)
routine growth
(4)
Aggregates
(1)
Operations Manager
(1)
Configuring
(63)
SQL Server
(4)
ALTER DATABASE
(1)
Other
(1)
Miscellaneous
(55)
sys.allocation_units
(4)
Analysis Services (SSAS)
(1)
parallelism
(1)
Security
(44)
System Development Life Cycle
(4)
Architecture
(1)
Partitioning
(1)
Performance Tuning
(39)
Transaction Log
(4)
Best Practices
(1)
Passwords
(1)
Strategies
(36)
Triggers
(4)
Bugs
(1)
PBM
(1)
Monitoring
(33)
Blogs
(3)
CheckDB
(1)
Performance
(1)
Programming
(32)
Distributed Queries
(3)
Cleanup
(1)
powershell
(1)
Maintenance and Management
(27)
Editorial - iPod
(3)
CLR functions
(1)
process
(1)
Utility
(25)
Editorial - WMV
(3)
CLR Stored Procedures
(1)
PUBLIC
(1)
Backup and Recovery
(24)
Permissions
(3)
CLR UDT
(1)
Query Optimization
(1)
SQL Server 6.5
(24)
Role
(3)
Clustering
(1)
Rants
(1)
Maintenance
(20)
Service Packs
(3)
Column Permissions
(1)
recent backups
(1)
Reporting Services (SSRS)
(16)
Space Usage
(3)
Common Language Runtime (CLR)
(1)
report
(1)
Stored Procedures
(16)
SQL Server 2008
(3)
copy_only
(1)
Running aggregate
(1)
T-SQL Aids
(16)
State of the Business
(3)
data
(1)
Running Totals
(1)
Indexing
(15)
Troubleshooting
(3)
Data and Log file Usage for a DB
(1)
Scalability
(1)
Advanced Querying
(14)
Administrator
(2)
Data Types
(1)
script
(1)
Database Design
(14)
Advanced
(2)
database size
(1)
scripting
(1)
Admin
(13)
attach
(2)
Databases
(1)
Selectivity
(1)
Basic Querying
(13)
Audit
(2)
DBA
(1)
SMO
(1)
Installation
(13)
Auditing
(2)
DDL
(1)
space used
(1)
Disaster Recovery
(12)
Automation
(2)
Declarative Management Framework (DMF)
(1)
SQL Agent
(1)
Index Management
(12)
Buffer Cache
(2)
disk space
(1)
SQL Permissions
(1)
Visual Basic 6
(12)
Capacity planning
(2)
Duplicate Indexes
(1)
SQL Server 2005 - Security
(1)
Replication
(10)
column
(2)
English Query
(1)
SQL Server 2005 - SSIS
(1)
DTS
(9)
detach
(2)
Error Logs
(1)
SQL Server Express
(1)
Indexes
(9)
DMV
(2)
Excel
(1)
SQL Server Management Studio (SSMS)
(1)
Search
(9)
Editorial - MP3
(2)
Extended Stored Procedures
(1)
SQLServerCentral
(1)
SQL-DMO
(8)
GRANT
(2)
FileGroup
(1)
statistics
(1)
Storage
(8)
Index Usage
(2)
Files and Filegroups
(1)
String Manipulation
(1)
tables
(8)
Jobs
(2)
foreign key constraints
(1)
Syntax Check
(1)
automated DBA
(7)
Lock and Connection Management
(2)
foreign keys
(1)
sys.dm_db_index_usage_stats
(1)
Best and Worst Practices
(7)
Logins
(2)
growth trend
(1)
sys.dm_db_missing_index_details
(1)
Development
(7)
Maintenance Plans
(2)
High Availability
(1)
sys.dm_exec_connections
(1)
News
(7)
Miscellaneous
(2)
Index Tuning
(1)
sys.dm_exec_cursors
(1)
sys.dm_db_partition_stats
(7)
Performance Monitoring
(2)
Indexed Views
(1)
sys.dm_tran_session_transactions
(1)
Availability
(6)
Policy Based Management
(2)
INFORMATION_SCHEMA
(1)
sys.foreign_key_columns
(1)
Worst Practices
(6)
Product Reviews
(2)
kill
(1)
sys.foreign_keys
(1)
ADO
(5)
Profiler
(2)
kill sessions
(1)
sys.sql_modules
(1)
Backup
(5)
Restore
(2)
Locking
(1)
System databases
(1)
List Indexes
(5)
Reviews
(2)
Management
(1)
System Tables
(1)
pivot
(5)
Shrinking Databases
(2)
Management Studio
(1)
Table Valued Function
(1)
.Net
(4)
SQL Puzzles
(2)
MAXDOP
(1)
telecommuting
(1)
auto-growth
(4)
Storage Management
(2)
Memory
(1)
trace
(1)
Backup / Restore
(4)
sys.dm_exec_query_plan
(2)
MemToLeave
(1)
TSQL
(1)
Basics
(4)
sys.dm_exec_requests
(2)
mirror
(1)
UpdateGrams
(1)
Career
(4)
sys.dm_exec_sessions
(2)
Missing Indexes
(1)
uptime
(1)
Crosstab
(4)
sys.dm_exec_sql_text
(2)
move
(1)
User
(1)
data file management
(4)
sys.dm_os_buffer_descriptors
(2)
multi process
(1)
Virtualization
(1)
Data Warehousing
(4)
sys.partitions
(2)
Normalization
(1)
Warehouse
(1)
Editorial
(4)
User Defined Function (UDF)
(2)
Object Permissions
(1)
XSL
(1)
FOR XML PATH
(4)
Video
(2)
Items 1 to 20 of 994
Next 20 >>
Time and date since your sql services has started
A script to find the time and date since your sql services has started
Read more...
By
Tushar Kudalkar
2009/11/23
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
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,093 reads
View Errors in the Default Trace
Returns records with errors from the default trace ordered by most recent first
Read more...
By
Jon Morisi
2009/11/12
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3 reads
Wait for Mirror treshold
This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.
Read more...
By
Wilfred van Dijk
2009/11/10
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3 reads
Custom cleanup procedure for backup files
There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.
Read more...
By
Roshan Joe Joseph
2009/11/05
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
339 reads
How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
Read more...
By
Rudy Panigas
2009/11/03
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
12,150 reads
Just For Fun: An Impossible Delete
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
Read more...
By
RBarry Young
2009/10/30 (first published: 2008/08/05)
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
30,070 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
SQL Server 2005 Build List
Build List Updated with Cumulative Update 16 for SP2 and CU 6 for SP3.
Read more...
By
Steve Jones
2009/10/26 (first published: 2007/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
79,190 reads
The Ultimate Connection Summarizer and Trouble Finder
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
Lock and Connection Management
Rating:
|
Discuss
|
Briefcase
|
4,373 reads
The Ultimate Table Searcher Mk2
Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.
Read more...
By
Jesse Roberge
2009/10/20
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
701 reads
The Ultimate Column Searcher
Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.
Read more...
By
Jesse Roberge
2009/10/16
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,079 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 Table Searcher
Searches for tables who's names contain the search string. Gives Size and Rows information as well.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
1,932 reads
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
1,775 reads
CLR Execution
Read more...
By
Britt Cluff
2009/10/12
|
Category:
Common Language Runtime (CLR)
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,464 reads
Find SQL Server Error Log Path
Script to Find SQL Server Error Log Path
Read more...
By
Vijendran R
2009/10/09
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
386 reads
The Ultimate Precompiled Procedure Searcher
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
1,595 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
The Ultimate PK-Less / CLIDX-Less Table Finder
Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.
Read more...
By
Jesse Roberge
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
918 reads
Items 1 to 20 of 994
Next 20 >>
Most popular
How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
Read more...
By
Rudy Panigas
2009/11/03
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
12,150 reads
What SQL Statements Are Currently Executing?
This article describes a utility that allows you to identify what SQL statements are currently executing.
Read more...
By
Ian Stirk
2008/10/28
|
Source:
SQLServerCentral.com
|
Category:
DMV
Rating:
|
Discuss
|
Briefcase
|
28,206 reads
Just For Fun: An Impossible Delete
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
Read more...
By
RBarry Young
2009/10/30 (first published: 2008/08/05)
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
30,070 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
