Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag maintenance and management Rss

<< Newer    Items 21 to 40 of 839    Older >>
 

Table row count using 3 different ways

Three different ways that you can get the count of the rows in a table.  Read more...
By Mohit Nayyar 2011/06/16 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,414 reads

Get all user def table info

Get space for all user defined table information like size and row counts.  Read more...
By Mohit Nayyar 2013/12/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,293 reads

Database Management for SharePoint 2010

With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There are advantages to this: SharePoint can make use of mirroring, data-compression and remote BLOB storage. It can employ advanced tools such as data file compression, and object-level restore. DBAs can employ familiar techniques to speed SharePoint applications. Bert explains the way that SharePoint and SQL Server interact.   Read more...
By Additional Articles 2011/05/18 | Source: SimpleTalk | Category: sharepoint
Rating:  Rate this |   Briefcase | 2,743 reads

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,371 reads

Data Dictionary using sys.objects - SQL 2008

Create a data dictionary with two stored procedures using sys objects to view via SSRS (or other reporting tool) report  Read more...
By sqldummy79 2010/10/21 | Source: SQLServerCentral.com | Category: maintenance and management
Rating: (not yet rated) |  Discuss |   Briefcase | 2,006 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 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,494 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: administration
Rating: |  Discuss |   Briefcase | 2,708 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 | 645 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 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,494 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 | 5,648 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 | 840 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,331 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 | 1,296 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 2009/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,190 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 2009/10/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,435 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 2009/10/08 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,834 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 | 1,081 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 2009/10/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,090 reads

Shrink Log File to Target Percentage

Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.  Read more...
By Tommy Bollhofer 2009/09/23 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 1,944 reads

Shrink Log File to Target Percentage

Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.  Read more...
By Tommy Bollhofer 2009/09/23 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 1,944 reads
<< Newer    Items 21 to 40 of 839    Older >>
 
Tags
miscellaneous (333)    
t-sql (237)    
sqlinsider scripts (87)    
backup / restore (86)    
indexing (62)    
lock and connection management (36)    
administration (29)    
data warehousing (29)    
sql server 2005 (26)    
utility (23)    
maintenance (20)    
replication (16)    
mail (15)    
performance tuning (10)    
search (8)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
tables (6)    
list indexes (5)    
pivot (5)    
auto-growth (4)    
crosstab (4)    
data file management (4)    
for xml path (4)    
routine database growth (4)    
routine growth (4)    
sys.allocation_units (4)    
space usage (3)    
sql server 7 (3)    
troubleshooting (3)    
buffer cache (2)    
stored procedures (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
sys.dm_os_buffer_descriptors (2)    
sys.partitions (2)    
advanced querying (1)    
aggregates (1)    
backup / recovery (1)    
blogs (1)    
columns (1)    
dba (1)    
defragmentation (1)    
directory (1)    
duplicate indexes (1)    
file size (1)    
foreign keys (fk) (1)    
generate job schedules (1)    
growth trend (1)    
identity property (1)    
indexed views (1)    
job history (1)    
job schedule (1)    
jobs (1)    
log file maintenance (1)    
management (1)    
missing indexes (1)    
report (1)    
running aggregate (1)    
running totals (1)    
selectivity (1)    
sharepoint (1)    
sql server 2008 (1)    
sql server express (1)    
sqlclr (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_tran_session_transactions (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.sql_modules (1)    
xp_cmdshell (1)