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

Content with tags Blogs, Administration Rss

   Items 1 to 18 of 18   
 

Ordering steps in a SQL Agent job

Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...  Read more...
By Kenneth Fisher 2013/07/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,034 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,279 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 | 2,264 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,289 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 | 992 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,606 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,270 reads

Changing physical locations of all DBs

I got a request this week from an application engineer. The request was to move ALL physical database files from...  Read more...
By SQLSandwiches 2012/07/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,246 reads

Don’t believe everything you read: Reconfigure flushes the plan cache

I’ve been doing a fair bit of research and investigation into the behavior of the plan cache recently. So I was concerned...  Read more...
By 2012/06/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,245 reads

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" . First, in BOL, for "DBCC...  Read more...
By 2012/06/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 6,157 reads

SQL Server : Moving System, resource and User Databases to New SAN disk

In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive...  Read more...
By 2012/06/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,704 reads

Do You Document Your SQL Server Instances?

When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced,...  Read more...
By Brad McGehee 2012/06/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,359 reads

SQL Server – Identifying default data directory for multiple instances through registry

This is a follow up post from a comment on my blog. Earlier I posted about using xp_instance_regread to get default...  Read more...
By 2012/01/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,578 reads

DBA 101: Why is my log file full?

This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....  Read more...
By Grant Fritchey 2011/01/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,096 reads

Perform a Striped Backup

The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...  Read more...
By Bru Medishetty 2009/12/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,871 reads

One Database, One Server

As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use it on a server today, but it's never provided a solid way of isolating resources for each instance. Next, one of the things I evangelize...  Read more...
By Andy Warren 2009/06/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,821 reads

The Maintenance Plan Wizard Can Lead You Astray

In theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to create database maintenance plans that help to optimize the performance of their SQL Server databases. The problem is ...  Read more...
By Brad McGehee 2009/04/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 7,263 reads

How do I ... Determine Database Growth If I Am Not Tracking It? -- Error Logs Part III

How do I ... Determine Database Growth If I Am Not Tracking It? If your database has grown considerably and you're not sure when or why it happened, you'll be hard pressed to figure out the answer unless you're tracking changes in database size.  Read more...
By Robert Davis 2009/02/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,787 reads
   Items 1 to 18 of 18   
 
Tags
backup / restore (1)    
files and filegroups (1)    
indexing (1)    
jobs (1)    
log shipping (1)    
maintenance plans (1)    
powershell (1)    
sp_server_diagnostics (1)    
sql agent (1)    
statistics (1)    
striped backups (1)    
transaction logs (1)    
virtualization (1)