June 2007 - Posts

Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

Published 30 June 7 5:1 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Cumulative hotfix package (build 3152) for SQL...

Filed under: sql server, kba, hotfix

FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication

Published 30 June 7 5:0 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: A foreign key constraint that you drop on...

Filed under: sql server, replication, kba, merge, subscriber, publisher

FIX: A SQL Server assertion is logged in the Errorlog file when the Log Reader Agent runs for a transactional publication in SQL Server 2005

Published 30 June 7 4:58 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: A SQL Server assertion is logged in the...

Filed under: sql server, kba, log reader, assetion, errorror

Avoid Business Intelligence Performance Problems! - Size and Configure Hardware to Meet User SLAs Podcast

Published 29 June 7 12:34 PM | SSQA.net

This Podcast examines single and multi-tier BI architectures and components (ETL, DW, ODS, Data Mart, OLAP Cubes). Specifically, the Podcast addresses questions to consider when sizing new BI applications. Learn why configuring a "balanced architecture"...

Filed under: ssis, ssas, podcast, business, intelligence, configure, sla

Using table-valued functions (TVF) in SQL Server

Published 29 June 7 3:13 AM | SSQA.net

I was looking for more information on Table-Valued Functions (TVF) in SQL Server in attempting to perform sophisticated text analysis using the built-in string functions using .NET. To the subject using regular expressions are not new to SQL. These regular...

Filed under: sql server, performance, memory, function, tvf, feature, table-valued, .NET

FIX: An SSIS package stops responding when you run the package and the package contains a data flow task that contains one or more MergeJoin transformations in SQL Server 2005

Published 28 June 7 3:8 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: An SSIS package stops responding when you...

Filed under: sql server, performance, ssis, kba, stops

FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup of a database that is larger than 2 terabytes: "Unable to obtain required information about the server"

Published 28 June 7 12:42 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup...

Filed under: sql server, backup, database, kba, storage

FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after you install SQL Server 2005 Service Pack 2

Published 28 June 7 12:41 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after...

Filed under: sql server, ssis, kba, bids

SQL Server 2005 Design Considerations for Migration

Published 28 June 7 12:26 PM | SSQA.net

Scalability is a major concern when preparing your SQL Server 2005 migration. With database growth, in size and number, common challenges revolve around meeting performance requirements and being able to complete business processes in time. Attend this...

Filed under: sql server, databases, webcast, storage, growth

Can't find linked server in management studio?

Published 28 June 7 9:41 AM | SSQA.net

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...

Filed under: sql server, management, security, server, ssms, enterprise, sql express, oracle, linked

FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used

Published 27 June 7 11:52 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error messages when you run a query against...

Filed under: sql server, server, query, kba, table, linked, alias

Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services

Published 27 June 7 11:51 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Reporting Services Notification Contents: New and All Modifications Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services http...

Filed under: sql server, webcast, server, reporting, kba, assembly

FIX: In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL Server error log and in the Application log

Published 27 June 7 11:50 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL...

Filed under: sql server, kba, error log

KBA: A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1

Published 27 June 7 11:48 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications A list of the bugs that have been fixed in SQL...

Filed under: sql server, kba, standard, enterprise, x64, sp1

FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005

Published 27 June 7 11:46 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: You may receive error 1203 when you run...

Filed under: sql server, kba, standard, edition, enterprise, x64, insert

KBA: Microsoft SQL Server support policy for Microsoft Clustering

Published 27 June 7 11:44 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications The Microsoft SQL Server support policy for Microsoft Clustering http://support.microsoft.com/kb/327518/en-US...( read more ) Read...

Filed under: sql server, kba, support, clustering

FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server

Published 27 June 7 11:42 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run the CHECKPOINT statement after you restore a database...

Filed under: sql server, restore, database, kba, access, checkpoint, denied

SQL Server 2005 Performance Dashboard Reports - making most out of it!

Published 26 June 7 4:19 AM | SSQA.net

Another set of reports you can generate using SQL Server 2005 Performance Dashboard Reports, this is mainly useful to monitor and resolve performance problems on your SQL Server 2005 database server using the Management Studio client. The reports allow...

Filed under: dashboard, sql server, performance, databases, dba, reporting

IT's Showtime - Business Intelligence events

Published 25 June 7 3:58 PM | SSQA.net

This series of on-demand videos provides a detailed look into Microsoft's approach to business intelligence (BI). EventShow...( read more ) Read More...

Filed under: sql server, webcast, business, intelligence, ondemand

Does rebuilding a clustered index rebuild nonclustered indexes?

Published 25 June 7 3:45 PM | SSQA.net

Does rebuilding a clustered index rebuild nonclustered indexes? I have discussed this question with one of SQL Server MVP recently, eventually both were correct to the point. Lately I have found KhenBlog on the subject, interesting....( read more ) Read...

Filed under: sql server, performance, indexes, rebuild, clustered