SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/02/09 to 2013/02/16

SQL Saturday #177 - Silicon Valley

Don’t miss the Bay Area’s largest SQL Server event of the year! You can choose from sessions on SQL Server 2012, DBA, Development, Business Intelligence, and Big Data.   Read more...
By Press Release 2013/02/15 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 246 reads

Stairway to Server-side Tracing - Level 1 - Overview of Tracing

The first part of our stairway series on SQL Trace examines the overview of this subsystem in SQL Server, it's architecture and the kind of information it returns.  Read more...
By Dan Guzman 2013/02/15 (first published: 2011/02/23) | Source: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 21,327 reads

If you are using indexed views and MERGE, please read this!

Here is some information about an important MERGE “wrong results” bug, involving indexed views, that could be affecting the accuracy of your queries right now, and what options you have for working around the problem.  Read more...
By Aaron Bertrand 2013/02/14 | Source: SQLPerformance.com | Category: indexed views
Rating:  Rate this |   Briefcase | 4,500 reads

MDX Guide for SQL Folks: Part III - Advanced Analysis

Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.  Read more...
By Frank A. Banin 2013/02/14 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 5,700 reads

SQL Server 2012: Time Marches On

Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.  Read more...
By Additional Articles 2013/02/13 | Category: date manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 3,671 reads

Stairway to XML: Level 10 - Converting XML Data

In this Level, we look at how to convert string values to XML and how to convert XML to character types.   Read more...
By 2013/02/13 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,169 reads

An in-depth look at change detection in SQL Server - Part 01

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...
By Nakul Vachhrajani 2013/02/12 | Source: SQLServerCentral.com | Category: change detection
Rating: |  Discuss |   Briefcase | 3,150 reads

Expanding AlwaysOn Availability Groups with Replication Publishers

SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has been around in SQL Server for quite some time and allows you to scale out your environment. Warwick Rudd explains how to join these technologies together.   Read more...
By Additional Articles 2013/02/12 | Source: SimpleTalk | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 2,291 reads

Move all SQL Server indexed views to a new filegroup

As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.  Read more...
By Additional Articles 2013/02/11 | Source: MSSQLTips.com | Category: filegroups
Rating: (not yet rated)  Rate this |   Briefcase | 3,127 reads

SQL Saturday #198 - Vancouver

SQL Saturday comes back to Vancouver, BC on Feb 16, 2013. Come join in if you can.  Read more...
By Press Release 2013/02/11 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,046 reads

Moving Database Files in SQL Server

A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.  Read more...
By Perry Whittle 2013/02/11 | Source: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 8,054 reads