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


 

Content with tag administration Rss

<< Previous 20    Items 41 to 60 of 1409    Next 20 >>
 

Get Rid of All Those Pesky 1 MB File Growth DB Files

Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.   Read more...
By Greg Milner 2012/12/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 774 reads

Steps to add Log Shipping monitor into an existing SQL Server

I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.  Read more...
By Additional Articles 2012/12/05 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,677 reads

Has tempdb grown since the last restart?

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.  Read more...
By Orlando Colamatteo 2012/11/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,519 reads

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.  Read more...
By Additional Articles 2012/11/12 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,087 reads

Enable Database Mail in 2012

Read more...
By Mike Hays 2012/11/07 | Category: database mail
Rating: (not yet rated) |  Discuss |   Briefcase | 1,847 reads

Shrinking all log files on SQL Server 2008R2

It shrinks all log files for the databases created by users.  Read more...
By Igor Micev 2012/11/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,428 reads

Manage By Delegation

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.  Read more...
By Steve Jones 2012/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Check SQL Server Virtual Log Files Using PowerShell

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?   Read more...
By Additional Articles 2012/10/11 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 2,708 reads

Statistics - 3

Read more...
By bitbucket 2012/10/09 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 2,295 reads

SQL Server Uptime

This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)  Read more...
By Chandu Ade 2012/09/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,067 reads

Extended Events II

Read more...
By Jason Brimhall 2012/09/28 | Category: extended events
Rating: (not yet rated) |  Discuss |   Briefcase | 1,911 reads

Extended Events I

Read more...
By Jason Brimhall 2012/09/24 | Category: extended events
Rating: (not yet rated) |  Discuss |   Briefcase | 1,892 reads

Tracking Processes

Read more...
By Naseer Ahmad 2012/09/21 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,189 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,228 reads

DBA Basics

Read more...
By Naseer Ahmad 2012/09/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,032 reads

Search for an object across multiple databases on a server.

There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.   Read more...
By Kishore Tallapragada 2013/04/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,657 reads

Administration

Read more...
By Ravi Kumar SV 2012/09/11 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,707 reads

Job Running time/Interval precentage

the script has been developed on SQL server 2005 and gives the ability to find out from all active jobs the precentage of running time divided to job interval in the last 24 hours.  Read more...
By tomer lev 2012/08/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,371 reads

Catalog Views

Read more...
By Lokesh Vij 2012/08/24 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,235 reads

Check status of SPN?

Read more...
By Naseer Ahmad 2012/08/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,178 reads
<< Previous 20    Items 41 to 60 of 1409    Next 20 >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (98)    
configuring (63)    
security (58)    
miscellaneous (55)    
backup / restore (45)    
performance tuning (45)    
monitoring (38)    
strategies (36)    
indexing (34)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (25)    
sql server 6.5 (25)    
database design (18)    
disaster recovery (dr) (18)    
blogs (17)    
stored procedures (17)    
reporting services (ssrs) (16)    
advanced querying (15)    
installation (13)    
powershell (12)    
replication (12)    
visual basic 6 (12)    
editorial (11)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
backup / recovery (8)    
sql-dmo (8)    
automated dba (7)    
best and worst practices (7)    
development (7)    
news (7)    
sql server 2008 (7)    
sys.dm_db_partition_stats (7)    
transaction logs (7)    
availability (6)    
career (6)    
dba (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
auditing (5)    
database mirroring (5)    
jobs (5)    
list indexes (5)    
pivot (5)    
policy based management (pbm) (5)    
recovery model (5)    
sql server (5)    
sqlservercentral (5)    
.net (4)    
auto-growth (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
for xml path (4)    
naming standards (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
statistics (4)    
sys.allocation_units (4)    
system development life cycle (4)    
tempdb (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
automation (3)    
central management server (3)    
corruption (3)    
dbcc (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
encryption (3)    
files and filegroups (3)    
foreign keys (fk) (3)    
integration services (ssis) (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (3)    
resource governor (3)    
restore (3)    
role (3)    
space usage (3)    
sql agent (3)    
state of the business (3)    
transparent data encryption (tde) (3)    
advanced (2)    
attach (2)    
attach database (2)    
best practices (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
columns (2)    
configuration (2)    
data storage (2)    
database size (2)    
database snapshots (2)    
detach (2)    
dmv (2)    
editorial - mp3 (2)    
error logging (2)    
extended events (2)    
fragmentation (2)    
full text search (2)    
full-text search (2)    
grant (2)    
high availability (ha) (2)    
instant file initialization (2)    
isolation levels (2)    
kill (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
maintenance plans (2)    
management studio (ssms) (2)    
migration (2)    
miscellaneous (2)    
performance monitoring (2)    
product reviews (2)    
profiler (2)    
reviews (2)    
row compression (2)    
script (2)    
smo (2)    
sql puzzles (2)    
sql server 2008 r2 (2)    
sql server 2012 (2)    
sql server agent (2)    
sqlclr (2)    
storage management (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)    
system databases (2)    
system tables (2)    
tuning (2)    
uptime (2)    
user (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alter database (1)    
analysis services (ssas) (1)    
architecture (1)    
autogrowth (1)    
backup (1)    
backup/restore (1)    
browser service (1)    
bugs (1)    
build list (1)    
bulk insert (1)    
business intelligence (1)    
certification (1)    
checkdb (1)    
cleanup (1)    
collation (1)    
common language runtime (clr) (1)    
compact edition (1)    
compression (1)    
conferences and events (1)    
connectivity (1)    
contained databases (1)    
copy_only (1)    
create database (1)    
dac (1)    
data (1)    
data and log file usage for a db (1)    
data compression (1)    
data quality (1)    
data types (1)    
database (1)    
database mail (1)    
database owner (1)    
database properties (1)    
database roles (1)    
database weekly (1)    
databases (1)    
dbcc checkdb (1)    
ddl (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
diagnostic (1)    
distribution (1)    
dmv's (1)    
duplicate indexes (1)    
endpoints (1)    
english query (1)    
errorlogs (1)    
excel (1)    
extended properties (1)    
extended stored procedures (1)    
file location (1)    
filegroup (1)    
filegroups (1)    
friday poll (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
heap (1)    
indexed views (1)    
information_schema (1)    
instance properties (1)    
kill sessions (1)    
learning (1)    
linked servers (1)    
login (1)    
login information (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory (1)    
memory tuning (1)    
memtoleave (1)    
missing indexes (1)    
monitor server (1)    
move (1)    
multi process (1)    
nightly jobs (1)    
normalization (1)    
object permissions (1)    
olap server (1)    
openxml (1)    
operations manager (1)    
other (1)    
page compression (1)    
parallelism (1)    
pass summit (1)    
passwords (1)    
process (1)    
professional development (1)    
public (1)    
query optimization (1)    
rants (1)    
rebuild (1)    
rebuild log file (1)    
recent backups (1)    
reindex (1)    
report (1)    
resource database (1)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (1)    
scripting (1)    
selectivity (1)    
server migration (1)    
server_principals (1)    
serverproperty (1)    
service broker (1)    
shrinkfile (1)    
size (1)    
skills (1)    
sliding windows technique (1)    
slipstream (1)    
soap (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_server_diagnostics (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
sql monitor (1)    
sql server essentials (1)    
sql server express (1)    
sql virtual restore (1)    
stairway series (1)    
string manipulation (1)    
striped backups (1)    
syntax check (1)    
sys.database_files (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_os_sys_info (1)    
sys.dm_tran_session_transactions (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.server_triggers (1)    
sys.sql_modules (1)    
sys.triggers (1)    
sysadmin (1)    
system database (1)    
table (1)    
table compression (1)    
table size (1)    
table valued function (1)    
telecommuting (1)    
templates (1)    
temporary tables (1)    
trace (1)    
trace flag (1)    
transaction isolation (1)    
transactions (1)    
truncate table (1)    
updategrams (1)    
version (1)    
view_column_usage (1)    
virtualization (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
windows 2003 (1)    
xsl (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.