An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,480 reads
Timothy A Wiseman
- Interests: SQL Server, Python, Go, Mathematics, Legal Issues
Going From Many Schemas To One Schema
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,403 reads
Undocumented Extended and Stored Procedures
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,453 reads
2009-01-17 (first published: 2008-05-28)
4,237 reads
2008-12-02
9,122 reads
2008-10-23 (first published: 2008-08-24)
1,915 reads
2008-09-09
12,788 reads
CTEs in Report Creation
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,159 reads
Reading Ad Hoc Text Files with OpenDataSource
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
10,377 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers