SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

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)     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...
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

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