One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced on NUMA systems than basic SMP systems. A NUMA system with 16 processors can have significantly lower throughput capability than an otherwise comparable 4-way SMP system.

Conducting a SQL Server Operational Audit

by Chad Miller

SQLServerCentral.com

Administration

Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.

Index Creation Guidelines

by Leo Peysakhovich

SQLServerCentral.com

Performance Tuning

Index Creation Guidelines for SQL Server can be pretty sparse. Usually there are a couple, clustered index for ranges, nonclustered, etc. Leo Peysakhovich has taken some time to write down his guidelines based on his experience for creating indexes and the rational for doing so. He's also taken a few minutes to look at which indexes NOT to create, something that might be worth knowing..

VIEWS: The Key to Database Agility

by Additional Articles

SQLServerCentral

Advanced

There is an important technique for creating truly agile databases that I haven’t seen in his writings; one which is well-known to DBAs, but little understood in the application development community – the use of database views to create a layer of abstraction between the normalized relational tables and the applications that use the data.

Have You Been Told Today

by Frank Loschiavo

SQLServerCentral.com

SQL Server 2000 has a great job and alert subsystem, but it doesn't do everything. There are times when you want to be notified that something has completed, or not completed. New author Frank Loschiavo brings us a way to ensure that when you run a query you are notified if and when it completes.

Introduction to MSSQL Server Analysis Services: Introducing Data Sourc

by Additional Articles

SQLServerCentral

Analysis Services (SSAS)

In this article, I will introduce a significant improvement that underlies the new Analysis Services development approach, the Data Source View. A Data Source View is a design-time object that makes its home in the workbench environment of the Business Intelligence Development Studio.

Generating Permutations in T-SQL

by Eli Leiba

SQLServerCentral.com

Advanced Querying

In testing your applications, one of the things that you often want to do is run through a list of all possible values for some particular piece of code. Eli Leiba brings us a method for autmatically generating all the possible permutations for input values.

The Steps to monitoring greatness

by Additional Articles

Other

Monitoring

SQL Server Profiler can correlate Microsoft Windows System Monitor (Performance Monitor in Windows NT 4.0) counters with SQL Server or SQL Server 2005 Analysis Services (SSAS) events. Windows System Monitor logs system activity for specified counters in performance logs. The first thing to remember is in order to have correlating information you need to obviously be in sync - in other words you must start the perfmon trace and profiler trace at the same time or else they won't match up.

How to find that job is running?

by Leo Peysakhovich

SQLServerCentral.com

Administration

Have you ever wanted an easy way to determine if a job is running for automated checks? This might not be an easy way, but Leo Peysakhovich provides a way that works and corrects an error in Books Online.

Database Geek of the Week - Gary Mallow

by Additional Articles

Redgate

Interviews

Database geeks are all around us. I met Gary Mallow on the email list of a cycling group run by a local church. After some conversation, I discovered that he is a director of a group of developers who build applications, sometimes using .NET and often using Oracle as a database. Like me, Gary is not entirely comfortable with his ability as a UI developer, and so finds database work a good fit.

High Call Volume SQL Server Applications on NUMA Systems

Conducting a SQL Server Operational Audit

Index Creation Guidelines

VIEWS: The Key to Database Agility

Have You Been Told Today

Introduction to MSSQL Server Analysis Services: Introducing Data Sourc

Generating Permutations in T-SQL

The Steps to monitoring greatness

How to find that job is running?

Database Geek of the Week - Gary Mallow

Blogs

Getting the SQL Server MCP Server Running

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

Rambling about Data on Wheels – origins, branding, expansion

Forums

Alamat Kantor BCA KCU Wahid Hasyim Telp:0817825533

Alamat Kantor BCA KCU Thamrin Telp:0817825533

Alamat Kantor BCA KCU Scbd Telp:0817825533

Question of the Day

DBCC CHECKDB Limits III