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

How to Compare Rows within Partitioned Sets to Find Overlapping Dates

How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates  Read more...
By Kevin Wu 2013/12/25 (first published: 2010/10/11) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 6,913 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2014/07/16 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating: (not yet rated)  Rate this |   Briefcase | 26,534 reads

Parameterized Queries

A Greg Larsen classic - he discusses how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.  Read more...
By Additional Articles 2013/12/25 | Source: Database Journal | Category: parameterized queries
Rating:  Rate this |   Briefcase | 5,826 reads

Creating Inferred Dimension Members with SSIS

This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.  Read more...
By Robert Rubocki 2013/12/24 (first published: 2010/12/08) | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 8,490 reads

Reporting Services Performance and Optimization

This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.  Read more...
By Additional Articles 2013/12/24 | Source: SQLCAT | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,215 reads

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.  Read more...
By Perry Whittle 2013/12/24 (first published: 2011/07/12) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 8,831 reads

Next-Level Parallel Plan Forcing: An Alternative to 8649

The trace flag 8649 is incredibly useful. Alas, the flag is undocumented, unknown, and its full impact difficult to understand. Adam Machanic presents an alternative which you might find useful.  Read more...
By Additional Articles 2013/12/23 | Source: SQL Blog | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 1,798 reads

Creating A SQL Server 2008\2008 R2 Failover Cluster

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance  Read more...
By Perry Whittle 2013/12/23 (first published: 2011/01/19) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 17,845 reads

Survey: About your SQL Server Database Releases

Red Gate are looking for participants in a short short survey on SQL Server database releases. At the end you will be given a chance to enter an e-mail address to win a $50 Amazon gift certificate.  Read more...
By Press Release 2014/01/06 (first published: 2013/12/20) | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,312 reads

Recognizing community leaders

Voting is open for the Tribal Awards finalists. Choose which community warriors you think went above and beyond the call of duty with their blog, presentation, advice, user group, and more.  Read more...
By Press Release 2013/12/20 | Source: SQLServerCentral.com | Category: awards
Rating: (not yet rated) |  Discuss |   Briefcase | 426 reads

Repairing a Broken Log Shipping Plan From a Differential Backup

This article details how to reinitialise a Log Shipping scenario from a primary differential backup  Read more...
By Perry Whittle 2013/12/20 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: differential
Rating: |  Discuss |   Briefcase | 3,233 reads

Creating a Table Warehouse to Retain Historical Data for a SQL Server Table

Brady Upton explains how to create a quick data warehouse to store all the data in a separate table so that it doesn’t get groomed.   Read more...
By Additional Articles 2013/12/20 | Source: MSSQLTips.com | Category: table warehouse
Rating:  Rate this |   Briefcase | 9,372 reads

Automation: Changing SQL Service Startup Parameters using T-SQL

Quick and efficent way to change SQL service startup parameters for 1000 instances!  Read more...
By Shaunt Khalatian 2013/12/19 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 2,896 reads

Primary Key Primer for SQL Server

Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules, but if you get them right from the start with a database design, the whole process of database development is simpler, and the result is likely to perform better. We asked Phil for advice, little knowing that the explanation might take a while.  Read more...
By Additional Articles 2013/12/19 | Source: SimpleTalk | Category: primary key
Rating: (not yet rated)  Rate this |   Briefcase | 3,917 reads

Stairway to SQL Server Replication - Level 5: Transactional Replication & How it works

This level covers 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 2013/12/18 (first published: 2011/07/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,423 reads

How to Use Microsoft's AMR Tool

In order to help DBAs determine which tables and stored procedures might be good to take advantage of using the new In-Memory OLTP tables in SQL Server 2014, Microsoft introduced the AMR Utility. Greg Larsen explores how to use this tool.  Read more...
By Additional Articles 2013/12/18 | Source: Database Journal | Category: amr
Rating: (not yet rated)  Rate this |   Briefcase | 2,280 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/06/18 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 16,721 reads