SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tag SQL Server 2008 Rss

Refine your search with one of the following additional tags (with number of items):

News (7)     Compression (2)     DMF (1)     Performance Tuning (1)    
T-SQL (6)     Integration Services (2)     HierarchyID (1)     Policy Based Management (1)    
Data Types (3)     Administration (1)     Indexing (1)     Security (1)    
Datetime Manipulation (3)     Change Data Capture (1)     Installation (1)     Spatial Data (1)    
Auditing (2)     Compliance (1)     Miscellaneous (1)     SQL Server 2005 (1)    
Backup and Recovery (2)     dd (1)     PBM (1)     Table Valued Parameters (1)    

Search for any content tagged SQL Server 2008

   Items 1 to 20 of 34    Next 20 >>
 

Dependency Tracking in SQL Server 2008

People reading this post might really wonder of having read /heard about a concept on Dependency tracking in SQL Server 2008. It is nothing, but a set of built in existing SYS objects and their effective usage that help us save time & tedious efforts.  Read more...
By Additional Articles 2008/05/22 | Source: SQL Community | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 4 reads

Row Value Constructor in SQL Server 2008

This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.  Read more...
By Additional Articles 2008/05/16 | Source: Database Journal | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 13 reads

Using Policy-Based Management in SQL Server 2008

As we are reviewing the new features in SQL Server 2008, we found one that looks really interesting - Policy-Based Management. Could you help us to understand how this works and provide some examples? Can you please explain each of the components and how to manage them in the interface and with commands?  Read more...
By Additional Articles 2008/05/16 | Source: MSSQLTips.com | Category: Policy Based Management
Rating: (not yet rated)  Rate this |  Briefcase | 4 reads

Tuning the Performance of Backup Compression in SQL Server 2008

ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not  Read more...
By Additional Articles 2008/05/12 | Source: MSDN Communities | Category: Backup and Recovery
Rating: (not yet rated)  Rate this |  Briefcase | 557 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & 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 2008/05/05 | Source: SQLServerCentral.com | Category: Compression
Rating: |  Discuss |  Briefcase | 7,543 reads

UPSERT Functionality in SQL Server 2008

This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.  Read more...
By Additional Articles 2008/04/24 | Source: Database Journal | Category: SQL Server 2008
Rating:  Rate this |  Briefcase | 4,083 reads

The HierarchyID Datatype in SQL Server 2008

This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.  Read more...
By J P R 2008/03/25 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 6,617 reads

SQL Server 2008 security and compliance features reduce security risks

Looking at this from a confidentiality, integrity and availability perspective – the essence of security and compliance – there are quite a few new selling points.  Read more...
By Additional Articles 2008/03/24 | Source: SearchSQLServer | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 824 reads

Microsoft SQL Server 2008 - Change Data Capture – Part 2

Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.  Read more...
By Additional Articles 2008/02/28 | Source: Database Journal | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,453 reads

SQL Server 2008 - Table Valued Parameters

In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.  Read more...
By Additional Articles 2008/02/27 | Source: Microsoft MSDN | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,594 reads

New Data Types in SQL Server 2008 Part 3

This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.  Read more...
By Additional Articles 2008/02/22 | Source: SQL Server Performance | Category: Data Types
Rating: (not yet rated)  Rate this |  Briefcase | 2,781 reads

New Data Types in SQL Server 2008 Part 2

In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.  Read more...
By Additional Articles 2008/02/20 | Source: SQL Server Performance | Category: Data Types
Rating:  Rate this |  Briefcase | 2,905 reads

SQL Server 2008 New DATETIME DataTypes

This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions.  Read more...
Rating:  Rate this |  Briefcase | 2,994 reads

Featured Blog: SQL Server 2008: Partition-level lock escalation details and examples

Paul Randal of SQLskills takes a look at lock escalation in SQL Server 2008  Read more...
By Additional Articles 2008/01/30 | Source: SQLskills | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 877 reads

Katmai Delayed

SQL Server 2008, Katmai, apparently won't ship in Q2. Looks like a Q3 possibility now.  Read more...
By Steve Jones 2008/01/25 | Category: SQL Server 2008
Rating: (not yet rated) |  Discuss |  Briefcase | 34 reads

Microsoft SQL Server 2008 - Change Data Capture – Part I

Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.  Read more...
By Additional Articles 2008/01/25 | Source: Database Journal | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,696 reads

Featured Blog: SQL Server 2008: Spatial indexes

Paul Randal talks about the new spatial data types and their indexes.  Read more...
By Additional Articles 2008/01/23 | Source: SQLskills | Category: SQL Server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,880 reads

New datetime datatypes in SQL Server 2008

Older versions of SQL Server had only one datatype to store both the date and time values. In SQL Server 2008, Microsoft introduces a set of new datatypes that store date and time individually, and both date and time together.  Read more...
By Additional Articles 2008/01/21 | Source: Database Journal | Category: SQL Server 2008
Rating:  Rate this |  Briefcase | 1,918 reads

Installing SQL Server 2008

This article highlights the steps involved to install SQL Server 2008.  Read more...
By Additional Articles 2007/12/27 | Source: Database Journal | Category: SQL Server 2008
Rating:  Rate this |  Briefcase | 2,000 reads

Using the DATE data type in SQL Server 2008

In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.  Read more...
By Additional Articles 2007/12/18 | Source: SQLTeam.com | Category: Datetime Manipulation
Rating:  Rate this |  Briefcase | 2,076 reads
   Items 1 to 20 of 34    Next 20 >>
 
Most popular

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & 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 2008/05/05 | Source: SQLServerCentral.com | Category: Compression
Rating: |  Discuss |  Briefcase | 7,543 reads

Passing a Table to a Stored Procedure

SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.   Read more...
By Jacob Sebastian 2007/09/12 | Source: SQLServerCentral.com | Category: News
Rating: |  Discuss |  Briefcase | 12,637 reads

The HierarchyID Datatype in SQL Server 2008

This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.  Read more...
By J P R 2008/03/25 | Source: SQLServerCentral.com | Category: SQL Server 2008
Rating: |  Discuss |  Briefcase | 6,617 reads