TSQL Challenge 74 - Find the expiring quantity of material
The challenge is to create a query for a report that show expiring material
2012-01-23
931 reads
Articles
Using the MERGE Statement in SSIS Via a Stored Procedure
Step-by-step instructions how to build a stored procedure that dynamically constructs and executes a merge statement within SSIS.
2012-01-23
15,188 reads
Tom LaRock's SQL Server Howlers
In this next article in our series where well-known SQL Server people write about their favorite SQL Server Howlers, we asked Tom Larock for his top five common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions.
2012-01-23
3,823 reads
Sub query expressions vs. Joins.
Do sub query expressions introduce a performance penalty on retrieving large data sets?
2012-01-20 (first published: 2010-07-22)
28,790 reads
Incorporating XML into your Database Objects
XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check constraints, computed columns and defaults. Views and table-valued functions can be used to provide a tabular view of XML data that can be used in SQL Expressions. Robert Sheldon explains how.
2012-01-20
2,557 reads
2012-01-19 (first published: 2010-07-21)
9,126 reads
PASS Data Architecture Virtual Chapter presents Audrey Hammonds – Database Makeover: Renovate You Data Model
On Thursday January 19th at 12 noon Central, Audrey Hammonds will discuss renovating your data model while keeping you’re the production system humming
2012-01-19
1,869 reads
Restoring SQL Server System Databases MSDB and Model
Due to a recent rebuild of the master database for a SQL Server instance, I now need to restore the msdb and model databases. In this tip we walk through the process that you need to follow to restore the model and msdb databases successfully.
2012-01-19
3,183 reads
Setting Up Email Notification for SSIS Package Failure
As a DBA, we often setup monitoring to receive job failure notification, but when it comes to SSIS packages, we either do not capture the job failure (if the job runs through the command prompt) or we have no idea why it failed. In this article, I'd like to walk you through how to enable the logging functionality for SQL Server Integration Services (SSIS) and how to capture detailed information for immediate troubleshooting without "re-run" the package.
2012-01-18
2,927 reads
A script task alternative to a massive SSIS multicast transformation
A Multicast Transformation can be used to write the same data file to multiple network folders, but it can be tedious and time-consuming to set up as the number of destination files grows. Learn how you can use this transformation in this article by Stan Kulp.
2012-01-17
4,644 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
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name