When programming in T-SQL, the impact of NULL values can be severe in many cases, especially aggregates. New Author Peter Ward brings us a great explanation on how NULLs can impact things like SUM operations.
2005-12-28
11,039 reads
This article is the third in a series of four where I share my findings on baselining, monitoring, stress testing and performance tuning. It builds on the foundations of my previous articles on baselining and monitoring.
2005-12-28
3,845 reads
The first phase of Project REAL included the migration of existing SQL Server 2000 DTS packages to SQL Server 2005 Integration Services (SSIS) for a large electronic retailer. One source of information for the data warehouse was from TLog files, which contained data from point-of-sale cash registers in stores. TLog files store data in packed decimal format. To extract and transform this data into a format suitable for loading into the relational data warehouse tables, it was necessary to unpack and parse the files. To achieve this, custom pipeline components were implemented to read and transform the data by extending the SSIS object model. This paper discusses what we learned while implementing the pipeline components for extracting and parsing data from the TLog parser
2005-12-27
2,067 reads
Analyzing and detecting performance problems is a big part of a DBA's job and also one of the more difficult ones to learn. New author Terry Troisi brings us a few things that you can use the next time your server spikes to 100% CPU.
2005-12-26
17,418 reads
It has been widely publicized that Analysis Services 2005 uses XML for Analysis 1.1 (XMLA) as its only network protocol for communication between client and server. XMLA is standard public protocol defined by XMLA council and full description can be found at www.xmla.org
2005-12-26
1,771 reads
One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.
2005-12-23 (first published: 2004-04-02)
37,733 reads
2005-12-23
5,616 reads
Peter runs DeBetta Software , a consulting firm that develops data-driven enterprise solutions. He is also a programming instructor for Wintellect, a training and consulting company, and a frequent speaker on SQL Server and other subjects.
2005-12-23
1,475 reads
Have you ever lost data when using CAST or CONVERT in T-SQL? There is an interesting behavior that probably has caused problems for quite a few people, and one you should be aware of. New author Aries J. Manlig brings us a look at this documented, but mostly unheard of behavior.
2005-12-22
10,937 reads
A frustrating thing for those who open and close Query Analyzer all day long about the new Visual Studio interface for SQL Server is the load speed. This quick blog shows you how to speed up the load time with a switch change.
2005-12-22
3,765 reads
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Several times now, I've seen a post asking for a solution. I've replied, and...
Comments posted to this topic are about the item Data > Hype
Comments posted to this topic are about the item Create and Read the Analysis...
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers