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/07/04 to 2013/07/11

Dynamically Truncate a Partitioned Table

Wouldn't be great if you could truncate any partition of a partitioned table with one T-SQL statement? This article shows you how.  Read more...
By Steven Rao 2013/07/11 | Source: SQLServerCentral.com | Category: partition switch
Rating: |  Discuss |   Briefcase | 3,738 reads

SQL Server: How Important Are Index Statistics

In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.  Read more...
By Additional Articles 2013/07/11 | Source: Database Journal | Category: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,836 reads

How to Post Performance Problems

How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.  Read more...
By Gail Shaw 2014/01/17 (first published: 2009/06/12) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 45,573 reads

An Automated Process to Archive Big Tables

Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database.   Read more...
By Leo Peysakhovich 2013/07/10 | Source: SQLServerCentral.com | Category: archiving
Rating: |  Discuss |   Briefcase | 6,666 reads

Understanding SQL Server Query Optimization Statistics

In this article, you will learn what query optimisation statistics are and how SQL Server query optimizer uses statistics. You will also learn how to create and manage statistics, and what are the different ways to determine when statistics were last updated in SQL Server.  Read more...
By Additional Articles 2013/07/10 | Source: SQL Server Performance | Category: query optimizer
Rating: (not yet rated)  Rate this |   Briefcase | 4,038 reads

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2013/07/09 | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 10,802 reads

Identify and Correct SQL Server Forwarded Records

Forwarded records in SQL Server can cause performance issues on heap tables because the record outgrows the page and the database engine uses pointers to reference the data. The best practice is to have a clustered index on every table, however, sometimes there are cases when a clustered index is not needed.   Read more...
By Additional Articles 2013/07/09 | Source: MSSQLTips.com | Category: heap
Rating: (not yet rated)  Rate this |   Briefcase | 2,876 reads

SQL Saturday #230 Rheinland

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jul 13 2013 at Grantham-Allee 20, Sankt Augustin, Cologne/Bonn, Rheinland, 53757 , Germany.   Read more...
By Press Release 2013/07/09 (first published: 2013/07/09) | Category: events
Rating: |  Discuss |   Briefcase | 309 reads

New SQL Monitor Custom Metric: Untrusted Check Constraints

This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.  Read more...
By Press Release 2013/07/08 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,369 reads

A simple trick for “Block Comment” syntax in SSMS

Make your comment blocks much more useful, in a surprising number of ways  Read more...
By Peter Zerk 2013/07/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,798 reads

Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1

The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you to migrate the most-used tables in an existing database to memory-optimized 'Hekaton' technology, but how you balance between disk tables and in-memory tables for optimum performance requires judgement and experiment.  Read more...
By Additional Articles 2013/07/08 | Source: SimpleTalk | Category: sql server 2014
Rating:  Rate this |   Briefcase | 3,231 reads

SQL Server 2012 Integration Services - Leveraging PowerShell in Package Deployment Model

SQL Server 2012 Integration Services introduces an innovative approach to deploying SSIS projects, known as Project Deployment Model. However, the traditional, package-based methodology remains available and supported, and, in some scenarios, it might be considered more viable, since it allows for separation of SQL Server Database Engine and SQL Server Integration Services.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,851 reads

SQL Server Trace Flags

A comprehensive list of trace flags for SQL Server that you can use to configure your server instance.  Read more...
By Yusuf Anis 2013/07/05 (first published: 2010/06/03) | Source: SQLServerCentral.com | Category: trace flags
Rating: |  Discuss |   Briefcase | 23,764 reads

Column Order in an Index

This short article shows the importance of order of columns in an index.  Read more...
By Sarvesh Singh 2013/07/05 (first published: 2010/11/23) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 20,515 reads

Don Knuth and the Art of Computer Programming: The Interview

Fifty years after starting the 'Art of Computer Programming', Don Knuth is still working hard at the project. It is considered amongst the "hundred or so books that shaped a century of science”. Richard Morris asks him how things are going, and to find out more about his many achievements.  Read more...
By Additional Articles 2013/07/04 | Source: SimpleTalk | Category: interview
Rating: (not yet rated)  Rate this |   Briefcase | 4,012 reads

Why SQL Server 2012 needs Windows Server 2012

While AlwaysOn and Columnar lookup are good enough reasons to migrate to SQL Server 2012, you need to be aware of the problems associated with certain virtualize environments.   Read more...
By Jim Johnston 2013/07/04 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 8,187 reads