SQLServerCentral Article

The Basics of Sizing a SQL Server Database

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.

Technical Article

Performance Optimizations for the XML Data Type in SQL Server 2005

This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005. To get the most value from this paper, you need to be familiar with the XML features in SQL Server 2005. For background material, see XML Support in Microsoft SQL Server 2005 and XML Best Practices for Microsoft SQL Server 2005 on the Microsoft Development Network (MSDN)

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

BCA KCP Griya Utama Call CSO; (+62 821°3111°179

By Robert Sterbal-482516

Ruko Puri Mutiara, Jl. Griya Utama B Blk. D No.1-2, Sunter Agung, Kec. Tj....

BCA KCP Tomang Elok Telpon/wa:0821°8168°291

By fujinavn

BCA KCP Tomang Elok Telpon/wa:0821°8168°291.Jl. Taman Komp. Tomang Elok, Simpang Tj., Kec. Medan Sunggal,...

BCA KCP ITC Roxi Mas Telpn/wa (08218171891)

By sieuthimayspa

ITC ROXY MAS, Jl. Kh Hasyim Ashari No.125 Basement 13, Cideng, Kecamatan Gambir, Kota...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers