Writing Dynamic Stored Procedure
In this article I have shown a way of writing queries in which WHERE clause of the query is executed dynamically depending on values of input parameters.
2009-06-01
19,357 reads
Articles
Configuring Auto-Retry on SQL Server Agent
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.
2009-06-01
3,877 reads
We Loaded 1 Terabyte in 30 Minutes with SSIS, and So Can You
In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios.
2009-06-01
7,208 reads
Making Mistakes - Database Weekly (June 1, 2009)
We all make mistakes, even when we are trying to help others. What should you do about it? Steve Jones has a few thoughts on advice online.
2009-05-30
503 reads
No More SOX
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
2009-05-30
650 reads
No More SOX
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
2009-05-30
652 reads
No More SOX
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
2009-05-30
890 reads
ROW_NUMBER(): An efficient alternative to subqueries – Scenario 2
Introduction In the first article I discussed how the ROW_NUMBER() function can cut down resources spent on queries dealing with versioning. In this article I will discuss how the ROW_NUMBER() function can help when dealing with range requirements. The code samples are available for download. The name of the file is RowCountScenario2-CodeDownload.sql. Scenario 2 – […]
2009-05-29 (first published: 2009-05-26)
10,642 reads
User Preferences and Styling
This article from Brian McDonalds shows how to allow style preferences from within SQL Server Reporting Services
2009-05-29
3,274 reads
Analyzing SQL Agent Job and Job Step History in SQL Server
You may have a number of jobs scheduled and often there is the need to analyze the data to see which jobs are taking a long time or which job steps are taking a long time. As you add more jobs and overhead to the server these times become even more critical and analyzing the data is key.
2009-05-29
3,827 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
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