SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, T-SQL Rss

   Items 1 to 20 of 135    Older >>
 

Creating XML Indexes

By Steve Jones 2018/07/20 | Category: create xml index
Rating: (not yet rated) |  Discuss |   Briefcase | 752 reads

Database creation settings

By Steve Jones 2018/05/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 899 reads

Password Policy

By Steve Jones 2016/12/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,035 reads

Let the shell free

By Steve Jones 2016/10/24 | Category: xp_cmdshell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,041 reads

Remove the Login Trigger

By Steve Jones 2016/10/20 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 1,112 reads

The security scheme

By Steve Jones 2016/01/26 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,401 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,602 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 13,970 reads

Global Configuration Settings

By Sean Smith 2013/08/30 | Category: sp_configure
Rating: (not yet rated) |  Discuss |   Briefcase | 2,495 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,258 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 2013/07/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,703 reads

Change Tracking

By Naseer Ahmad 2013/07/10 | Category: change tracking
Rating: (not yet rated) |  Discuss |   Briefcase | 2,596 reads

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist  Read more...
By Wilfred van Dijk 2013/07/09 | Category: t-sql
Rating: |  Discuss |   Briefcase | 932 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 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 19,122 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,656 reads

Search for a String in all Stored Procedures and beyond?

Search for String Occurence with this script in your stored procedures.  Read more...
By Mani Singh 2011/10/20 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 4,966 reads

Verify a database backup using T-SQL

A script to verify a database backup using T-SQL code  Read more...
By Nakul Vachhrajani 2011/07/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,759 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,197 reads

Parameterization Settings

By Steve Jones 2011/05/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,045 reads

Making a more reliable and flexible sp_MSforeachdb

While the system procedure sp_MSforeachdb is neither documented nor officially supported, most SQL Server professionals have used it at one time or another. This is typically for ad hoc maintenance tasks, but many people (myself included) have used this type of looping activity in permanent routines. Sadly, I have discovered instances where, under heavy load and/or with a large number of databases, the procedure can actually skip multiple catalogs with no error or warning message. Since this situation is not easily reproducible, and since Microsoft typically has no interest in fixing unsupported objects, this may be happening in your environment right now  Read more...
By Additional Articles 2011/01/18 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 3,517 reads
   Items 1 to 20 of 135    Older >>
 
Tags
sql server 7 (56)    
miscellaneous (26)    
maintenance and management (25)    
sql server 2005 (25)    
utility (25)    
maintenance (19)    
performance tuning (18)    
advanced querying (15)    
indexing (14)    
configuring (13)    
stored procedures (13)    
programming (11)    
strategies (10)    
monitoring (9)    
search (9)    
security (8)    
automated dba (7)    
storage (7)    
sys.dm_db_partition_stats (7)    
tables (7)    
backup and restore (6)    
database design (6)    
list indexes (5)    
pivot (5)    
auto-growth (4)    
crosstab (4)    
data file management (4)    
for xml path (4)    
installation (4)    
routine database growth (4)    
routine growth (4)    
sys.allocation_units (4)    
triggers (4)    
visual basic 6 (4)    
dts (3)    
permissions (3)    
space usage (3)    
sql-dmo (3)    
administrator (2)    
buffer cache (2)    
columns (2)    
grant (2)    
lock and connection management (2)    
naming standards (2)    
script (2)    
sql puzzles (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)    
troubleshooting (2)    
user defined function (udf) (2)    
.net (1)    
aggregates (1)    
basics (1)    
best and worst practices (1)    
change tracking (1)    
configuration (1)    
connectivity (1)    
create xml index (1)    
database mirroring (1)    
databases (1)    
dba (1)    
development (1)    
diagnostic (1)    
distributed queries (1)    
duplicate indexes (1)    
english query (1)    
extended stored procedures (1)    
filegroups (1)    
foreign keys (fk) (1)    
growth trend (1)    
indexed views (1)    
linked servers (1)    
locking (1)    
logins (1)    
logon triggers (1)    
missing indexes (1)    
multi process (1)    
object permissions (1)    
openxml (1)    
passwords (1)    
product reviews (1)    
public (1)    
replication (1)    
report (1)    
reviews (1)    
role (1)    
running aggregate (1)    
running totals (1)    
scripting (1)    
selectivity (1)    
service packs (1)    
sp_configure (1)    
sql server 2008 (1)    
sql server 6.5 (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)    
system development life cycle (1)    
updategrams (1)    
user (1)    
worst practices (1)    
xml (1)    
xp_cmdshell (1)    
xsl (1)