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 2012/10/20 to 2012/10/27

Understanding Column Properties for a SQL Server Table

Designing a table can be a little complicated if you don’t have the correct knowledge of data types, relationships, and even column properties. In this tip, Brady Upton goes over the column properties and provides examples.   Read more...
By Additional Articles 2012/10/26 | Source: MSSQLTips.com | Category: columns
Rating: (not yet rated)  Rate this |   Briefcase | 4,051 reads

Creating a comma-separated list (SQL Spackle)

Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.  Read more...
By Wayne Sheffield 2012/10/26 (first published: 2011/01/12) | Source: SQLServerCentral.com | Category: comma separated list
Rating: |  Discuss |   Briefcase | 29,087 reads

Using the Script Task in SSIS to Process Data Files When They Arrive

Learn how you can process data files with SSIS as soon as they arrive using the Script Task.  Read more...
By Orlando Colamatteo 2014/09/01 (first published: 2012/10/25) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 24,812 reads

Last chance for a day of free SQL Server training at SQL in the City 2012

SQL Server developers and database administrators have one last chance for a full day of free training and networking at SQL in the City 2012.  Read more...
By Press Release 2012/11/02 (first published: 2012/10/25) | Source: Red-Gate | Category: sql in the city
Rating: |  Discuss |   Briefcase | 3,866 reads

Getting Started With XML Indexes

XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running queries against half a million XML employee records. The execution time of a query is reduced from two seconds to being too quick to measure, purely by creating the right type of secondary index for the query.  Read more...
By Additional Articles 2012/10/25 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 2,199 reads

SQL Server Semantic Search to Find Text in External Files

Sometimes it is necessary to search for specific content inside documents stored in a SQL Server database. Is it possible to do this in SQL Server? Can I run T-SQL queries and find content inside Microsoft Word files? Yes, now with SQL Server 2012 you can do a semantic search.  Read more...
By Additional Articles 2012/10/24 | Source: MSSQLTips.com | Category: semantic search
Rating:  Rate this |   Briefcase | 2,020 reads

Stairway to Server-side Tracing - Level 9: How to Automate SQL Traces using the Data Collector

In this level you will see how to employ the Data Collector feature of SQL Server to automate management of SQL Traces among multiple servers.  Read more...
By Dan Guzman 2012/10/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,003 reads

Free eBook: SQL Server Backup and Restore

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.  Read more...
By Press Release 2013/01/25 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,839 reads

A Versioning system for SSRS

Use SSRS to be create its own lightweight report version control system  Read more...
By David K Bennett 2014/01/24 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 16,714 reads

Tune Your Indexing Strategy with SQL Server DMVs

SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy.  Read more...
By Additional Articles 2012/10/23 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 3,563 reads

Archiving SQL Server Data Using Partitioning

Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.  Read more...
By Additional Articles 2012/10/22 | Source: MSSQLTips.com | Category: archiving
Rating: (not yet rated)  Rate this |   Briefcase | 3,287 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2012/10/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,378 reads