Browse by Tags

SQL Server 2008 - Performance Studio

Published 20 June 8 11:50 AM | SSQA.net

I've been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it's pretty cool ! Along with Resource Governor and compression, it's one of my favourite new features and a good reason to consider...

Filed under: sql server, performance, tools, 2008

SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)

Published 2 May 8 9:12 AM | SSQA.net

Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because...

Filed under: sql server, performance, ssas, features, 2008, whitepaper, Analysis Services, scalability

SQL Server 2008 - TSQL behavioural changes and enhancements

Published 31 March 8 2:0 PM | SSQA.net

As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...

Filed under: sql server, performance, transaction, article, 2008, tsql, enhancement, begin

SQL Server 2008 BI enahncements - what you want is what you get!

Published 25 February 8 2:49 PM | SSQA.net

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped...

Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services

SQL Server 2008 Resource Governor FAQ

Published 25 February 8 1:36 AM | SSQA.net

Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...

Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor

SQL Server 2008 Data Compression, what it is - how does it work?

Published 3 December 7 7:54 AM | SSQA.net

As you know data compression facility is added onto the SQL Server 2008 version, though this is not a new feature and I would call it as an enhanced feature in SQL Server. This subject of data compression has already been introduced in SQL Server 2005...

Filed under: sql server, performance, microsoft, blogs, security, 2008, ctp, data capture, 2005, compress, data compression

Filestream datatype - what it is?

Published 1 October 7 3:31 AM | SSQA.net

My question is have you looked into the CTP4 Books online for SQL 2008? This is new to SQL Server arena, the FileStream data type which allows large binary data to be stored in the file system and yet remain an integral part of the database with transactional...

Filed under: sql server, performance, microsoft, 2008, ctp, new, data type, filestream

SQL Server 2008 – First Look (Live Webcast) by Microsoft and Vendors

Published 17 August 7 2:45 AM | SSQA.net

When L Wednesday, August 22, 2007 4:00 PM Eastern | 3 PM Central | 2 PM Mountain | 1 PM Pacific Hosted by: Microsoft, Edgewood Solutions & Idera Overview of Microsoft SQL Server 2008, code name "Katmai", the next generation of SQL Server...

Filed under: sql server, performance, webcast, microsoft, 2008, idera, edgewood

Whats new with SQL 2008 July CTP - new DMVs for memory management

Published 4 August 7 4:40 AM | SSQA.net

As this is the 2nd instalment of public CTP of SQL Server 2008 we will be expecting more information on 'whats new' and 'whats not (deprecated)'. For me (majority of you too) having handful information with DMVs is essential, in this regad...

Filed under: sql server, performance, dmv, 2008, whatsnew, system state