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/12/25 to 2013/01/01

Automatically Generate Stored Procedures

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database  Read more...
By James Skipwith 2013/01/01 (first published: 2011/02/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,989 reads

Free Tools for the DBA: PAL Tool

The Performance Analysis of Logs tool is a general tool for collecting and analysing log data. With the addition of a template, it becomes an effective way of analysing data from performance counters for SQL Server, in order to diagnose performance problems and capture baseline information.  Read more...
By Additional Articles 2013/01/01 | Source: SimpleTalk | Category: pal tool
Rating:  Rate this |   Briefcase | 5,364 reads

Copy SQL Server Analysis Services Dimensions

How can you copy dimensions from one SQL Server Analysis Services (SSAS) Project to another? Are there any options to do so? This tip outlines three approaches for SQL Server BI Professionals who need to copy dimensions from one SSAS project to another.  Read more...
By Additional Articles 2012/12/31 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,187 reads

Data Mining Introduction Part 2

This is a continuation of first article about Data Mining. We will talk about decision trees.  Read more...
By Daniel Calbimonte 2014/08/29 (first published: 2012/12/31) | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 16,136 reads

Tally OH! An Improved SQL 8K “CSV Splitter” Function

The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).  Read more...
By Jeff Moden 2012/12/28 (first published: 2011/05/02) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 48,242 reads

Index Create Memory Setting for SQL Server

The "index create memory" option in sp_configure advance server settings, controls the maximum amount of memory initially allocated for creating indexes. This tip deals with common issues around this setting.  Read more...
By Additional Articles 2012/12/28 | Source: MSSQLTips.com | Category: index create memory
Rating:  Rate this |   Briefcase | 3,036 reads

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...
By Christopher Ross 2012/12/27 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 4,508 reads

Database Deployment: The Bits - Database Version Drift

When you are about to deploy a new version of a database by updating the current version, one of the essential pre-deployment checks is to make sure that the version in production is exactly what it should be. If changes have somehow slipped in, you'll need to understand them and deal with them before you can deploy.  Read more...
By Additional Articles 2012/12/27 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,424 reads

Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.   Read more...
By Sebastian Meine 2012/12/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 25,774 reads

How to create and use Temp tables in SSIS

Creating temp tables in SSIS seems like a straight-forward process using the Execute SQL Task, however there are a couple of properties that must be changed. In this tip, we’ll walk through creating a simple temp table in SSIS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,870 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,502 reads

SQLServerCentral Best Practices Clinic: Part 1

We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.  Read more...
By Brad McGehee 2012/12/25 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 22,611 reads

Happy Holidays 2012

Merry Christmas and Happy Holidays from SQLServerCentral  Read more...
By Steve Jones 2012/12/25 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 903 reads