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
Articles
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,276 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
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-29
801 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-29
552 reads
Reducing Database Size by Using Vardecimal Storage Format
Learn about the new storage format for storing decimal and numeric data in SQL Server 2005 SP2. Details include when and how to enable vardecimal storage format, restrictions, space savings, and its impact on the performance of your workload.
2009-05-29
2,475 reads
Blogs
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers