Browse Blog Posts by Tags

All Tags » SQL Server » 2005 (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 20 2009
Filed under: Filed under: sql server, performance, error, 2008, 2005, reports, 701, batch size
SQL Server 2005 Service Pack 3 (SP3) is released

From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Dec 16 2008
Filed under: Filed under: sql server, download, update, BOL, best practices, 2005, service pack, sp3
Download SQL Server 2005 Books Online - Updated DECEMBER 2008

Here is another update on Books Online (BOL) for SQL Server 2005 - Download an updated version of the documentation and tutorials, to see what kind of updates are updated in the documentation once you downloaded & install see the " Additional...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Dec 15 2008
Filed under: Filed under: sql server, download, update, 2005, books online
Recover a database with no transaction log file - SQL Server 2005!

Have you ever been in a situation that one of the database has been giving hard time! It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Nov 11 2008
Filed under: Filed under: sql server, ssms, error log, suspect, 2005, corrupted, detach, attach, dataabase
SQL Server 2005 Multi-Site Clustering with Windows Server 2008

I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Nov 2 2008
Filed under: Filed under: sql server, high availability, 2008, clustering, 2005
SQL Server 2005 Service Pack 3 - public beta for your action

As promised by SQL Server Developmen team about SQL Server 2005 SP3 the public beta is now available for your action and set of tasks for your 2005 environment. So what this public beta provides, this is a rollup Quick Fix Engineering that will have all...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Oct 30 2008
Filed under: Filed under: sql server, beta, users, ctp, 2005, public, developement, new features, service pack3, sp3
SQL Server 2005 Enterprise & Standard Editions Knowledge Base Notifications

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: A SQL Server Agent job that creates a ServerXMLHTTP object by using an ActiveX script remains in the Executing status and is never completed in...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 21 2008
Filed under: Filed under: sql server, kba, x64, 2005, enterprise edition, standard edition
Updated: Support Policy for SQL Server on Virtualised Platforms

The support policy for SQL Server running on virtualised platforms has now been updated to include support for SQL Server 2005 running on Hyper-V http://support.microsoft.com/?id=956893 Microsoft provides technical support for SQL Server 2005 and for...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 8 2008
Filed under: Filed under: sql server, windows, 2008, support, 2005, Hyper-V
Avoiding access to base tables using Foreign Key, and two suggestions...

Just a note before going further: I am going to maintain my blog in Spanish and English: The English version will be hosted at msmvps.com ( http://msmvps.com/blogs/eladio_rincon ) The Spanish version will be hosted at Solid Quality Mentors blog -- El Rincón del DBA ( http://blogs.solidq.com/ES/ElRinconDelDBA...

Posted to Eladio Rincón by Eladio on Mon, Aug 25 2008
Filed under: Filed under: 2000, 2008, 2005, SQL Server, Curiosidades, SQL Server 2005, SQL Server 2008, Suggestions, Connect
Conectar desde un SSIS a Excel/Access desde 64bits

Más de una vez me lo han preguntado y he aquí una solución: http://ssis.trigonblue.com/Excelin64bitenv/tabid/523/Default.aspx Otra solución puede ser montar un SQL Express/Instancia SQL Server 32 bits y usar los drivers 32 bits. Por cierto, también está disponible, el driver OLEDB para ODBC en 64 bits...

Posted to Eladio Rincón by Eladio on Mon, Aug 18 2008
Filed under: Filed under: 2005, SQL Server, SSIS
Cumulative Update 8 package for SQL Server 2005 Service Pack2

I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jul 16 2008
Filed under: Filed under: sql server, blogs, best practices, service pack2, 2005, cumulative update, cu7
Get ready for SQL Server 2008 RTM release!

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 is set to RTM'd during the month of August 2008, as per Bob...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 14 2008
Filed under: Filed under: sql server, developer, users, 2008, 2005, visual studio, launch, windows server, rtm, itpro, rc0
Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005

SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jul 11 2008
Filed under: Filed under: sql server, 2008, 2000, reporting services, 2005, new features
KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New SQL Server 2005 installers...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 12 2008
Filed under: Filed under: sql server, instance, kba, installation, 2000, 2005, msde
SQL Server 2005 Performance Dashboard

I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 12 2008
Filed under: Filed under: sql server, performance, tools, 2005
SQL Server High Number of User Connections found on PERFMON, how to resolve it?

I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jun 3 2008
Filed under: Filed under: sql server, performance, sysmon, 2000, 2005, high cpu, perflib, activity, user connections, mars
Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy

Are you visiting Tech-ed, North America? Tech·Ed offers the premier technical education conference just for IT professionals. Microsoft and industry experts will share their expertise about how to architect, deploy, manage, and help secure a connected...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 29 2008
Filed under: Filed under: sql server, high availability, tech-ed, 2008, 2005, online, panel, discussion
Support Webcast: Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008

A new Level 300 support webcast has been scheduled for Monday the 9th of June, 10:00 AM Pacific Time. The summary of the session is as follows: This Support WebCast focuses on how to plan, implement, and administer a Microsoft SQL Server 2005 failover...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 19 2008
Filed under: Filed under: sql server, windows, 2008, clustering, 2005
SQL Server Locking

Locking is a mechanism used by the Microsoft SQL Server Database Engine to synchronize access by multiple users to the same piece of data at the same time. Before a transaction acquires a dependency on the current state of a piece of data, such as by...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, May 18 2008
Filed under: Filed under: sql server, 2000, 2005
SQL Server Statistics

SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Good statistics allow...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, May 16 2008
Filed under: Filed under: sql server, 2005, Database Maintenance

Page 1 of 5 (95 items) 1 2 3 4 5 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags