Make an SSIS package Delay or Wait for Data
Packages can be scheduled to run at a time when you expect data to be in a database. Instead of...
2014-07-30 (first published: 2014-07-21)
12,239 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-14 (first published: 2014-04-07)
3,246 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-07
421 reads
SSIS Web Service Task
The Web Service task in SSIS can be used to call a web service command to perform a needed operation...
2014-03-31
4,515 reads
SSIS Web Service Task
The Web Service task in SSIS can be used to call a web service command to perform a needed operation...
2014-03-31
929 reads
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
2,243 reads
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
399 reads
Using Configuration Files in SSIS
Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I...
2014-03-20 (first published: 2014-03-17)
3,449 reads
Using Configuration Files in SSIS
Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I...
2014-03-17
437 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-13 (first published: 2014-03-03)
2,946 reads
Blogs
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Forums
How to determine if a DB is currently being used
Hi - I'm looking for advice regarding the best & quickest way to establish...
Data cleansing/conversion tool HPE
Hello. I am looking for a tool Data cleansing/conversion, was recommended HPE any...
System views in a contained availability group
I have a query that runs in a job to check on orphaned users....
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers