Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Administration Rss

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

Getting transaction log space usage statistics for all databases.

Easy way to get the TLOg space Usage details  Read more...
By S M 2015/12/07 | Source: SQLServerCentral.com | Category: space usage
Rating: |  Discuss |   Briefcase | 1,162 reads

Extended Events Targets

By Steve Jones 2015/11/23 | Category: extended events
Rating: (not yet rated) |  Discuss |   Briefcase | 1,114 reads

Temporary exclusive database access

This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.  Read more...
By Tom Staab 2015/11/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 856 reads

List of Stored Procedures modified in past 7 days

Provide list of Stored Procedures that have been changed in past 7 days.  Read more...
By Nitesh R Dedhia 2015/10/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,416 reads

List all tables and their respective information.

List all tables in a SQL Server database with the details of them.  Read more...
By Fernando Casas Osorio 2015/10/13 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 4,271 reads

Migrate existing DB Mail Exchange Configuration with New

Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.  Read more...
By Nitin Gupta 2015/10/06 | Source: SQLServerCentral.com | Category: dbmail
Rating: |  Discuss |   Briefcase | 999 reads

Restore

By Sergey Gigoyan 2015/09/30 | Category: backup-restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,826 reads

Backup log with norecovery

By Steve Jones 2015/09/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,491 reads

Renaming

By Steve Jones 2015/09/28 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,638 reads

CXPACKET

By Steve Jones 2015/09/21 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,598 reads

Missing Indexes

By Steve Jones 2015/09/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,630 reads

Physical Server or a Virtual Machine?

Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM. Note: This Script works only on 2008R2 SP1 and above.   Read more...
By SreeSql 2015/09/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,606 reads

Database Storage

By Steve Jones 2015/09/08 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,573 reads

Open Transactions

By Steve Jones 2015/09/04 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,623 reads

Mount Points

By Steve Jones 2015/09/01 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,414 reads

Real World: SQL Server Quick Quality Check

Here is a script that can give the DBA a SQL Instance quick quality check.  Read more...
By Randeep Singh 2016/08/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,053 reads

Columnstore Index metadata

By Hugo Kornelis 2015/08/27 | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 1,219 reads

Statistics statistics

By Steve Jones 2015/08/25 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,420 reads

Detaching and Updating Databases

By Steve Jones 2015/08/24 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,572 reads
<< Newer    Items 41 to 60 of 1652    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (101)    
security (70)    
configuring (63)    
backup and restore (58)    
miscellaneous (57)    
performance tuning (45)    
indexing (42)    
monitoring (41)    
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)    
stored procedures (18)    
powershell (17)    
reporting services (ssrs) (17)    
advanced querying (15)    
installation (13)    
replication (13)    
sql server 2014 (13)    
transaction log (13)    
visual basic 6 (12)    
resource governor (11)    
sql server (10)    
statistics (data) (10)    
backup (9)    
dts (9)    
restore (9)    
search (9)    
storage (9)    
tables (9)    
agent jobs (8)    
database mirroring (8)    
sql server 2008 (8)    
sql-dmo (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
central management server (cms) (7)    
development (7)    
news (7)    
sqlservercentral (7)    
sys.dm_db_partition_stats (7)    
tempdb (7)    
auditing (6)    
availability (6)    
dba (6)    
files and filegroups (6)    
recovery model (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
automation (5)    
corruption (5)    
dbcc (5)    
high availability (ha) (5)    
list indexes (5)    
logins (5)    
memory-optimized tables (5)    
performance (5)    
permissions (5)    
pivot (5)    
policy based management (pbm) (5)    
sql agent (5)    
sql server 2012 (5)    
troubleshooting (5)    
.net (4)    
auto-growth (4)    
basics (4)    
checkpoint (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
detach database (4)    
encryption (4)    
extended events (4)    
filegroups (4)    
for xml path (4)    
fragmentation (4)    
integration services (ssis) (4)    
maintenance plans (4)    
naming standards (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
space usage (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
administrator (3)    
attach database (3)    
azure (3)    
cardinality estimates (3)    
columns (3)    
columnstore index (3)    
compression (3)    
configuration (3)    
database (3)    
dbcc checkdb (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
error log (3)    
foreign keys (fk) (3)    
friday poll (3)    
kill (3)    
locking (3)    
log shipping (3)    
memory (3)    
migration (3)    
networking (3)    
numa (3)    
partitioning (3)    
role (3)    
row compression (3)    
script (3)    
sql server agent (3)    
sqlclr (3)    
state of the business (3)    
transparent data encryption (tde) (3)    
tuning (3)    
user (3)    
users (3)    
advanced (2)    
alter database (2)    
analysis services (ssas) (2)    
attach (2)    
autogrowth (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
collation (2)    
dac (2)    
data compression (2)    
data storage (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
ddl (2)    
dmv (2)    
dmvs (2)    
editorial - mp3 (2)    
endpoints (2)    
filestream (2)    
full text search (2)    
full-text search (2)    
function (2)    
grant (2)    
instant file initialization (ifi) (2)    
isolation levels (2)    
lock and connection management (2)    
log files (2)    
management studio (ssms) (2)    
miscellaneous (2)    
missing indexes (2)    
page compression (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
resource database (2)    
reviews (2)    
server configuration (2)    
smo (2)    
sql monitor (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)    
table size (2)    
trace flags (2)    
transactions (2)    
uptime (2)    
user defined function (udf) (2)    
video (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
admin (1)    
aggregates (1)    
alerts (1)    
alwayson (1)    
architecture (1)    
audit (1)    
backup/restore (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)    
certifications (1)    
change data capture (cdc) (1)    
change tracking (1)    
checkdb (1)    
cleanup (1)    
cms (1)    
common language runtime (clr) (1)    
compact edition (1)    
compressed backup (1)    
conferences and events (1)    
configuration repository (1)    
connection (1)    
connectivity (1)    
consolidation (1)    
constraints (1)    
contained databases (1)    
copy backup (1)    
copy_only (1)    
create database (1)    
cxpacket (1)    
data (1)    
data and log file usage (1)    
data flow (1)    
data gathering (1)    
data quality (1)    
data quality services (dqs) (1)    
database configuration (1)    
database files (1)    
database growth status (1)    
database mail (1)    
database owner (1)    
database roles (1)    
databases (1)    
datatypes (1)    
dbcc show_statistics (1)    
dbmail (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
default trace (1)    
defragmentation (1)    
delayed durability (1)    
details (1)    
diagnostic (1)    
dirty pages (1)    
distributed transactions (1)    
distribution (1)    
dmv's (1)    
drive space (1)    
duplicate indexes (1)    
dynamic management views (1)    
dynamic script (1)    
dynamic script to copy backup (1)    
english query (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)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
heaps (1)    
index (1)    
indexed views (1)    
information_schema (1)    
initial size (1)    
in-memory oltp (1)    
in-memory oltp tables (1)    
instance (1)    
kill sessions (1)    
latest backup (1)    
learning (1)    
linked servers (1)    
log file (1)    
logging (1)    
login (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)    
norecovery (1)    
normalization (1)    
object permissions (1)    
olap server (1)    
openxml (1)    
operations manager (1)    
optimization (1)    
other (1)    
parallelism (1)    
pass summit (1)    
passwords (1)    
performance counters (1)    
permission (1)    
piecemeal (1)    
pivot table (1)    
processes (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)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (1)    
schema (1)    
schemas (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)    
single user (1)    
size (1)    
skills (1)    
sliding windows technique (1)    
slipstream (1)    
soap (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_configure (1)    
sp_detach_db (1)    
sp_procoption (1)    
sp_server_diagnostics (1)    
sp_setnetname (1)    
sp_spaceused (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
spn (1)    
sql jobs (1)    
sql server 2016 (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 valued function (tvf) (1)    
telecommuting (1)    
templates (1)    
temporary tables (1)    
trace (1)    
trace flag (1)    
truncate table (1)    
trustworthy (1)    
uninstall (1)    
updategrams (1)    
upgrading (1)    
version (1)    
view_column_usage (1)    
views (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
writefilegather (1)    
xsl (1)