SQLServerCentral is supported by Red Gate Software Ltd.
 
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 Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 7, 2000 (332)     Naming Standards (4)     XML (2)     Object Permissions (1)    
SQL Server 2005 (182)     routine database growth (4)     2005 Compact Edition (1)     OLAP Server (1)    
T-SQL (92)     routine growth (4)     Aggregates (1)     OpenXML (1)    
Configuring (63)     SQL Server (4)     ALTER DATABASE (1)     Operations Manager (1)    
Miscellaneous (55)     sys.allocation_units (4)     Analysis Services (SSAS) (1)     Other (1)    
Security (44)     System Development Life Cycle (4)     Architecture (1)     parallelism (1)    
Performance Tuning (39)     Transaction Log (4)     Best Practices (1)     Partitioning (1)    
Strategies (36)     Triggers (4)     Bugs (1)     Passwords (1)    
Monitoring (33)     Blogs (3)     CheckDB (1)     PBM (1)    
Programming (32)     Distributed Queries (3)     Cleanup (1)     Performance (1)    
Maintenance and Management (27)     Editorial - iPod (3)     CLR functions (1)     powershell (1)    
Utility (25)     Editorial - WMV (3)     CLR Stored Procedures (1)     process (1)    
Backup and Recovery (24)     Permissions (3)     CLR UDT (1)     PUBLIC (1)    
SQL Server 6.5 (24)     Role (3)     Clustering (1)     Query Optimization (1)    
Maintenance (21)     Service Packs (3)     Column Permissions (1)     Rants (1)    
Reporting Services (SSRS) (16)     Space Usage (3)     Common Language Runtime (CLR) (1)     recent backups (1)    
Stored Procedures (16)     SQL Server 2008 (3)     copy_only (1)     report (1)    
T-SQL Aids (16)     State of the Business (3)     Custom index defragmentation (1)     Running aggregate (1)    
Indexing (15)     Troubleshooting (3)     data (1)     Running Totals (1)    
Advanced Querying (14)     Administrator (2)     Data and Log file Usage for a DB (1)     Scalability (1)    
Database Design (14)     Advanced (2)     Data Types (1)     script (1)    
Admin (13)     attach (2)     database size (1)     scripting (1)    
Basic Querying (13)     Audit (2)     Databases (1)     Selectivity (1)    
Installation (13)     Auditing (2)     DBA (1)     SMO (1)    
Disaster Recovery (12)     Automation (2)     DDL (1)     space used (1)    
Index Management (12)     Buffer Cache (2)     Declarative Management Framework (DMF) (1)     SQL Agent (1)    
Visual Basic 6 (12)     Capacity planning (2)     disk space (1)     SQL Permissions (1)    
Replication (10)     column (2)     Duplicate Indexes (1)     SQL Server 2005 - Security (1)    
DTS (9)     detach (2)     English Query (1)     SQL Server 2005 - SSIS (1)    
Indexes (9)     DMV (2)     Error Logs (1)     SQL Server Express (1)    
Search (9)     Editorial - MP3 (2)     Excel (1)     SQL Server Management Studio (SSMS) (1)    
SQL-DMO (8)     GRANT (2)     Extended Stored Procedures (1)     SQLServerCentral (1)    
Storage (8)     Index Usage (2)     FileGroup (1)     statistics (1)    
tables (8)     Jobs (2)     Files and Filegroups (1)     String Manipulation (1)    
automated DBA (7)     Lock and Connection Management (2)     foreign key constraints (1)     Syntax Check (1)    
Best and Worst Practices (7)     Logins (2)     foreign keys (1)     sys.dm_db_index_usage_stats (1)    
Development (7)     Maintenance Plans (2)     Fragmentation (1)     sys.dm_db_missing_index_details (1)    
News (7)     Miscellaneous (2)     growth trend (1)     sys.dm_exec_connections (1)    
sys.dm_db_partition_stats (7)     Performance Monitoring (2)     High Availability (1)     sys.dm_exec_cursors (1)    
Availability (6)     Policy Based Management (2)     Index Tuning (1)     sys.dm_tran_session_transactions (1)    
Worst Practices (6)     Product Reviews (2)     Indexed Views (1)     sys.foreign_key_columns (1)    
ADO (5)     Profiler (2)     INFORMATION_SCHEMA (1)     sys.foreign_keys (1)    
Backup (5)     Restore (2)     kill (1)     sys.sql_modules (1)    
List Indexes (5)     Reviews (2)     kill sessions (1)     System databases (1)    
pivot (5)     Shrink Database (2)     Locking (1)     System Tables (1)    
.Net (4)     SQL Puzzles (2)     Management (1)     Table Valued Function (1)    
auto-growth (4)     Storage Management (2)     Management Studio (1)     telecommuting (1)    
Backup / Restore (4)     sys.dm_exec_query_plan (2)     MAXDOP (1)     trace (1)    
Basics (4)     sys.dm_exec_requests (2)     Memory (1)     TSQL (1)    
Career (4)     sys.dm_exec_sessions (2)     MemToLeave (1)     UpdateGrams (1)    
Crosstab (4)     sys.dm_exec_sql_text (2)     mirror (1)     uptime (1)    
data file management (4)     sys.dm_os_buffer_descriptors (2)     Missing Indexes (1)     User (1)    
Data Warehousing (4)     sys.partitions (2)     move (1)     Virtualization (1)    
Editorial (4)     User Defined Function (UDF) (2)     multi process (1)     Warehouse (1)    
FOR XML PATH (4)     Video (2)     Normalization (1)     XSL (1)    
   Items 1 to 20 of 996    Next 20 >>
 

INDEX DEFRAGMENTATION SCRIPT

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.   Read more...
By MUTHUKKUMARAN KALIYAMOORTHY 2009/12/08 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 18 reads

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 | 6 reads

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 | 23,022 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: |  Discuss |  Briefcase | 345 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 | 173 reads

compatibility level

Read more...
By VM-723206 2009/11/10 | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 2,358 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 | 454 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 | 13,275 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,617 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,487 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,498 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,469 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 | 710 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,091 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 | 571 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,943 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,796 reads

CLR Execution

Read more...
By Britt Cluff 2009/10/12 | Category: Common Language Runtime (CLR)
Rating: (not yet rated) |  Discuss |  Briefcase | 2,552 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 | 422 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,603 reads
   Items 1 to 20 of 996    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 | 13,275 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,364 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,617 reads
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use