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 41 to 60 of 1453    Older >>
 

Database Backup Restore

Read more...
By Naseer Ahmad 2013/06/26 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,347 reads

The Importance of Reading Comments

Read when you search for help on the internet. You might miss a very important part of what you must do.  Read more...
By Manie Verster 2013/06/10 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 4,817 reads

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 2013/05/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,271 reads

Script to change auto growth settings for all databases in SQL Server

Script to change auto growth settings for all databases in SQL Server.  Read more...
By Shashank Srivastava 2013/05/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,136 reads

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers

We came across a scenario where database bak files being created from long time which are no more in use...  Read more...
By Prashanth Jayaram 2013/05/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,107 reads

How to Change the SQL Server Name after Renaming the Windows Host

This article shows how to change a SQL Server name after changing the Windows machine name.  Read more...
By Shashank Srivastava 2013/05/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,669 reads

Loginless In Seattle

Identify orphaned Database Users and differentiate them from "Loginless" Database Users.  Read more...
By Orlando Colamatteo 2013/05/13 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,898 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 Dedhia 2013/04/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,911 reads

Script to find the total used size of all database inside SQL Server

Script to find the total used size of all database inside SQL Server  Read more...
By Shashank Srivastava 2013/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,473 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,716 reads

Endpoints

Read more...
By Steve Jones 2013/04/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,672 reads

Quick tip: Using sp_server_diagnostics

In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...  Read more...
By matt.bowler 2013/04/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,991 reads

How To Check SQL SERVER Uptime Through T-SQL

Services uptime can be checked through WMI scripts and other methods also. As a DBA most of us would like to know the uptime of SQL Server  Read more...
By Adeoye Omoboya 2013/04/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,748 reads

Throttle a Query in Mid-Execution

Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.  Read more...
By Steve Jones 2013/04/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,461 reads

Database Mirroring

Read more...
By Naseer Ahmad 2013/03/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,796 reads

Full-Text Search – Thesaurus Languages

Read more...
By Steve Jones 2013/03/19 | Category: full text search
Rating: (not yet rated) |  Discuss |   Briefcase | 1,647 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 2013/03/14 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 2,443 reads

Resetting DMVs

Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.  Read more...
By Steve Jones 2013/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 124 reads

Brent Ozar's Six Scary SQL Surprises

In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.  Read more...
By Additional Articles 2013/03/08 | Source: Red-Gate | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 6,514 reads

Working with SQL Server Recovery Models

The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,   Read more...
By Prett Sons 2013/03/05 | Source: SQLServerCentral.com | Category: recovery model
Rating: |  Discuss |   Briefcase | 3,353 reads
<< Newer    Items 41 to 60 of 1453    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
configuring (63)    
security (61)    
miscellaneous (55)    
backup / restore (46)    
performance tuning (45)    
monitoring (38)    
strategies (36)    
indexing (34)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (25)    
sql server 6.5 (25)    
blogs (18)    
database design (18)    
disaster recovery (dr) (18)    
stored procedures (17)    
reporting services (ssrs) (16)    
advanced querying (15)    
editorial (13)    
installation (13)    
powershell (12)    
replication (12)    
visual basic 6 (12)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
backup / recovery (8)    
sql-dmo (8)    
transaction logs (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
development (7)    
news (7)    
sql server 2008 (7)    
sys.dm_db_partition_stats (7)    
auditing (6)    
availability (6)    
database mirroring (6)    
dba (6)    
jobs (6)    
shrink database (6)    
sql server (6)    
sqlservercentral (6)    
worst practices (6)    
ado (5)    
list indexes (5)    
pivot (5)    
policy based management (pbm) (5)    
recovery model (5)    
.net (4)    
auto-growth (4)    
basics (4)    
central management server (cms) (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
encryption (4)    
files and filegroups (4)    
for xml path (4)    
naming standards (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sql agent (4)    
sql server 2012 (4)    
statistics (4)    
sys.allocation_units (4)    
system development life cycle (4)    
tempdb (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
automation (3)    
configuration (3)    
corruption (3)    
dbcc (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
filegroups (3)    
foreign keys (fk) (3)    
high availability (ha) (3)    
integration services (ssis) (3)    
log shipping (3)    
maintenance plans (3)    
networking (3)    
numa (3)    
partitioning (3)    
resource governor (3)    
restore (3)    
role (3)    
space usage (3)    
sql server 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)    
data storage (2)    
database size (2)    
database snapshots (2)    
dbcc checkdb (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)    
instant file initialization (2)    
isolation levels (2)    
kill (2)    
lock and connection management (2)    
locking (2)    
logins (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)    
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)    
blocking (1)    
browser service (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)    
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 quality services (dqs) (1)    
data types (1)    
database (1)    
database mail (1)    
database owner (1)    
database properties (1)    
database roles (1)    
database weekly (1)    
databases (1)    
ddl (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
diagnostic (1)    
distributed transactions (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)    
filestream (1)    
friday poll (1)    
full recovery model (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
index details (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 (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 roles (1)    
server settings (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_configure (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)    
upgrading (1)    
version (1)    
view_column_usage (1)    
virtualization (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
xsl (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.