Browse by Tags

SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?

Published 14 May 8 3:23 AM | SSQA.net

I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...

Filed under: sql server, performance, blogs, ssms, dba, dmf, best practice, new features, resource governor, policy based framework

Query Execution Plans security and new feature within SQL Server 2008 Management Studio

Published 4 March 8 2:4 AM | SSQA.net

If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...

Filed under: sql server, performance, ssms, query, users, execution plan, monitoring, new features, .xml, plan cache, document, .sqlplan

How to set the Animation Speed and make best use of SQL Server Management Studio tool?

Published 1 October 7 8:12 AM | SSQA.net

SQL Server Management Studio (SSMS) is a powerful tool in SQL 2005 that is re-written from previous of SQL Server, that also reduces the flaky features from Enterprise Manager. How to set the Animation Speed and make best use of SQL Server Management...

Filed under: sql server, performance, ssms, management studio, automation, loading, ie

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.net

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

Published 17 August 7 8:4 AM | SSQA.net

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any...

Filed under: sql server, performance, memory, analysis, ssms, dmv, cpu, disks

Dust out few tasks to gain transactional replication performance in SQL 2005

Published 16 August 7 4:20 AM | SSQA.net

Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at...

Filed under: sql server, performance, integration, tuning, ssas, ssms, replication, transactional, hardware

Whats with 64 bit computing on SQL Server

Published 4 August 7 9:41 AM | SSQA.net

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage...

Filed under: sql server, performance, management, ssis, security, ssas, ssms, ssrs, x64, computing

An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

Published 26 July 7 7:49 AM | SSQA.net

Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider...

Filed under: sql server, performance, management, security, ssms, error, access, sql express, tcp, named pipes, remote

How to find that a query could benefit from an index?

Published 30 April 7 5:48 AM | SqlServer-QA.net (SSQA)

Performance is most required achievement in a multi-user environment, using SQL Server 2005 this can be achieved with a few statments execution. Firstly you need determine the issues by finding which query or queries are causing issues in achieving performance...

Filed under: sql server, performance, management, security, ssms, dmv