2012-11-22
1,471 reads
Articles
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.
2012-11-20
8,741 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.
2012-11-20
5,852 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.
2012-11-19
2,635 reads
SQL Saturday #179 - Kharkov, Ukraine
SQL Saturday in the Ukraine. If you want a free day of training, sign up and attend.
2012-11-19
1,559 reads
Day 7 of The OLAP Sprint
The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.
2012-11-16
1,010 reads
Generating SubTotals using GROUPING
This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.
2012-11-16 (first published: 2010-07-13)
38,075 reads
SQL Saturday #168 - Tampa BI Edition
A free day of SQL Server Business Intelligence sessions in Tampa, FL tomorrow.
2012-11-16
1,605 reads
SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance
SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.
2012-11-16
2,732 reads
2012-11-15
865 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers