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

  

Content with tag Administration Rss

<< Newer    Items 41 to 60 of 1561    Older >>
 

Effective Max

Read more...
By Steve Jones 2014/06/23 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,553 reads

No Files For You

Read more...
By Andy Warren 2014/06/18 | Category: sys.database_files
Rating: (not yet rated) |  Discuss |   Briefcase | 1,652 reads

Compressed Backups

Read more...
By Steve Jones 2014/06/13 | Category: backup / recovery
Rating: (not yet rated) |  Discuss |   Briefcase | 1,435 reads

Manual checkpoints for memory-optmized files

Read more...
By Steve Jones 2014/06/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,263 reads

Logging in Maintenance Plans

Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012  Read more...
By C.J. Garcia 2014/06/12 | Source: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 2,278 reads

Resource Governor pools

Read more...
By Steve Jones 2014/06/10 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,300 reads

Display All Errors Fired in a Restore Procedure

Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events  Read more...
By Brian Awe 2014/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 3,083 reads

Dropping a Memory-optimized filegroup

Read more...
By rhythm k 2014/06/09 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,267 reads

Restore

Read more...
By free mascot 2014/06/06 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,484 reads

Cardinality Regression

Read more...
By Steve Jones 2014/06/02 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,302 reads

Resource Governor

Read more...
By Steve Jones 2014/05/29 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,284 reads

Memory-Optimized Table Filegroups

Read more...
By Steve Jones 2014/05/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,347 reads

Get User In Reporting Services

Read more...
By Andy Warren 2014/05/26 | Category: reporting services (ssrs)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,555 reads

Log Files

Read more...
By Steve Jones 2014/05/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,699 reads

Heaps rebuild

Read more...
By Igor Micev 2014/05/21 | Category: heaps
Rating: (not yet rated) |  Discuss |   Briefcase | 1,713 reads

Server Settings

Read more...
By free mascot 2014/05/19 | Category: server configuration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,554 reads

Upgrading cardinality

Read more...
By Steve Jones 2014/05/15 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,368 reads

Removing Memory-optimized tables

Read more...
By Steve Jones 2014/05/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,387 reads

Index Utilization Trending

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?  Read more...
By Edward Pollack 2014/05/05 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,425 reads

Generated script to update statistics

Generated script to update statistics  Read more...
By Andrés Michaca 2014/05/02 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,498 reads
<< Newer    Items 41 to 60 of 1561    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
security (68)    
configuring (63)    
miscellaneous (55)    
backup / restore (46)    
performance tuning (45)    
indexing (41)    
monitoring (40)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (26)    
sql server 6.5 (25)    
editorial (21)    
disaster recovery (dr) (19)    
blogs (18)    
database design (18)    
reporting services (ssrs) (17)    
stored procedures (17)    
powershell (16)    
advanced querying (15)    
installation (13)    
replication (13)    
sql server 2014 (13)    
visual basic 6 (12)    
backup / recovery (10)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
restore (8)    
sql server 2008 (8)    
sql-dmo (8)    
statistics (8)    
transaction logs (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
database mirroring (7)    
development (7)    
jobs (7)    
news (7)    
sql server (7)    
sys.dm_db_partition_stats (7)    
auditing (6)    
availability (6)    
dba (6)    
recovery model (6)    
resource governor (6)    
shrink database (6)    
sqlservercentral (6)    
tempdb (6)    
worst practices (6)    
ado (5)    
automation (5)    
backup (5)    
central management server (cms) (5)    
high availability (ha) (5)    
list indexes (5)    
memory-optimized tables (5)    
pivot (5)    
policy based management (pbm) (5)    
sql server 2012 (5)    
.net (4)    
auto-growth (4)    
basics (4)    
corruption (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
encryption (4)    
filegroups (4)    
files and filegroups (4)    
for xml path (4)    
integration services (ssis) (4)    
maintenance plans (4)    
naming standards (4)    
performance (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sql agent (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
cardinality estimates (3)    
configuration (3)    
dbcc (3)    
dbcc checkdb (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
extended events (3)    
foreign keys (fk) (3)    
fragmentation (3)    
friday poll (3)    
kill (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (3)    
role (3)    
space usage (3)    
sql server agent (3)    
sqlclr (3)    
state of the business (3)    
transparent data encryption (tde) (3)    
tuning (3)    
advanced (2)    
analysis services (ssas) (2)    
attach (2)    
attach database (2)    
azure (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
columns (2)    
compression (2)    
dac (2)    
data compression (2)    
data storage (2)    
database (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
ddl (2)    
detach (2)    
dmv (2)    
editorial - mp3 (2)    
error logging (2)    
filestream (2)    
full text search (2)    
full-text search (2)    
grant (2)    
instant file initialization (2)    
isolation levels (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
management studio (ssms) (2)    
memory (2)    
migration (2)    
miscellaneous (2)    
missing indexes (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
reviews (2)    
row compression (2)    
script (2)    
server configuration (2)    
smo (2)    
sql puzzles (2)    
sql server 2008 r2 (2)    
sql spackle (2)    
storage management (2)    
striped backups (2)    
sys.database_files (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)    
trace flags (2)    
uptime (2)    
user (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alerts (1)    
alter database (1)    
alwayson (1)    
architecture (1)    
autogrowth (1)    
backup/restore (1)    
blocking (1)    
buffer pool extension (1)    
bugs (1)    
build list (1)    
bulk insert (1)    
bulk logged recovery model (1)    
business intelligence (1)    
central management server (1)    
certifications (1)    
change data capture (cdc) (1)    
change tracking (1)    
checkdb (1)    
checkpoint (1)    
cleanup (1)    
cms (1)    
collation (1)    
columnstore indexes (1)    
common language runtime (clr) (1)    
compact edition (1)    
compressed backup (1)    
conferences and events (1)    
configuration repository (1)    
connectivity (1)    
consolidation (1)    
constraints (1)    
contained databases (1)    
copy backup (1)    
copy_only (1)    
create database (1)    
data (1)    
data and log file usage (1)    
data flow (1)    
data gathering (1)    
data quality (1)    
data quality services (dqs) (1)    
data types (1)    
database growth status (1)    
database mail (1)    
database owner (1)    
database roles (1)    
databases (1)    
dbmail (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
detach database (1)    
details (1)    
diagnostic (1)    
distributed transactions (1)    
distribution (1)    
dmv's (1)    
duplicate indexes (1)    
dynamic management views (1)    
dynamic script to copy backup (1)    
endpoints (1)    
english query (1)    
errorlogs (1)    
excel (1)    
execution plans (1)    
extended properties (1)    
extended stored procedures (1)    
file location (1)    
file operations (1)    
filter backup (1)    
full recovery model (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
heaps (1)    
indexed views (1)    
information_schema (1)    
in-memory oltp (1)    
instance (1)    
kill sessions (1)    
latest backup (1)    
learning (1)    
linked servers (1)    
log file (1)    
logging (1)    
login (1)    
login information (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory tuning (1)    
memory-optimized table storage (1)    
memtoleave (1)    
monitor (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)    
piecemeal (1)    
process (1)    
properties (1)    
public (1)    
query optimization (1)    
rants (1)    
read only (1)    
rebuild (1)    
rebuild log file (1)    
recent backups (1)    
recovery interval (1)    
reindex (1)    
remove old backup from path (1)    
reorganize indexes (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 (1)    
server migration (1)    
server roles (1)    
server_principals (1)    
serverproperty (1)    
service accounts (1)    
service broker (1)    
settings (1)    
setup (1)    
shrinkfile (1)    
sid (1)    
sid mismatch check (1)    
size (1)    
skills (1)    
sliding windows technique (1)    
slipstream (1)    
soap (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_configure (1)    
sp_server_diagnostics (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
spn (1)    
sql monitor (1)    
sql server essentials (1)    
sql server express (1)    
sql sever 2014 (1)    
sql virtual restore (1)    
sqlpsx (1)    
stairway series (1)    
string manipulation (1)    
summary (1)    
syntax check (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 levels (1)    
transactions (1)    
truncate table (1)    
trustworthy (1)    
updategrams (1)    
upgrading (1)    
version (1)    
view_column_usage (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
xsl (1)    
 
Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.