What is Default Trace?

A default trace in SQL Server is a standard server side trace which is installed by default ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/6RdOsqA3yyA/default_trace_intro_p1.aspx

xx [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/CBMdFmJgZlE/windows_server_2008_r2_task_manager_p1.aspx

In most companies, roles and responsibilities are clearly defined for the various teams, whether it is the database team, application team or the development team. In some cases, the application team might own a number of jobs but they ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/H7FKiB6wI7U/sql_server_job_proxy_account_p1.aspx

A few years ago there was an MSDN forum post:

My SQL Server is accessed by several end user applications. When all the applications are in action my server performance is going down. Some of those applications are business ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/uHbidTm-k1k/resource_governor_system_resources_p1.aspx

Adding a column to a table is common task for DBAs. You can add a column to a table which is a nullable column or which has default values. But are these two operations are similar internally and ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/f-Wjwdgebwk/add_column_sql_server_table_p1.aspx

There is a handy little tool in Windows Server 2008 R2 that can help system administrators and DBAs better diagnose server performance issues. It’s called the Resource Monitor. Resource Monitor is also present in Windows Server 2008, but its interface ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/dXJua96fWeI/performance_windows_resouce_monitor_p1.aspx

In Troubleshooting Performance with Resource Monitor Part 1 we looked at getting with started the Resource Monitoring interface and using the CPU tab to diagnose performance issues.

The Memory tab

The Memory tab is different from others in ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/0qBKg684_tU/performance_windows_resouce_monitor_pt2_p1.aspx

Introduction

Database Administrators have always had a tough time to ensuring that all the SQL Servers administered by them are configured according to the policies and standards of organization. Using SQL Server's Policy Based Management feature DBAs can now ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/k2Gv_QHqolM/settings_policy_based_management_p1.aspx

This article outlines the main techniques for optimizing queries running on SQL Azure.

http://feedproxy.google.com/~r/sqlserver-articles/~3/Gq1L8guxrc0/sql_azure_query_p1.aspx

It is nothing really new that indexes have their right to exist in SQL Server. It is also nothing really new, that these indexes need to be maintained every now and then, even though this might be surprising for ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/l0Wt-fuhrc0/index_maintenance_performance_p1.aspx

With 64 bit versions of Windows fast becoming the standard it is imperative that an app work in both 32 bit and 64 bit environments, this article demonstrates how to ensure your app can work in ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/k8ahRyzfqL0/32bit_64bit-envirnoments_p1.aspx

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell's flexibility by creating a set of commands customized to our needs. ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/WyNw8_QthUs/powershell_sql_server_example_p1.aspx

Problem

When using transactional replication to replicate data in a one way topology from a publisher to a read-only subscriber(s) there is no need to manage identity ranges. However, when using transactional replication to replicate data in a two way ... [Read Full Article]

http://feedproxy.google.com/~r/sqlserver-articles/~3/bBblg6iZAKM/identity_ranges_transactional_replication_p1.aspx