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

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 flags
Rating: (not yet rated)  Rate this |   Briefcase | 2,125 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 | 18,404 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: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,591 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 | 434 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,551 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,684 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 | 3,244 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 (pk)
Rating: (not yet rated)  Rate this |   Briefcase | 4,899 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 | 15,559 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 | 3,053 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 2016/06/15 (first published: 2013/07/24) | Source: Redgate | Category: hardware
Rating:  Rate this |   Briefcase | 57,899 reads

Removing the Linked Server 2 hop Limitation

This article talks about how you can get around the "Login Failed for user 'NT Authority\ANONYMOUS' LOGON" error when using linked servers and Windows authentication.  Read more...
By Derek Stanley 2013/12/17 | Source: SQLServerCentral.com | Category: authentication
Rating: |  Discuss |   Briefcase | 7,590 reads

SQL Server tablediff utility

Rob Sheldon continues on his quest to explain all those command-line tools such as SQLCMD, Logparser, SQLIO and tablediff that are part of SQL Server. TableDiff can be used for comparing tables, as when you run automated tests that check a result against a table of expected values. The best way to learn TableDiff is to see it in action and Rob talks you through several examples.  Read more...
By Additional Articles 2013/12/17 | Source: SimpleTalk | Category: tablediff utility
Rating: (not yet rated)  Rate this |   Briefcase | 3,575 reads

SQL Saturday #272 - Nashville, TN

SQL Saturday is coming to Nashville on January 18th 2014. This is a free full day of SQL Server training and networking. There are also paid-for Pre-con sessions available to sign up for presented by Denny Cherry and David Klee.  Read more...
By Press Release 2013/12/17 | Source: SQL Saturday | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,757 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,192 reads

Congratulations to our Apology Contest Winners

A congratulations to the winners of our contest last week.  Read more...
By Steve Jones 2013/12/16 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,303 reads

Webinar: T-SQL Tips and Tricks

Nigel Sammy will be presenting this PASS Data Architecture VC webinar on December 19 at 12PM CST. The webinar will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries.   Read more...
By Press Release 2013/12/16 | Source: PASS | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,693 reads

Import UTF-8 Unicode Special Characters with SQL Server Integration Services

If you work with large scale SSIS ETL processes and sequences, you are bound to have to work with UTF-8 encoded text files. Without proper handling, UTF-8 / Unicode characters can cause havoc with your SSIS load tasks. Here are some ideas for handling the UTF-8 file formats with SSIS.  Read more...
By Additional Articles 2013/12/16 | Source: MSSQLTips.com | Category: utf-8
Rating: (not yet rated)  Rate this |   Briefcase | 2,575 reads