Raw Materials - Alternative Energy
Revenge is a dish best served cold, but body temperature's OK, too.
2011-08-09 (first published: 2009-07-22)
9,338 reads
Articles
Simplify Large Queries with Temporary Tables, Table Variables and CTEs
This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.
2011-08-09
10,341 reads
Automatically Capturing SQL Server Performance Metrics
This article looks to provide a method that you can use to collect the author's top 10 SQL Server performance metrics automatically over time.
2011-08-09
4,684 reads
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
2011-08-08
22,859 reads
TSQL Challenge 62 - Break a long sentence in groups of 5 words
Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.
2011-08-08
1,215 reads
Adding the Script Task to Your SSIS Packages
Script tasks are a great way of extending SSIS functionality, when none of the built-in components are quite right for the task you need to perform. But how to go about creating a script task? No worries, once again Robert Sheldon is on hand to provide easy instructions on how to do it.
2011-08-08
3,543 reads
Free Two User License SourceGear Vault Professional
Read more about how you can get a free two user license from SourceGear and Red Gate Software.
2011-08-05 (first published: 2011-07-05)
3,319 reads
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
9,012 reads
How to Compare the Data in Two Tables Without Any 3rd-Party Tool?
SQL Server ships with the tablediff utility which can be used to compare the data in two tables. Read this article to learn it step-by-step:
2011-08-05
5,442 reads
2011-08-04 (first published: 2009-07-15)
10,124 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers