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 1409    Next 20 >>
 

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,867 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,004 reads

Data compression

Read more...
By Chirag Patel 2013/01/30 | Category: data compression
Rating: (not yet rated) |  Discuss |   Briefcase | 1,955 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 | 792 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 | 6,591 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,571 reads

Ghost Cleanup

Read more...
By Wayne Sheffield 2013/01/15 | Category: ghost cleanup
Rating: (not yet rated) |  Discuss |   Briefcase | 2,106 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,354 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,058 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 | 7,657 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,617 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,977 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,581 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,671 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,205 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,447 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,638 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,460 reads

Mirrors

Read more...
By Honza Mensdorff 2012/12/11 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,748 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 2012/12/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 777 reads
<< Previous 20    Items 21 to 40 of 1409    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)    
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)    
files and filegroups (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)    
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 2012 (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.