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


 

Content with tag administration Rss

<< Previous 20    Items 21 to 40 of 1412    Next 20 >>
 

Troubleshooting and Fixing SQL Server Page Level Corruption

Corrupt SQL Server databases are the worst nightmare of any SQL Server professional. In any environment, from small business to enterprise, the compromise of integrity and availability of the data can constitute a business emergency. This is especially the case in those organizations reliant on an OLTP data model, for a high-volume website. SQL Server database corruption and disruption of the transaction processing system can cause business repercussions such as large financial losses, a drop in reputation or customer retention, or contractual SLA problems with the service provider, if not managed in-house.  Read more...
By Additional Articles 2013/02/18 | Source: MSSQLTips.com | Category: corruption
Rating: (not yet rated)  Rate this |   Briefcase | 2,191 reads

Moving Database Files in SQL Server

A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.  Read more...
By Perry Whittle 2013/02/11 | Source: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 7,392 reads

Thesaurus Files

Read more...
By Steve Jones 2013/02/08 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,860 reads

Evaluating Policies on Multiple SQL Server Instances using Central Management Server

you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.   Read more...
By Additional Articles 2013/02/07 | Source: MSSQLTips.com | Category: central management server
Rating: (not yet rated)  Rate this |   Briefcase | 1,893 reads

Determining Filegroup for a Table

Have you ever needed to figure out which filegroup your tables are located within?  If you had to do this,...  Read more...
By StrateSQL 2013/02/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,030 reads

Data compression

Read more...
By Chirag Patel 2013/01/30 | Category: data compression
Rating: (not yet rated) |  Discuss |   Briefcase | 1,973 reads

Adding new data files to a log shipped database

I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site,...  Read more...
By Wayne Sheffield 2013/01/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 814 reads

SQLServerCentral Runs sp_Blitz - Performance Part 1

The third article that examines the output of the sp_Blitz script&trade; run against SQLServerCentral's database servers.  Read more...
By Steve Jones 2013/01/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,212 reads

SQLServerCentral Runs sp_Blitz - Reliability

The second article that examines the output of the sp_Blitz script&trade; run against SQLServerCentral's database servers.  Read more...
By Steve Jones 2013/01/15 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,707 reads

Ghost Cleanup

Read more...
By Wayne Sheffield 2013/01/15 | Category: ghost cleanup
Rating: (not yet rated) |  Discuss |   Briefcase | 2,125 reads

Statistics Update Clarification

By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...  Read more...
By Grant Fritchey 2013/01/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,377 reads

Auto grow–On or Off Straw Poll

David Postlethwaite who contributes to this blog regularly sent me an email this morning asking about Database Auto grow. This...  Read more...
By 2013/01/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,075 reads

SQLServerCentral Runs sp_Blitz - Security

A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.  Read more...
By Steve Jones 2013/01/10 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 8,298 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 17,686 reads

Find Largest size Tables in a Database

To find a list of Tables (User or System tables)according to their size.  Read more...
By Hari Sharma 2013/01/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,996 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shiva CHALLA 2012/12/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,707 reads

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database. (SQL Server 2005).  Read more...
By RBarry Young 2012/12/28 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 14,681 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,228 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2012/12/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 18,456 reads

Show Table, Index and Image/Text size.

This is a simple script that show size from a table and yours related objects.  Read more...
By Eder Dias 2012/12/24 | Category: administration
Rating: |  Discuss |   Briefcase | 2,640 reads
<< Previous 20    Items 21 to 40 of 1412    Next 20 >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (98)    
configuring (63)    
security (58)    
miscellaneous (55)    
backup / restore (45)    
performance tuning (45)    
monitoring (38)    
strategies (36)    
indexing (34)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (25)    
sql server 6.5 (25)    
database design (18)    
disaster recovery (dr) (18)    
blogs (17)    
stored procedures (17)    
reporting services (ssrs) (16)    
advanced querying (15)    
installation (13)    
powershell (12)    
replication (12)    
visual basic 6 (12)    
editorial (11)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
backup / recovery (8)    
sql-dmo (8)    
automated dba (7)    
best and worst practices (7)    
development (7)    
news (7)    
sql server 2008 (7)    
sys.dm_db_partition_stats (7)    
transaction logs (7)    
availability (6)    
career (6)    
dba (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
auditing (5)    
database mirroring (5)    
jobs (5)    
list indexes (5)    
pivot (5)    
policy based management (pbm) (5)    
recovery model (5)    
sql server (5)    
sqlservercentral (5)    
.net (4)    
auto-growth (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
files and filegroups (4)    
for xml path (4)    
naming standards (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
statistics (4)    
sys.allocation_units (4)    
system development life cycle (4)    
tempdb (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
automation (3)    
central management server (3)    
corruption (3)    
dbcc (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
encryption (3)    
foreign keys (fk) (3)    
integration services (ssis) (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (3)    
resource governor (3)    
restore (3)    
role (3)    
space usage (3)    
sql agent (3)    
sql server 2012 (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)    
configuration (2)    
data storage (2)    
database size (2)    
database snapshots (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)    
high availability (ha) (2)    
instant file initialization (2)    
isolation levels (2)    
kill (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
maintenance plans (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)    
sql server agent (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)    
browser service (1)    
bugs (1)    
build list (1)    
bulk insert (1)    
business intelligence (1)    
certification (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 types (1)    
database (1)    
database mail (1)    
database owner (1)    
database properties (1)    
database roles (1)    
database weekly (1)    
databases (1)    
dbcc checkdb (1)    
ddl (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
diagnostic (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)    
filegroup (1)    
filegroups (1)    
friday poll (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
heap (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 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_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_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)    
version (1)    
view_column_usage (1)    
virtualization (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
windows 2003 (1)    
xsl (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.