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

SQL Intersection in Las Vegas This Spring

Come join Steve Jones, Grant Fritchey and an amazing lineup of speakers at the spring SQL Intersection conference in Las Vegas, April 8-11, 2013. Register now and you get a Surface RT tablet.  Read more...
By Press Release 2013/02/05 (first published: 2013/02/01) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,814 reads

Silent Truncation of SQL Server Data Inserts

There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.  Read more...
By Additional Articles 2013/02/01 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,672 reads

Join Operations – Nested Loops

This is part I of III in a series on the physical join operators in SQL Server.  Read more...
By Jason Brimhall 2013/02/01 (first published: 2011/01/04) | Source: SQLServerCentral.com | Category: join
Rating: |  Discuss |   Briefcase | 24,406 reads

Custom Metric - Indexes with Excessive Writes

A new custom metric is available at SQL Monitor Metrics. This tracks indexes that have more writes than reads. Use this code if you want to find out if you might be over indexing your tables.  Read more...
By Press Release 2013/01/31 | Source: SQLServerCentral.com
Rating: (not yet rated)  Rate this |   Briefcase | 2,849 reads

SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell

Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized.  Read more...
By Additional Articles 2013/01/31 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,785 reads

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...
By David Poole 2013/01/31 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 8,117 reads

SQL Server Performance Tuning – Index Tuning

In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning  Read more...
By Additional Articles 2013/01/30 | Source: SQL Server Performance | Category: indexing
Rating:  Rate this |   Briefcase | 4,581 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP3.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,069 reads

Stairway to XML: Level 9 - Creating XML-Based Functions

In this Level, we’ll look at how to use XML methods within user-defined functions to return XML fragments and values from your target XML instance.   Read more...
By Rob Sheldon 2013/01/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,034 reads

Providing SQL Agent Job Log Data for Developers

As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn't contain the full log detail and that makes it harder to troubleshoot. Most of all, we are trying not to use a different code set for deployment based on the environment. Basically we want to use the same methods to deploy our jobs to Development, Test and Production.   Read more...
By Additional Articles 2013/01/29 | Source: MSSQLTips.com | Category: sql agent
Rating: (not yet rated)  Rate this |   Briefcase | 1,244 reads

My SQL Server Database is Corrupt - Now What?!

How do you recover from corruption if your organization doesn't have a disaster recovery handbook? And how can you prevent the same corruption from recurring?  Read more...
By Paul Randal 2013/01/29 | Source: SQLServerCentral.com | Category: corruption
Rating: |  Discuss |   Briefcase | 7,219 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through CU#9 for SP1.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 10,981 reads

Update statistics in parallel

This articles shows a technique that generates and launches an SSIS package to update statistics in parallel.  Read more...
Rating: |  Discuss |   Briefcase | 4,772 reads

Beating Backup Corruption

The most critical task for all DBAs is to have a Backup and Recovery strategy that ensures, every day, that in the event of a disaster they can restore and recover any database, within acceptable limits for data loss and downtime. Even with all the required backups in place, it's easy to miss subtle failings in the overall plan that can, and eventually will, defeat your recovery plans.   Read more...
By Additional Articles 2013/01/28 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: (not yet rated)  Rate this |   Briefcase | 2,167 reads

We Loaded 1TB in 30 Minutes with SSIS, and So Can You

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios. Even for customers who don't have needs quite like this benchmark, such efforts can teach a lot about getting optimal performance.  Read more...
By Additional Articles 2013/01/25 (first published: 2010/01/19) | Source: Microsoft MSDN | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 8,775 reads

Free eBook: SQL Server Backup and Restore

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.  Read more...
By Press Release 2013/01/25 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,768 reads

Stairway to SQL Server Indexes: Level 3, Clustered Indexes

Now that we've seen the basics of indexing, and taken a deeper dive into Nonclustered Indexes, this Level will focus on searching the table, which will, in turn, will lead us to a discussion of clustered indexes.  Read more...
By David Durant 2013/01/25 (first published: 2011/06/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 22,254 reads