Other SQL Server Blogs around the Web

Browse by Tags

• 2008
• administrator
• agent
• Analysis Services
• ascmd
• blocking
• broker
• certification
• command line
• course
• cube
• data mining
• databases
• diagnose
• dll
• dump
• ebooks
• exception
• failure
• file
• fragmentation
• index
• integration
• kba
• learning
• load library
• locking
• loss
• memory
• Microsoft
• parallel
• performance
• press
• profiler
• publisher
• query
• replication
• samples
• security
• server
• services
• sql server
• ssis
• statiscs age
• statistics
• stored procedure
• subscriber
• sysmon
• table
• timeout
• tool
• trace
• whatsnew

• SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

  Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services ... Posted Feb 18 2008, 03:57 AM by SSQA.net Filed under: sql server, performance, security, process, profiler, databases, administrator, sysmon, Analysis Services, diagnose

• SQL Server 2005 methods to find table INDEX or Statistics age for better performance

  Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller... Posted Jan 09 2008, 02:55 AM by SSQA.net Filed under: sql server, performance, statistics, process, index, timeout, query, agent, statiscs age

• Certification path for SQL Server 2008

  As SQL Server 2008 is still in CTP process Microsoft learning has already announced the process in getting certification in this new version. Not only with Learning opportunities Microsoft Press also offering freebies by the way of ebooks and press newsletter... Posted Dec 14 2007, 06:22 AM by SSQA.net Filed under: course, certification, press, sql server, Microsoft, 2008, whatsnew, process, learning, ebooks

• Monitoring the parallel processing performance of Analysis Services?

  The ascmd.exe command-line utility is a handy tool for testing performance characteristics to determine the appropriate values for parallel processing. This utility is similar to the sqlcmd.exe utility that you use to execute SQL statements in SQL Server... Posted Oct 08 2007, 03:08 AM by SSQA.net Filed under: sql server, performance, process, tool, samples, Analysis Services, data mining, parallel, command line, ascmd

• FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: When you start a merge agent, synchronization between the subscriber and the publisher... Posted Sep 11 2007, 04:36 PM by SSQA.net Filed under: sql server, process, kba, replication, publisher, subscriber, broker

• How to use a stored procedure to monitor traces in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to use a stored procedure to monitor traces in SQL Server 2005 http://support... Posted Sep 04 2007, 11:39 AM by SSQA.net Filed under: sql server, stored procedure, process, trace, profiler, kba

• How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to enable the SQL Server 2005 Integration... Posted Aug 30 2007, 02:56 PM by SSQA.net Filed under: sql server, ssis, process, kba, exception, integration, services, file, dump

• While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command

  Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is... Posted Aug 27 2007, 05:47 AM by SSQA.net Filed under: sql server, performance, process, server, memory, Analysis Services, cube

• Error messages after SQL Server 2005 has been running for some time: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process with errors pointing to LoadLibrary failure"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error messages after SQL Server 2005 has... Posted Aug 23 2007, 04:02 PM by SSQA.net Filed under: sql server, process, kba, failure, load library, dll

• Table fragmentation, Index contention and locking issues to resolve

  Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to... Posted Jul 31 2007, 09:31 AM by SSQA.net Filed under: sql server, performance, blocking, table, process, trace, profiler, locking, fragmentation, loss