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

Content with tag Administration Rss

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

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,204 reads

Resource Governor pools

By Steve Jones 2014/06/10 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,277 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,025 reads

Dropping a Memory-optimized filegroup

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

Restore

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

Cardinality Regression

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

Resource Governor

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

Memory-Optimized Table Filegroups

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

Log Files

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

Heaps rebuild

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

Server Settings

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

Upgrading cardinality

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

Removing Memory-optimized tables

By Steve Jones 2014/05/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,332 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,176 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,369 reads

Reorganize indexes

Generate script to reorganize indexes in a database  Read more...
By Andrés Michaca 2014/05/01 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,166 reads

Keeping my cardinality

By Steve Jones 2014/04/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,592 reads

Memory-Optimized Table checkpoint

By Steve Jones 2014/04/28 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,334 reads
<< Newer    Items 21 to 40 of 1536    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
security (67)    
configuring (63)    
miscellaneous (55)    
backup / restore (46)    
performance tuning (45)    
monitoring (40)    
indexing (38)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (26)    
sql server 6.5 (25)    
editorial (19)    
blogs (18)    
database design (18)    
disaster recovery (dr) (18)    
reporting services (ssrs) (17)    
stored procedures (17)    
advanced querying (15)    
powershell (15)    
installation (13)    
replication (13)    
sql server 2014 (12)    
visual basic 6 (12)    
backup / recovery (9)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
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)    
sql server 2008 (7)    
sys.dm_db_partition_stats (7)    
auditing (6)    
availability (6)    
dba (6)    
recovery model (6)    
resource governor (6)    
restore (6)    
shrink database (6)    
sqlservercentral (6)    
tempdb (6)    
worst practices (6)    
ado (5)    
central management server (cms) (5)    
list indexes (5)    
memory-optimized tables (5)    
pivot (5)    
policy based management (pbm) (5)    
.net (4)    
auto-growth (4)    
automation (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
encryption (4)    
filegroups (4)    
files and filegroups (4)    
for xml path (4)    
high availability (ha) (4)    
maintenance plans (4)    
naming standards (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sql agent (4)    
sql server 2012 (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
cardinality estimates (3)    
configuration (3)    
corruption (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)    
integration services (ssis) (3)    
kill (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (3)    
performance (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)    
backup (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)    
fragmentation (2)    
friday poll (2)    
full text search (2)    
full-text search (2)    
grant (2)    
indexes (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)    
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)    
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_only (1)    
create database (1)    
data (1)    
data and log file usage (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)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
details (1)    
diagnostic (1)    
distributed transactions (1)    
distribution (1)    
dmv's (1)    
duplicate indexes (1)    
dynamic management views (1)    
endpoints (1)    
english query (1)    
errorlogs (1)    
excel (1)    
extended properties (1)    
extended stored procedures (1)    
file location (1)    
filestream (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)    
instance (1)    
kill sessions (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)    
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)    
shrinkfile (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)    
striped backups (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)