Improving Data Compression Fidelity Without Sacrificing Speed
Making it easier to handle huge data sets
2010-01-18
2,682 reads
Additional Articles
Database Indexing Development Lifecycle...Say What?
Creating good indexes on your database doesn't happen by mistake--you need to have a plan. Greg Larsen shows you how, beginning with a discussion on the indexing development lifecycle.
2010-01-15
3,807 reads
Using WMI Data Reader and WMI Event Watcher Tasks in SSIS
Windows Management Instrumentation (WMI) Tasks within SSIS can be used by to read WMI data and to watch for WMI events.
2010-01-14
2,270 reads
All About the Crosstab Query
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
2010-01-13
5,114 reads
Data Warehousing 2.0 and SQL Server: Architecture and Vision
Architecture and data warehousing are not static. From the first notion of a data warehouse to a full-blown analytical processing architecture that includes data marts, ETL, near line storage, exploration warehouses, and other constructs, data warehousing and its associated architecture continue to evolve. In 2008, the book on the latest evolution of data warehousing appeared – DW 2.0: The Architecture for the Next Generation of Data Warehousing (Morgan Kaufman). In that book the general architecture for data warehousing in its highest evolved form appeared.
2010-01-12
4,485 reads
Top 10 steps to optimize data access in SQL Server. Part IV (Diagnose database performance problems)
It’s time for us to learn how to diagnose different performance and related problems in SQL Server database. Take a look at the following articles to learn the step by step process that we’ve already carried out so far.
2010-01-12
5,307 reads
Manipulating Multiple Objects in SQL Server Management Studio
Every now and then, I see someone doing repetitive tasks in SQL Server Management Studio such as dropping a stored procedure one by one when they need to remove ten or scripting out a single object at a time because they can't select multiple objects from the Object Explorer. I have even seen people create elaborate scripts to perform tasks that involved manipulating multiple database objects to avoid these mundane tasks. In this tip I will show you how this can be done simply by using SQL Server Management Studio.
2010-01-11
5,770 reads
Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)
Even after you have applied proper indexing along with re-factoring your TSQLs with best practices, some data access routines might still be there, which would be expensive, in terms of their execution time. There must have been some smart ways to deal with these. Yes there are. SQL server offers you some rich indexing techniques that you might have not used earlier. These could surprise you with the performance benefits they possibly offer. Let us start implementing those advanced indexing techniques:
2010-01-08
5,310 reads
Data searches that leverage existing indexes
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on data searches, which leverage existing indexes, taking into account such features as noise words and thesaurus files.
2010-01-07
2,426 reads
Transfer database schema objects and data to another server/database with SMO
In this tip, I am going to show you how you can use SMO (SQL Server Management Objects) classes to transfer database objects and data to another server or database.
2010-01-06
3,931 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers