Fast Database File Creation for Large Databases in SQL Server 2005
This article describes how to enable Instant File Initialization in SQL Server 2005
2008-07-31
3,738 reads
Additional Articles
Investigating SQL Server 2008 Wait Events with XEVENTS
Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to look at those waits that are slowing your SQL Statements. Mario Broodbakker continues his series about SQL Server Wait Events
2008-07-30
2,343 reads
Using Column Sets with Sparse Columns
This article provides an overview of the use of Column Sets with Spare Columns in SQL Server 2008
2008-07-30
2,422 reads
Iterating through tables and databases in SQL Server
This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on.
2008-07-29
4,102 reads
SQLBits III - Registration Now Open!
Registration for SQLBits III, to be held at Hatfield in the UK on September 13th, is now open! SQLBits is the UK's finest SQL Server technical conference, and it's 100% free to attend!
2008-07-29 (first published: 2008-07-23)
1,837 reads
Loading XML data into SQL Server 2008
This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data
2008-07-28
2,854 reads
The Myth of Over-Normalization
Too often, denormalization is suggested as the first thing to consider when tackling query performance problems. It is said to be a necessary compromise to be made when a rigorous logical design hits an inadequate database system. As the saying goes, “Normalize ‘til it hurts, then denormalize ‘til it works”. In reality, Denormalization always leads eventually to tears.
2008-07-28
7,924 reads
How to configure and Use Database Backup Compression in SQL Server 2008
SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new feature
2008-07-25
2,029 reads
Monitoring Report Execution Performance with Execution Logs
This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services Step by Step, by Stacia Misner and Hitachi Consulting. Learn how to monitor reporting services by implementing an execution logging database and reviewing reports that query that database.
2008-07-25
2,797 reads
Develop Robust and Scalable Apps with SQL Server Data Services
Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.
2008-07-24
2,158 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU GANG TENGAH. Tlp:085373737845
Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
BCA KCP Kramat Jaya Baru Telp/Wa:0817819444
Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru, Kota Jakarta...
BCA KCU PANGERAN JAYAKARTA Telpon/WA:087768193341
BCA KCU PANGERAN JAYAKARTA Telpon/WA:087768193341.Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers