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 317    Older >>
 

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 36,356 reads

SQL Server Service Broker demystified

Simplified explanation of whats and hows of Service Brokers  Read more...
By Kautuk 2011/12/15 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 7,533 reads

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,697 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,358 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,296 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 | 57,503 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,809 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,885 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,567 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,498 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,978 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 | 57,503 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,470 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,294 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,141 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,860 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,594 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 | 57,503 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,086 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,811 reads
<< Newer    Items 21 to 40 of 317    Older >>