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

New SQL Monitor Custom Metric: Database Autogrowth

This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.  Read more...
By Press Release 2013/06/25 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,037 reads

SQL Server Luxembourg User Group

Come join the SQL Server Luxembourg UG for free training and networking on June 27th at 5:30pm. Soren Nielsen will take a Deep Dive into SQL Server 2012’s “Always On” High Availability technology. This will be followed by Vern Rabe of the SQL User Group in Portland, Oregon, presenting “Data Types - Think You Know It All? Think Again”.  Read more...
By Press Release 2013/06/25 | Source: SQLServerCentral.com | Category: events
Rating:  Rate this |   Briefcase | 2,069 reads

Temporary Stored Procedures

Temporary Stored Procedures - little known sql server feature  Read more...
By Harsha Majety 2015/05/08 (first published: 2013/06/25) | Source: SQLServerCentral.com | Category: temporary stored procedures.
Rating: |  Discuss |   Briefcase | 30,864 reads

Painless management of a logging table in SQL Server

Tables that log a record of what happens in an application can get very large, easpecially if they're growing by half a billion rows a day. You'll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn't a realistic option with that volume of data. Hugo Kornelis explains a pain-free technique for SQL Server.  Read more...
By Additional Articles 2013/06/25 | Source: SimpleTalk | Category: logging
Rating:  Rate this |   Briefcase | 5,033 reads

The Switch Workshop, by Red Gate and Re-Wired Group

Customers don’t just buy a product — they switch from something else. And customers don’t just leave a product — they switch to something else. It’s in these switching moments that the deepest customer insights can be found. On the 25th of July, a select group of 32 people will attend a unique, hands-on, full-day workshop at Red Gate to learn about “The Switch”.  Read more...
By Additional Articles 2013/06/24 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,821 reads

Change Data Capture - SQL Server 2008

Change Data Capture (CDC) records DML operations performed on SQL tables and makes records available with information regarding what changed and when the change happened in a simple way.  Read more...
By Nitesh R Dedhia 2013/06/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 6,553 reads

SQL Server Reporting Services ReportItems Collection

What is SQL Server Reporting Services 2012 (SSRS) ReportItems collection and how do I use it? Are there any restrictions on its use? Check out this tip to learn more.  Read more...
By Additional Articles 2013/06/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 5,726 reads

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,602 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: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,796 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,642 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,847 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,208 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: MSSQLTips.com | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 3,340 reads

Review: Stellar Phoenix SQL Database Recovery

Stellar Phoenix SQL Database Recovery Software Review 
By Prett Sons 2013/06/19 | Source: SQLServerCentral.com | Category: reviews
Rating: |  Discuss |   Briefcase | 790 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: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 16,029 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 | 11,069 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,752 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: SQLServerCentral.com | Category: cursor vs recursive cte
Rating: |  Discuss |   Briefcase | 34,464 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,782 reads