2012-02-09 (first published: 2010-09-15)
10,192 reads
Articles
Learn about SQL Server 2012 in the desert
Come see Brad McGehee, Grant Fritchey, Steve Jones, and more SQL Server speakers at the SQL Server Connections conference in Las Vegas this spring. Get away from the cold on Mar 26, 2011 and learn about the new version of SQL Server.
2012-02-09 (first published: 2012-01-25)
4,069 reads
SQL Server 2008 and 2008 R2 Integration Services - Sort Transformation
SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing extraction, transformation, and loading tasks. While most of them are fairly straightforward to deploy in their basic form, typically there are refinements or caveats that should be taken into account as part of their implementation. This principle becomes quite evident when considering use cases of Sort transformation, which is the subject of this article.
2012-02-09
2,339 reads
Database Performance Transparency
Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.
2012-02-08
6,950 reads
Rebuilding SQL Server indexes using the ONLINE option
As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.
2012-02-08
4,386 reads
2012-02-07 (first published: 2010-09-08)
9,755 reads
TSQL function to detect SQL Agent job state
This article has a T-SQL function to detect the SQL Agent job state.
2012-02-07
9,615 reads
Converting String Data to XML and XML to String Data
In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.
2012-02-07
4,207 reads
Aggregate Function Product()
The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.
2012-02-06
10,350 reads
TSQL Challenge 75 - Find the Episode and Sequence based on interval
The challenge is to find the Episode and Sequence based on interval.
2012-02-06
1,273 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
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