SqlServer-QA.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 an upgrade. Performance Studio builds on the concept of the Database Reports in SQL Server 2005 and the ...

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 of a hardware or software failure, also it could be one of the reasons such as ...

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 be used extensively with inter-dependnt constructions such as BEGIN...END with a ...

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 by measure group. Simplified and enhanced Aggregation Design and Usage-Based ...

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 must be identified and tuned. Few root causes for such blocking are: Insufficient resources, ...

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 version which is usage of VARDECIMAL with having table-level ...

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 consistency.  It means the consistency of transactional is taken care and ...

When L Wednesday, August 22, 2007 4:00 PM Eastern | 3 PM Central | 2 PM Mountain | 1 PM PacificHosted by: Microsoft, Edgewood Solutions & Idera Overview of Microsoft SQL Server 2008, code name ''Katmai'', the next generation of SQL Server. ''Katmai'' provides an enterprise data platform for your mission-critical applications, while ...

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 we have 5 new DMVs available with this CTP, here they are: sys.dm_os_memory_brokers This DMV is ...