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

Content with tag Administration Rss

   Items 1 to 20 of 1755    Older >>
 

Indexing Computed Columns

By Steve Jones 2018/11/09 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 642 reads

The Pesky Windows Power Plan Oh My

The below script will build a csv file for import of the servers Power Plan Setting.  Read more...
By Edward Pochinski 2018/11/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 195 reads

Your SQL Servers Are Misconfigured...

It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.  Read more...
By Kevin3NF 2018/11/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,275 reads

Autogrow files

By Steve Jones 2018/10/26 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 603 reads

Basic Administration Tasks - Level 5 of the Stairway to for Azure SQL Database

In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.  Read more...
By Arun Sirpal 2018/10/24 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 400 reads

DBCC Outputbuffer

By Steve Jones 2018/08/31 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 705 reads

Creating XML Indexes

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

AlwaysOn AG Dashboard

By Henrico Bekker 2018/07/16 | Category: availability group (ag)
Rating: (not yet rated) |  Discuss |   Briefcase | 647 reads

Stats_ID

By Steve Jones 2018/07/13 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 814 reads

Restore options

By Steve Jones 2018/06/25 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 857 reads

All the memory

By Steve Jones 2018/06/19 | Category: memory
Rating: (not yet rated) |  Discuss |   Briefcase | 856 reads

Target Memory

By Steve Jones 2018/06/14 | Category: memory
Rating: (not yet rated) |  Discuss |   Briefcase | 836 reads

Solving the Target Principal Name is Incorrect

One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context  Read more...
By Raghavender Chavva 2018/05/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 669 reads

Checking CHECKDB

Everyone should be running DBCC CHECKDB on their systems. We not have some help in determining if we are doing this.  Read more...
By Steve Jones 2018/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Corrupted Backups

By Steve Jones 2018/05/21 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 825 reads

Database creation settings

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

New data in a columnstore index

By Steve Jones 2018/05/03 | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 740 reads

EMPTYFILE

By Steve Jones 2018/05/01 | Category: dbcc shrinkfile
Rating: (not yet rated) |  Discuss |   Briefcase | 745 reads
   Items 1 to 20 of 1755    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (106)    
security (78)    
backup and restore (64)    
configuring (63)    
miscellaneous (59)    
indexing (50)    
performance tuning (45)    
monitoring (42)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
editorial (26)    
maintenance (26)    
sql server 6.5 (25)    
powershell (21)    
disaster recovery (dr) (20)    
blogs (18)    
database design (18)    
stored procedures (18)    
reporting services (ssrs) (17)    
advanced querying (15)    
installation (14)    
backup (13)    
replication (13)    
sql server 2014 (13)    
transaction log (13)    
visual basic 6 (12)    
resource governor (11)    
statistics (data) (11)    
tables (11)    
restore (10)    
sql server (10)    
database mirroring (9)    
dts (9)    
search (9)    
storage (9)    
agent jobs (8)    
sql server 2008 (8)    
sql-dmo (8)    
tempdb (8)    
auditing (7)    
automated dba (7)    
best and worst practices (7)    
career (7)    
central management server (cms) (7)    
dbcc (7)    
development (7)    
encryption (7)    
news (7)    
sqlservercentral (7)    
sys.dm_db_partition_stats (7)    
availability (6)    
corruption (6)    
dba (6)    
files and filegroups (6)    
high availability (ha) (6)    
logins (6)    
recovery model (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
automation (5)    
detach database (5)    
error log (5)    
extended events (xe) (5)    
list indexes (5)    
memory (5)    
memory-optimized tables (5)    
performance (5)    
permissions (5)    
pivot (5)    
policy based management (pbm) (5)    
sql agent (5)    
sql server 2012 (5)    
trace flags (5)    
triggers (5)    
troubleshooting (5)    
.net (4)    
alter server configuration (4)    
attach database (4)    
auto-growth (4)    
basics (4)    
change data capture (cdc) (4)    
checkpoint (4)    
columnstore index (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
dbcc checkdb (4)    
filegroups (4)    
for xml path (4)    
fragmentation (4)    
integration services (ssis) (4)    
maintenance plans (4)    
naming standards (4)    
numa (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
space usage (4)    
sys.allocation_units (4)    
system development life cycle (4)    
transparent data encryption (tde) (4)    
administrator (3)    
alter database (3)    
azure (3)    
cardinality estimates (3)    
clustering (3)    
columns (3)    
compression (3)    
configuration (3)    
database (3)    
dbcc shrinkfile (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
filestream (3)    
foreign keys (fk) (3)    
friday poll (3)    
kill (3)    
locking (3)    
log shipping (3)    
migration (3)    
networking (3)    
partitioning (3)    
read only (3)    
role (3)    
row compression (3)    
script (3)    
sql server agent (3)    
sqlclr (3)    
state of the business (3)    
tuning (3)    
user (3)    
users (3)    
advanced (2)    
always on (2)    
analysis services (ssas) (2)    
attach (2)    
autogrowth (2)    
availability group (ag) (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (2)    
collation (2)    
contained databases (2)    
dac (2)    
data compression (2)    
data storage (2)    
database engine (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
ddl (2)    
dmv (2)    
dmvs (2)    
editorial - mp3 (2)    
endpoints (2)    
full text search (2)    
full-text search (2)    
function (2)    
grant (2)    
in-memory oltp tables (2)    
instant file initialization (ifi) (2)    
isolation levels (2)    
lock and connection management (2)    
log files (2)    
management studio (ssms) (2)    
maxdop (2)    
missing indexes (2)    
page compression (2)    
passwords (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
resource database (2)    
reviews (2)    
server configuration (2)    
smo (2)    
sp_spaceused (2)    
sql monitor (2)    
sql puzzles (2)    
sql server 2008 r2 (2)    
sql server 2016 (2)    
sql spackle (2)    
stairway series (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)    
transactions (2)    
uptime (2)    
user defined function (udf) (2)    
video (2)    
views (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
admin (1)    
aggregates (1)    
alerts (1)    
architecture (1)    
audit (1)    
automatic tuning (1)    
azure sql database (1)    
backup database (1)    
backup-restore (1)    
blocking (1)    
browser (1)    
buffer pool extension (1)    
bugs (1)    
build list (1)    
bulk insert (1)    
bulk logged recovery model (1)    
business intelligence (1)    
certifications (1)    
change tracking (1)    
checkdb (1)    
cleanup (1)    
cms (1)    
common language runtime (clr) (1)    
compact edition (1)    
compressed backup (1)    
computed columns (1)    
conferences and events (1)    
configuration repository (1)    
connection (1)    
connectivity (1)    
consolidation (1)    
constraints (1)    
copy backup (1)    
copy_only (1)    
create database (1)    
create xml index (1)    
cxpacket (1)    
data (1)    
data and log file usage (1)    
data file (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)    
database scoped configuration (1)    
databases (1)    
datatypes (1)    
dbatools.io (1)    
dbcc show_statistics (1)    
dbmail (1)    
ddl trigger (1)    
declarative management framework (dmf) (1)    
dedicated administrator connection (dac) (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)    
errors (1)    
excel (1)    
execution plans (1)    
extended properties (1)    
extended property (1)    
extended stored procedures (1)    
failover clustered instance (fci) (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)    
import-module (1)    
indexed views (1)    
information_schema (1)    
initial size (1)    
in-memory oltp (1)    
instance (1)    
kill sessions (1)    
latest backup (1)    
learning (1)    
linked servers (1)    
localdb (1)    
log file (1)    
logging (1)    
login (1)    
logon triggers (1)    
management (1)    
master database (1)    
mcitp (1)    
mcts (1)    
memory tuning (1)    
memory-optimized table storage (1)    
memtoleave (1)    
microsoft r services (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)    
performance and tuning (1)    
performance counters (1)    
permission (1)    
piecemeal (1)    
pivot table (1)    
processes (1)    
properties (1)    
public (1)    
query data store (qds) (1)    
query optimization (1)    
r language (1)    
rants (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_addmessage() (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_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
spn (1)    
sql audit (1)    
sql jobs (1)    
sql server essentials (1)    
sql server express (1)    
sql sever 2014 (1)    
sql virtual restore (1)    
sqlpsx (1)    
string manipulation (1)    
summary (1)    
suspect page (1)    
suspect pages (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.messages (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)    
tcp port (1)    
telecommuting (1)    
templates (1)    
temporary tables (1)    
timeticks (1)    
trace (1)    
truncate table (1)    
trustworthy (1)    
uninstall (1)    
updategrams (1)    
upgrading (1)    
version (1)    
view_column_usage (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
writefilegather (1)    
xp_cmdshell (1)    
xsl (1)