Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >> Headlines from 2013/06/14 to 2013/06/21

Maximizing Throughput with TVPs

TVPs offer several performance optimization possibilities that other bulk operations do not allow, and these operations may allow for TVP performance to exceed other bulk operations by an order of magnitude, especially for a pattern where subsets of the data are frequently updated.  Read more...
By Additional Articles 2013/06/21 | Source: SQLCAT | Category: tvp
Rating:  Rate this |   Briefcase | 4,514 reads

SQL Saturday #226 - South Florida

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 29 2013 in Davie, FL. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.  Read more...
By Press Release 2013/06/21 | Source: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,776 reads

Understanding T-SQL Expression Short-Circuiting

Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.   Read more...
By Gianluca Sartori 2013/06/21 (first published: 2010/12/30) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,617 reads

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS.  Read more...
By Steve Moore 2015/08/28 (first published: 2013/06/20) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,689 reads

Avoiding Parameter Sniffing in SQL Server

Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,119 reads

Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell

Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.   Read more...
By Additional Articles 2013/06/19 | Source: | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 3,180 reads

Review: Stellar Phoenix SQL Database Recovery

Stellar Phoenix SQL Database Recovery Software Review 
By Prett Sons 2013/06/19 | Source: | Category: reviews
Rating: |  Discuss |   Briefcase | 765 reads

An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services

In this level of the Integration Services Stairway article, Andy Leonard examines SSIS variables.  Read more...
By Andy Leonard 2015/11/06 (first published: 2013/06/19) | Source: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 15,799 reads

Attention users running SQL Server 2008 & 2008 R2!

Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.  Read more...
By Press Release 2013/06/18 | Source: SQL Blog | Category: cumulative updates (cu)
Rating: (not yet rated)  Rate this |   Briefcase | 10,665 reads

PASS Data Architecture Virtual Chapter presents Steve Simon

On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.  Read more...
By Press Release 2013/06/18 | Source: PASS | Category: pass virtual chapters
Rating: (not yet rated)  Rate this |   Briefcase | 3,585 reads

Usage of CTE - Trick with Dates

This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.  Read more...
By Suresh Maganti 2017/03/03 (first published: 2013/06/18) | Source: | Category: cursor vs recursive cte
Rating: |  Discuss |   Briefcase | 34,131 reads

Managing Slowly Changing Dimension with MERGE Statement in SQL Server

Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,621 reads

SQL Saturday #229 - Dublin

SQL Saturday Dublin is hosting a two-day training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development. The free training event will be Saturday June 22 2013, and three preconference sessions (not free) will take place the 21st.  Read more...
By Press Release 2013/06/17 | Source: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 3,654 reads

PowerShell vs GUI Availability Group Rebuild

Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands   Read more...
By Paul Brewer 2013/06/17 | Source: | Category: windows cluster
Rating: |  Discuss |   Briefcase | 2,743 reads

Getting Started with the SSAS Tabular Model

SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to provide a rapid and powerful way of providing self-service BI to client applications such as Microsoft Excel and Microsoft Power View. You’ve deployed SSAS in tabular mode, and deployed Adventureworks into it. What next? Rob Sheldon explains all.  Read more...
By Additional Articles 2013/06/17 | Source: SimpleTalk | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 3,260 reads

SQL Server Integration Services Package Restartability

I've tried using SSIS checkpoints, but have found them to be difficult to configure and, on occasion, unpredictable. Is there a better way to build in restartability in my SSIS packages?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,185 reads

Custom Sequence Numbering

This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function  Read more...
By James Skipwith 2013/06/14 (first published: 2011/02/07) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,620 reads