SQL Server 2008 Table Valued Parameters Performance
An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.
2010-07-08
9,896 reads
Articles
How to add NULL Defense to your SSIS packages using scripting
In this part of NULL Defense series, we will discuss how to create NULL Defense in Script Transformation.
2010-07-08
3,480 reads
Find the Port a Connection is Using
If you have multiple ports, this article from Mark Greenbaum will tell you which port a connection is using
2010-07-07
8,053 reads
Data Warehousing Architecture - Designing the Data Staging Area
The staging area tends to be one of the more overlooked components of a data warehouse architecture, and yet it is an integral part of the ETL component design. Learn why it is best to design the staging layer right the first time, enabling support of various ETL processes and related methodology, recoverability and scalability.
2010-07-07
6,197 reads
Performance Impacts Related to Different Function Types
The July 2010 PASS Performance VC Presentation by Jason Strate on July 6th 12:00 PM EDT (GMT -4).
2010-07-06 (first published: 2010-07-01)
3,239 reads
SSIS Package to Script All SQL Server Jobs to Individual Files
The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.
2010-07-06
12,961 reads
Multi-parameter CLR aggregate in SQL Server 2005
How is it possible to pass multiple parameters to a SQL Server 2005 CLR aggregate?
2010-07-06
2,370 reads
Physical Join Operators in SQL Server - Merge Operator
Part II of the Physical Joins series looks at the Merge operator.
2010-07-05
4,112 reads
There Must Be 15 Ways To Lose Your Cursors… Part 2
Learn to use Where, Claire. Plus a conversion methodology, a test harness and more!
2010-07-02 (first published: 2009-04-27)
28,417 reads
Reporting Services 2008 R2: Geospatial Visualization – Part I
Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.
2010-07-02
3,764 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers