SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/11/03 to 2012/11/10

Day 2 of the OLAP Sprint

Day 2 brings some initial work and a weather forecast.  Read more...
By Simon E Doubt 2012/11/09 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,560 reads

Script to create dynamic PIVOT queries in SQL Server

Pivoting is a common reporting requirement - data is stored in columns and you need to present it in rows. This was a nice feature that was added to SQL Server, but you don't always know all of the values you need to pivot on. This tip looks at how you can dynamically create the pivot command to handle these unknown values.  Read more...
By Additional Articles 2012/11/09 | Source: MSSQLTips.com | Category: pivot
Rating:  Rate this |   Briefcase | 5,228 reads

Reading SQL Server's Transaction Log

This article shows how you can read the [RowLog Contents] in the Transaction Log, for Real!  Read more...
By Kraig Kerr 2012/11/09 (first published: 2010/11/22) | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |   Briefcase | 27,552 reads

Day 1 of The OLAP Sprint

Day 1 of Simon's journey to build an OLAP solution in a week.   Read more...
By Simon E Doubt 2012/11/08 | Source: SQLServerCentral.com | Category: olap
Rating: |  Discuss |   Briefcase | 3,159 reads

Memory Corruptions, or Why You Need DBCC CHECKDB

DBCC is a mechanism that can protect you against corruptions causing substantial data loss in your database. If you use it.  Read more...
By Paul Randal 2014/10/24 (first published: 2012/11/08) | Source: SQLServerCentral.com | Category: memory corruption
Rating: |  Discuss |   Briefcase | 16,347 reads

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.  Read more...
By Additional Articles 2012/11/08 | Source: SimpleTalk | Category: partition table
Rating: (not yet rated)  Rate this |   Briefcase | 4,345 reads

The OLAP Sprint

The OLAP Challenge at the PASS Summit. Read about the plan and preparations.  Read more...
By Simon E Doubt 2012/11/07 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 903 reads

SQL Server 2012: Installing Data Quality Services

Greg Larsen shows you how to install Data Quality Services and the companion client tool called Data Quality Client for SQL Server 2012.  Read more...
Rating:  Rate this |   Briefcase | 2,150 reads

Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model

A DBA may consider switching a database to the BULK_LOGGED recovery model in the short term during, for example, bulk load operations. When a database is operating in the BULK_LOGGED model these, and a few other operations such as index rebuilds, can be minimally logged and will therefore use much less space in the log  Read more...
By Gail Shaw, Tony Davis 2012/11/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,660 reads

Using SQL Server Concatenation Efficiently

This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.  Read more...
By Additional Articles 2012/11/06 | Source: MSSQLTips.com | Category: concat()
Rating: (not yet rated)  Rate this |   Briefcase | 3,623 reads

Free eBook: SQL Server Hardware

A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.  Read more...
By Press Release 2012/11/06 | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 5,692 reads

SSIS Basics: Using the Execute SQL Task to Generate Result Sets

The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette Allen has once again cleared the fog of confusion.   Read more...
By Additional Articles 2012/11/05 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,097 reads

Stairway to XML: Level 8 - Deleting Data from an XML Instance

in order to use the modify() method to delete data from typed and untyped XML instances, you must pass an XML DML expression as an argument to the method. That expression must include the delete keyword, along with an XQuery expression that defines the XML component to be deleted. Robert makes it seem simple, as usual.  Read more...
By Rob Sheldon 2012/11/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,040 reads