Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/11/17 to 2012/11/24

SQL Server Transaction Log Fragmentation: a Primer

Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentation' in your transaction log as to affect performance noticably. How can this be avoided? How can you tell it's a problem? What do you do about it? Greg explains.  Read more...
By Additional Articles 2012/11/23 (first published: 2012/05/01) | Source: SimpleTalk | Category: t-log
Rating: (not yet rated)  Rate this |   Briefcase | 6,503 reads

Returning the Top X row for each group (SQL Spackle)

One of the most common T-SQL questions is on returning a ranked result set for each member of a group. Dave Ballentyne brings us a short tutorial on how you can do this in T-SQL.  Read more...
By Dave Ballantyne 2012/11/23 (first published: 2010/12/06) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 28,846 reads

RAID and Its Impact on your SQL Performance

This article attempts to explain RAID's impact on SQL performance.  Read more...
By Gregory Jackson 2014/05/16 (first published: 2012/05/01) | Source: SQLServerCentral.com | Category: raid
Rating: |  Discuss |   Briefcase | 26,959 reads

Happy Thanksgiving 2012

Happy Thanksgiving from everyone at SQLServerCentral.  Read more...
By Press Release 2012/11/22 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,458 reads

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.  Read more...
By Press Release 2012/12/25 (first published: 2012/10/30) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 17,439 reads

Has tempdb grown since the last restart?

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.  Read more...
By Orlando Colamatteo 2012/11/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,987 reads

Performance Tuning Re-indexing and Update Statistics – A Case Study

Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.  Read more...
Rating:  Rate this |   Briefcase | 5,299 reads

SQL Saturday #179 - Kharkov, Ukraine

SQL Saturday in the Ukraine. If you want a free day of training, sign up and attend.  Read more...
By Press Release 2012/11/19 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,502 reads

Create SQL Server Analysis Services Partitions using AMO

When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.   Read more...
By Additional Articles 2012/11/19 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 1,960 reads

5 Reasons You Must Start Capturing Baseline Data

It is widely acknowledged within the SQL Server community that baselines represent valuable information that DBAs should capture. Unfortunately, very few companies manage to log and report on this information, and DBAs are then forced to troubleshoot from the hip and scramble to find evidence to prove that the database is not the problem. This article will make a compelling argument for why DBAs must start capturing baseline information, and will create a roadmap for subsequent posts.  Read more...
By Erin Stellato 2012/11/19 | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 10,132 reads