Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQL Server 2008 Rss

Search for any content tagged sql server 2008

<< Newer    Items 21 to 40 of 315    Older >>
 

Tips for Upgrading a Cluster to SQL 2008 - Part 1

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008  Read more...
By Alejandro Pelc 2011/11/14 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 2,681 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,342 reads

Diagnosing and Resolving Spinlock Contention on SQL Server

This paper describes how to identify and resolve spinlock contention issues observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.  Read more...
By Additional Articles 2011/10/21 | Source: SQLCAT | Category: spinlock
Rating: (not yet rated)  Rate this |   Briefcase | 2,217 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP4.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,710 reads

Adding Custom Code to the Reporting Services 2008 R2

There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article you will see how to add custom code to SSRS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,709 reads

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task

The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.  Read more...
By Additional Articles 2011/08/15 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,764 reads

Change Tracking and Database Refactoring

Using change tracking in SQL Server 2008 to aid in database refactoring within an OLTP system.  Read more...
By Luke Campbell 2011/08/11 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 4,467 reads

Guide To MCITP: SQL Server 2008 Administration

Find out what you need to learn for the SQL Server 2008 Administration certification exams.  Read more...
By Mike McQuillan 2011/08/05 | Source: SQLServerCentral.com | Category: mcts
Rating: |  Discuss |   Briefcase | 8,462 reads

Migrating Microsoft Access Databases to SQL Server 2008

Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.  Read more...
By Additional Articles 2011/07/26 | Source: Database Journal | Category: access
Rating: (not yet rated)  Rate this |   Briefcase | 2,853 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP4.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,710 reads

Table Value Constructors in SQL Server 2008

Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. Users who are stuck with previous versions of SQL Server can play along, since Rob Sheldon demonstrates that there have always been ways of doing this in SQL Server, though less elegantly.  Read more...
By Additional Articles 2011/07/07 | Source: SimpleTalk | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,404 reads

Support for 15,000 Partitions in SQL Server 2008 SP2 and SQL Server 2008 R2 SP1

In SQL Server 2008 and SQL Server 2008 R2, the number of partitions on tables and indexes is limited to 1,000. This paper discusses how SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 address this limitation by providing an option to increase the limit to 15,000 partitions. It describes how support for 15,000 partitions can be enabled and disabled on a database. It also talks about performance characteristics, certain limitations associated with this support, known issues, and their workarounds. This support is targeted to enterprise customers and ISVs with large-scale decision support or data warehouse requirements.  Read more...
By Additional Articles 2011/06/09 | Source: TechNet Blogs | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,229 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,131 reads

Getting the most out of your SQL Server 2008 Cluster

Gain an insight into how to use your SQL Server cluster for more than just high availibility in this article from Mark Jones.  Read more...
By Mark Jones 2011/05/26 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 3,842 reads

Upgrade Strategies for SQL Server 2008

If you make the decision to upgrade to 2008, there are a number of tools that make the process easier, but you still need to understand what things you should consider. We have a new article from Arshad Ali to help you understand the process and what you should consider.  Read more...
By Arshad Ali 2011/05/20 (first published: 2009/03/02) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 21,527 reads

SQL Server 2008 Build List

The list of builds for SQL Server 2008 updated SP4.  Read more...
By Steve Jones 2013/01/30 (first published: 2008/09/26) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 56,710 reads

More SQL Server 2008 Installation Issues

Robert Pearl brings us a few more potential SQL Server 2008 installation issues on Windows 7 and a few workarounds that might help you get around them.  Read more...
By Robert Pearl 2011/05/05 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 5,074 reads

SQL Server 2008 Installation Issues - Issues and Workarounds

MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.  Read more...
By Robert Pearl 2011/04/28 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 6,796 reads

The SQL Server 2008 Datetimeoffset Data Type

The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.  Read more...
By James Skipwith 2014/03/28 (first published: 2011/04/18) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 13,215 reads

Change Server Collation in SQL Server 2008

How can I change the collation of SQL Server 2008? Learn how in this short tutorial.  Read more...
By Kevin Sermijn 2011/03/15 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 5,927 reads
<< Newer    Items 21 to 40 of 315    Older >>